/* ================================================================================ 档案代号:ecw_file 档案名称:制程资料作业描述说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ecw_file ( ecw01 varchar2(40) NOT NULL, /*料件编号 */ ecw02 varchar2(10) NOT NULL, /*制程编号 */ ecw03 number(5) NOT NULL, /*作业序号 */ ecw04 date, /*生效日期 */ ecw05 number(5) NOT NULL, /*行序号 */ ecw06 varchar2(80) /*说明 */ ); create unique index ecw_pk on ecw_file (ecw01,ecw02,ecw03,ecw05); alter table ecw_file add constraint ecw_pk primary key (ecw01,ecw02,ecw03,ecw05) enable validate; grant select on ecw_file to public; grant index on ecw_file to public; grant update on ecw_file to public; grant delete on ecw_file to public; grant insert on ecw_file to public; |