/* ================================================================================ 档案代号:tuo_file 档案名称:寄销客户对应仓库档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tuo_file ( tuo01 varchar2(10) NOT NULL, /*客户代号 */ tuo02 varchar2(10) NOT NULL, /*送货客户 */ tuo03 varchar2(10), /*预设出货仓库 */ tuo031 varchar2(10), /*预设出货储位 */ tuo04 varchar2(10), /*预设寄销仓库 */ tuo05 varchar2(10) /*预设寄销储位 */ ); create unique index tuo_pk on tuo_file (tuo01,tuo02); alter table tuo_file add constraint tuo_pk primary key (tuo01,tuo02) enable validate; grant select on tuo_file to public; grant index on tuo_file to public; grant update on tuo_file to public; grant delete on tuo_file to public; grant insert on tuo_file to public; |