/*
================================================================================
档案代号:cna_file
档案名称:海关基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cna_file
(
cna01       varchar2(10) NOT NULL,   /*海关代号                               */
cna02       varchar2(80),            /*海关名称                               */
cna03       varchar2(40),            /*海关简称                               */
cna04       varchar2(10),            /*报关方式                               */
cna05       varchar2(1),             /*No Use                                 */
cna06       varchar2(1),             /*No Use                                 */
cna07       varchar2(1),             /*No Use                                 */
cnaacti     varchar2(1),             /*资料有效码                             */
cnauser     varchar2(10),            /*资料所有者                             */
cnagrup     varchar2(10),            /*资料所有部门                           */
cnamodu     varchar2(10),            /*资料修改者                             */
cnadate     date                     /*最近修改日                             */
);

create unique index cna_pk on cna_file (cna01);
alter table cna_file add  constraint cna_pk primary key  (cna01) enable validate;
grant select on cna_file to public;
grant index on cna_file to public;
grant update on cna_file to public;
grant delete on cna_file to public;
grant insert on cna_file to public;