/* ================================================================================ 档案代号:adt_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table adt_file ( adt01 varchar2(16) NOT NULL, /*库存调整单 */ adt02 number(5) NOT NULL, /*项次 */ adt03 varchar2(40), /*商品编号 */ adt04 varchar2(24), /*批号 */ adt05 varchar2(4), /*单位 */ adt06 number(15,3), /*数量 */ adt07 varchar2(255) /*备注 */ ); create unique index adt_pk on adt_file (adt01,adt02); alter table adt_file add constraint adt_pk primary key (adt01,adt02) enable validate; grant select on adt_file to public; grant index on adt_file to public; grant update on adt_file to public; grant delete on adt_file to public; grant insert on adt_file to public; |