/* ================================================================================ 档案代号:cne_file 档案名称:成品进出口报关日统计档 档案目的:记录每笔成品进出口报关之统计资料 上游档案: 下游档案: ============.========================.========================================== */ create table cne_file ( cne01 varchar2(20) NOT NULL, /*手册编号 */ cne02 varchar2(40) NOT NULL, /*商品编号 */ cne03 date NOT NULL, /*日期 */ cne04 number(5), /*No Use */ cne05 number(15,3), /*本日直接出口数量 */ cne06 number(15,3), /*本日国外退货数量 */ cne07 number(15,3), /*本日转厂出口数量 */ cne08 number(15,3), /*本日转厂退货数量 */ cne09 number(15,3), /*本日内销出货数量 */ cne10 number(15,3), /*本日内销退货数量 */ cne11 number(15,3), /*No Use */ cne12 number(15,3), /*本日结余数量 */ cne13 number(15,3), /*No Use */ cne14 number(15,3), /*No Use */ cne15 number(15,3) /*No Use */ ); create unique index cne_pk on cne_file (cne01,cne02,cne03); alter table cne_file add constraint cne_pk primary key (cne01,cne02,cne03) enable validate; grant select on cne_file to public; grant index on cne_file to public; grant update on cne_file to public; grant delete on cne_file to public; grant insert on cne_file to public; |