db create

drop table tcdt_fbs;
create table tcdt_fbs
(
fbs_seq number,
hgrnk_seq number,
pjt_cd varchar(30),
fbs_cd varchar(10),
fbs_nm varchar(100),
fbs_expln varchar(1000),
stln_seqc number,
mdfc_id varchar(15),
mdfc_dttm date,
rgst_id varchar(15),
rgst_dttm date,
primary key(fbs_seq)
);

drop index ix_tcdt_fbs_01;
create index ix_tcdt_fbs_01
on tcdt_fbs(stln_seqc asc);

drop SEQUENCE tcdt_fbs_seq;
CREATE SEQUENCE tcdt_fbs_seq
START WITH 1
INCREMENT BY 1
MINVALUE 0 NOMAXVALUE;