/* ================================================================================ 档案代号:icz_file 档案名称:库存Hold批Log档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table icz_file ( icz01 varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/ icz02 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ icz03 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ icz04 varchar2(24) DEFAULT '' NOT NULL, /*批号*/ icz05 varchar2(1), /*状态 */ /*1.Hold 2.Relase */ icz06 varchar2(255), /*说明 */ icz07 date, /*异动日期 */ icz08 varchar2(1), /*no use */ icz09 varchar2(40), /*母体料号 */ icz10 varchar2(24), /*母批 */ iczdate date, /*最近修改日 */ iczgrup varchar2(10), /*资料所有部门 */ iczmodu varchar2(10), /*资料修改者 */ iczuser varchar2(10) /*资料所有者 */ ); create unique index icz_pk on icz_file (icz01,icz02,icz03,icz04); alter table icz_file add constraint icz_pk primary key (icz01,icz02,icz03,icz04) enable validate; grant select on icz_file to public; grant index on icz_file to public; grant update on icz_file to public; grant delete on icz_file to public; grant insert on icz_file to public; |