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