/* ================================================================================ 档案代号:imgs_file 档案名称:批号库存明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table imgs_file ( imgs01 varchar2(40) NOT NULL, /*料件编号 */ imgs02 varchar2(10) NOT NULL, /*仓库 */ imgs03 varchar2(10) NOT NULL, /*储位 */ imgs04 varchar2(24) NOT NULL, /*批号 */ imgs05 varchar2(30) NOT NULL, /*序号 */ imgs06 varchar2(30) NOT NULL, /*外部批号 */ imgs07 varchar2(4), /*库存单位 */ imgs08 number(15,3), /*数量 */ imgs09 date, /*制造日期 */ imgs10 varchar2(1), /*归属类别 */ imgs11 varchar2(16) NOT NULL /*归属单号 */ ); create unique index imgs_pk on imgs_file (imgs01,imgs02,imgs03,imgs04,imgs05,imgs06,imgs11); alter table imgs_file add constraint imgs_pk primary key (imgs01,imgs02,imgs03,imgs04,imgs05,imgs06,imgs11) enable validate; grant select on imgs_file to public; grant index on imgs_file to public; grant update on imgs_file to public; grant delete on imgs_file to public; grant insert on imgs_file to public; |