/* ================================================================================ 档案代号:bwb_file 档案名称:保税工单盘点单头资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bwb_file ( bwb01 varchar2(10) NOT NULL, /*标签编号 */ bwb02 varchar2(16), /*工单号码 */ bwb03 varchar2(40), /*工单成品料号 */ bwb04 number(15,3), /*工单待入库量=预计产量-已入 */ bwb011 number(5) NOT NULL, /*盘点年度 */ bwb07 varchar2(1) /*委外工单否 */ ); create unique index bwb_pk on bwb_file (bwb01,bwb011); alter table bwb_file add constraint bwb_pk primary key (bwb01,bwb011) enable validate; grant select on bwb_file to public; grant index on bwb_file to public; grant update on bwb_file to public; grant delete on bwb_file to public; grant insert on bwb_file to public; |