/*
================================================================================
档案代号: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;