/* ================================================================================ 档案代号:ico_file 档案名称:ICD料件生产资讯资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ico_file ( ico01 varchar2(16) NOT NULL, /*单据编号 */ ico02 number(5) NOT NULL, /*项次 */ ico03 varchar2(10) NOT NULL, /*类别 */ /*1.正印 2.背印 */ /*3.正印备注 4.背印备注 */ /*5.FAB 6.WAFER */ /*7.单价 8.Multi Die */ /*9.生产备注 */ ico04 varchar2(5) NOT NULL, /*No. */ ico05 varchar2(1), /*Date Code否 */ ico06 varchar2(255), /*Comment */ ico07 varchar2(40), /*料号 */ icoacti varchar2(1), /*资料有效码 */ icodate date, /*最近修改日 */ icogrup varchar2(10), /*资料所有群 */ icomodu varchar2(10), /*资料更改者 */ icouser varchar2(10) /*资料所有者 */ ); create unique index ico_pk on ico_file (ico01,ico02,ico03,ico04); alter table ico_file add constraint ico_pk primary key (ico01,ico02,ico03,ico04) enable validate; grant select on ico_file to public; grant index on ico_file to public; grant update on ico_file to public; grant delete on ico_file to public; grant insert on ico_file to public; |