/* ================================================================================ 档案代号:icm_file 档案名称:ICD料件下阶制程料号资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table icm_file ( icm01 varchar2(40) NOT NULL, /*料件编号 */ icm02 varchar2(40) NOT NULL, /*下阶料 */ icm03 varchar2(255), /*Remark */ icm04 varchar2(16), /*New Code申请单号 */ icm12 varchar2(1), /*no use */ icm13 varchar2(1), /*no use */ icm14 varchar2(1), /*no use */ icm15 varchar2(1), /*no use */ icm16 varchar2(1), /*no use */ icmacti varchar2(1), /*资料有效码 */ icmdate date, /*最近修改日 */ icmgrup varchar2(10), /*资料所有群 */ icmmodu varchar2(10), /*资料更改者 */ icmuser varchar2(10) /*资料所有者 */ ); create unique index icm_pk on icm_file (icm01,icm02); alter table icm_file add constraint icm_pk primary key (icm01,icm02) enable validate; grant select on icm_file to public; grant index on icm_file to public; grant update on icm_file to public; grant delete on icm_file to public; grant insert on icm_file to public; |