/* ================================================================================ 档案代号:cnk_file 档案名称:成品进出囗报关月统计档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cnk_file ( cnk01 varchar2(20) NOT NULL, /*手册编号 */ cnk02 varchar2(40) NOT NULL, /*商品编号 */ cnk03 number(5) NOT NULL, /*年度 */ cnk04 number(5) NOT NULL, /*期别 */ cnk05 number(15,3), /*本期直接出口数量 */ cnk06 number(15,3), /*本期国外退货数量 */ cnk07 number(15,3), /*本期转厂出口数量 */ cnk08 number(15,3), /*本期转厂退货数量 */ cnk09 number(15,3), /*本期内销出货数量 */ cnk10 number(15,3), /*本期内销退货数量 */ cnk11 number(15,3), /*No Use */ cnk12 number(15,3), /*本期期末数量 */ cnk13 number(15,3), /*No Use */ cnk14 number(15,3), /*No Use */ cnk15 number(15,3) /*No Use */ ); create unique index cnk_pk on cnk_file (cnk01,cnk02,cnk03,cnk04); alter table cnk_file add constraint cnk_pk primary key (cnk01,cnk02,cnk03,cnk04) enable validate; grant select on cnk_file to public; grant index on cnk_file to public; grant update on cnk_file to public; grant delete on cnk_file to public; grant insert on cnk_file to public; |