/* ================================================================================ 档案代号:tsi_file 档案名称:订单/采购单抛转单别设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tsi_file ( tsi01 varchar2(5) NOT NULL, /*订单单别 */ tsi02 varchar2(5) NOT NULL /*采购单别 */ ); create unique index tsi_pk on tsi_file (tsi01); alter table tsi_file add constraint tsi_pk primary key (tsi01) enable validate; grant select on tsi_file to public; grant index on tsi_file to public; grant update on tsi_file to public; grant delete on tsi_file to public; grant insert on tsi_file to public; |