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