drop table group_member;

CREATE TABLE group_member(    
rule_id                 NUMBER(20, 0)     NOT NULL,   
group_id                NUMBER(20, 0)     NOT NULL,    
member_group_id          NUMBER(20, 0)    NOT NULL,
hard_code_add_flag       NUMBER(1, 0)     NOT NULL,    
hard_code_remove_flag    NUMBER(1, 0)     NOT NULL,    
dynamic_add_flag         NUMBER(1, 0)     NOT NULL,    
touched_flag             NUMBER(1, 0)      NOT NULL,    
dynamic_deletion_flag    NUMBER(1, 0)     NOT NULL,
parent_rule_id           NUMBER(20, 0),    
parent_rule_group        VARCHAR2(2000),
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));