/* ================================================================================ 档案代号:shi_file 档案名称:工单生产日报维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table shi_file ( shi01 varchar2(16) NOT NULL, /*移转单号 */ shi02 varchar2(16) NOT NULL, /*转入工单编号 */ shi03 varchar2(6), /*作业编号 */ shi04 number(5) NOT NULL, /*制程序 */ shi05 number(15,3), /*转入数量 */ shi06 varchar2(1), /*No Use */ shi07 varchar2(1), /*No Use */ shi08 varchar2(1), /*No Use */ shi09 varchar2(1), /*No Use */ shi10 varchar2(1) /*No Use */ ); create unique index shi_pk on shi_file (shi01,shi02,shi04); alter table shi_file add constraint shi_pk primary key (shi01,shi02,shi04) enable validate; grant select on shi_file to public; grant index on shi_file to public; grant update on shi_file to public; grant delete on shi_file to public; grant insert on shi_file to public; |