/* ================================================================================ 档案代号:oci_file 档案名称:客户主档--for多角贸易相关资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oci_file ( oci01 varchar2(10) NOT NULL, /*客户编号 */ oci02 varchar2(2) NOT NULL, /*类别 */ /* 10: Remark */ /* 50: Shipping Mark */ /* 90: Notify */ /* 99: Consignee */ oci03 number(5) NOT NULL, /*序号 */ oci11 varchar2(80), /*说明一 */ /* 10: Remark char(60) */ /* 50: Shipping Mark char(20) */ /* 90: Notify char(36) */ /* 99: Consignee char(36) */ oci12 varchar2(80), /*说明二 */ oci13 varchar2(80), /*说明三 */ oci14 varchar2(80), /*说明四 */ oci15 varchar2(80), /*说明五 */ oci16 varchar2(80), /*说明六 */ oci17 varchar2(80), /*说明七 */ oci18 varchar2(80), /*说明八 */ oci19 varchar2(60), /*No Use */ oci20 varchar2(60) /*No Use */ ); create unique index oci_pk on oci_file (oci01,oci02,oci03); alter table oci_file add constraint oci_pk primary key (oci01,oci02,oci03) enable validate; grant select on oci_file to public; grant index on oci_file to public; grant update on oci_file to public; grant delete on oci_file to public; grant insert on oci_file to public; |