/* ================================================================================ 档案代号:bnk_file 档案名称:委外加工核准函档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bnk_file ( bnk01 varchar2(8) NOT NULL, /*核准函号码 */ bnk02 varchar2(10), /*厂商编号 */ bnk03 date, /*申请日期 */ bnk04 date, /*截止日期 */ bnk05 varchar2(1) /*是否展延 */ /*(Y/N) */ ); create unique index bnk_pk on bnk_file (bnk01); alter table bnk_file add constraint bnk_pk primary key (bnk01) enable validate; grant select on bnk_file to public; grant index on bnk_file to public; grant update on bnk_file to public; grant delete on bnk_file to public; grant insert on bnk_file to public; |