/*
================================================================================
档案代号:coz_file
档案名称:海关合同参数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table coz_file
(
coz00       varchar2(1) NOT NULL,    /*KEY VALUE = '0'                        */
coz01       varchar2(1),             /*目前海关系统可开放给使用者             */
                                     /*目前海关系统是否可开放使用者使用(Y/N)? */
                                     /*Y: 正常使用                            */
                                     /*N: 仅供使用者列印查询                  */
                                     /*不可作资料的新增,修改,查询,删除        */
coz02       varchar2(10),            /*预设海关代号                           */
coz03       varchar2(1),             /*海关代号                               */
coz04       varchar2(1),             /*No Use                                 */
coz05       varchar2(1),             /*No Use                                 */
coz06       number(5),               /*No Use                                 */
coz07       number(5),               /*No Use                                 */
coz08       number(5),               /*No Use                                 */
coz09       number(5),               /*No Use                                 */
coz10       number(5)                /*No Use                                 */
);

create unique index coz_pk on coz_file (coz00);
alter table coz_file add  constraint coz_pk primary key  (coz00) enable validate;
grant select on coz_file to public;
grant index on coz_file to public;
grant update on coz_file to public;
grant delete on coz_file to public;
grant insert on coz_file to public;