/* ================================================================================ 档案代号:oze_file 档案名称:ESC平台资讯档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oze_file ( oze01 varchar2(16) NOT NULL, /*出货单 */ oze02 number(5) NOT NULL, /*出货单项次 */ oze03 number(5) NOT NULL, /*序号 */ oze04 varchar2(1), /*运输模式 */ oze05 varchar2(30), /*货运代码 */ oze06 varchar2(20), /*运输业者代码 */ oze07 varchar2(30), /*起运港 */ oze08 varchar2(30), /*卸货港 */ oze09 varchar2(14), /*到货时间 */ oze10 varchar2(30), /*船名 */ oze11 varchar2(30) /*船次 */ ); create index oze_02 on oze_file (oze04,oze05,oze06,oze07,oze08); create unique index oze_pk on oze_file (oze01,oze02,oze03); alter table oze_file add constraint oze_pk primary key (oze01,oze02,oze03) enable validate; grant select on oze_file to public; grant index on oze_file to public; grant update on oze_file to public; grant delete on oze_file to public; grant insert on oze_file to public; |