/* ================================================================================ 档案代号:sfci_file 档案名称:料表批号主档(行业别架构) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table sfci_file ( sfci01 varchar2(16) DEFAULT '' NOT NULL, /*料表批号 (pbi number)储存合并 */ sfcislk01 varchar2(16), /*制单号 行业别栏位 */ sfcislk02 date, /*预计齐料日 */ sfcislk03 date, /*实际齐料日 */ sfcislk04 varchar2(1), /*是否版单 */ sfcislk05 varchar2(1) /*审核码 */ ); create unique index sfci_pk on sfci_file (sfci01); alter table sfci_file add constraint sfci_pk primary key (sfci01) enable validate; grant select on sfci_file to public; grant index on sfci_file to public; grant update on sfci_file to public; grant delete on sfci_file to public; grant insert on sfci_file to public; |