drop table grouping;

CREATE TABLE grouping(    
group_id                      NUMBER(20, 0)     NOT NULL,
group_name                    VARCHAR2(255)     NOT NULL,    
group_type_code               VARCHAR2(10)      NOT NULL,    
access_group_flag             NUMBER(1, 0)      NOT NULL,
live_flag                     NUMBER(1, 0)      NOT NULL,    
choke_point_flag              NUMBER(1, 0)      NOT NULL,    
private_name_flag             NUMBER(1, 0)      NOT NULL,
private_membership_flag       NUMBER(1, 0)      NOT NULL,    
private_resources_flag        NUMBER(1, 0)      NOT NULL,    
hidden_name_flag              NUMBER(1, 0)      NOT NULL,
hidden_membership_flag        NUMBER(1, 0)      NOT NULL,    
hidden_resources_flag         NUMBER(1, 0)      NOT NULL,    
group_editable_flag           NUMBER(1, 0)      NOT NULL,
group_deletable_flag          NUMBER(1, 0)      NOT NULL,    
auto_deletion_flag            NUMBER(1, 0)      NOT NULL,    
self_add_flag                 NUMBER(1, 0)      NOT NULL,
generate_alias_group_flag     NUMBER(1, 0)      NOT NULL,    
resources_to_children_flag    NUMBER(1, 0)      NOT NULL,    
resources_from_parent_flag    NUMBER(1, 0)      NOT NULL,
entity_id                     NUMBER(20, 0),    
entity_type_code              VARCHAR2(10),
alias_group_prefix            VARCHAR2(10),    
alias_group_suffix            VARCHAR2(10),
parent_group_id               NUMBER(10, 0),    
owner_entity_id               NUMBER(20, 0)     NOT NULL,    
viewer_entity_type_code       NUMBER(30, 0)     NOT NULL,
owner_entity_type_code        CHAR(10),    
viewer_entity_id              NUMBER(20, 0)     NOT NULL,    
effective_date                DATE,    
expiration_date               DATE,
last_gen_date                 DATE,    
member_test_procedure_name    VARCHAR2(100),
member_test_procedure_code    VARCHAR2(2000),    
procedure_name                VARCHAR2(10),
procedure_code                LONG,    
created_by                    NUMBER(20, 0),
created_date                  DATE,    
last_modified_by              NUMBER(20, 0),
last_modified_date            DATE,    
marked_for_deletion           NUMBER(1, 0)      DEFAULT 0,    
process_change_flag           NUMBER(1, 0)      DEFAULT 0,    
process_insert_flag           NUMBER(1, 0)      DEFAULT 0,    
source_institution_id         NUMBER(20, 0),
data_source_key               VARCHAR2(2000));