create table user_mast (user_ID varchar (256) not null, password varchar(256), f_name varchar(256), l_name varchar(256), location varchar(256), phone varchar(256), email varchar(256), title varchar(256), role varchar(256),constraint pkcons primary key (user_ID) index pagesize 2k);create table project_mast (proj_ID varchar (256) not null, proj_name varchar(256), group varchar(256), lead varchar(256), desc varchar(256), constraint pkcons primary key (proj_ID) index pagesize 2kconstraint fk_user foreign key (lead) references user_mast (user_ID) index pagesize 2k);create table task_mast (task_ID varchar (256) not null, task_name varchar(256), plan_start_dt date, plan_end_dt date, act_start_dt date, act_end_dt date, status varchar(256), predecessor varchar(256), project varchar(256), task_desc varchar(256),  type varchar(256), comment varchar(256),constraint pkcons primary key (task_ID) index pagesize 2kconstraint fk_proj foreign key (project) references project_mast (proj_ID) index pagesize 2k);create table state_mast (state_ID varchar (256) not null, state_name varchar(256), plan_start_dt date, plan_end_dt date, act_start_dt date, act_end_dt date, status varchar(256), project varchar(256), state_desc varchar(256), comment varchar(256),constraint pkcons primary key (state_ID) index pagesize 2kconstraint fk_proj foreign key (project) references project_mast (proj_ID) index pagesize 2k);create table activity_mast (act_ID varchar (256) not null, act_name varchar(256), parent_task varchar(256), resp_engineer varchar(256), plan_start_dt date, plan_end_dt date, act_st_dt date, act_end_dt date, status varchar(256), reason varchar(1024), act_desc varchar(256), comment varchar(256),constraint pkcons primary key (act_ID) index pagesize 2kconstraint fk_task foreign key (parent_task) references task_mast (task_ID) index pagesize 2kconstraint fk_task foreign key (resp_engineer) references user_mast (user_ID) index pagesize 2k);create table assignment_mast (assign_ID varchar (256) not null, assign_name varchar(256), task varchar(256), user varchar(256), desc varchar(256), comment varchar(256), constraint pkcons primary key (assign_ID) index pagesize 2kconstraint fk_task foreign key (task) references task_mast (task_ID) index pagesize 2kconstraint fk_user foreign key (user) references user_mast (user_ID) index pagesize 2k);insert into user_mast values ( 'tomcat',  'sqe',  'first name',  'last name',  'SCA14', ' ', 'tomat-test@sun.com', 'tomat-testgroup', 'engineer');