/* ================================================================================ 档案代号:vax_file 档案名称:aps(制令领料状况) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vax_file ( vax01 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vax02 varchar2(40) DEFAULT '' NOT NULL, /*元件编号*/ vax03 varchar2(60) DEFAULT '' NOT NULL, /*元件序号*/ vax04 varchar2(60), /*加工序号 */ vax05 number(15,3), /*元件已领用量 */ vax06 varchar2(10), /*库房编号 */ vax07 number(15,3), /*元件需求量 */ vax08 varchar2(10), /*库房储位 */ vax09 number(1), /*是否为客供料(0:不是 1:是) */ vax10 varchar2(6) /*备注1 */ ); create unique index vax_pk on vax_file (vax01,vax02,vax03); alter table vax_file add constraint vax_pk primary key (vax01,vax02,vax03) enable validate; grant select on vax_file to public; grant index on vax_file to public; grant update on vax_file to public; grant delete on vax_file to public; grant insert on vax_file to public; |