/*
================================================================================
档案代号: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;