/* ================================================================================ 档案代号:stk_file 档案名称:销售量值统计档--By 产品别 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table stk_file ( stk01 number(5) NOT NULL, /*年度 */ stk02 number(5) NOT NULL, /*月份 */ stk03 varchar2(10) NOT NULL, /*产品别 */ stk04 number(15,3), /*销售数量 */ stk05 number(20,6), /*销售金额 */ stk06 number(20,6), /*销售成本 */ stk07 number(15,3), /*销退数量 */ stk08 number(20,6), /*销退金额 */ stk09 number(20,6) /*销退成本 */ ); create unique index stk_pk on stk_file (stk01,stk02,stk03); alter table stk_file add constraint stk_pk primary key (stk01,stk02,stk03) enable validate; grant select on stk_file to public; grant index on stk_file to public; grant update on stk_file to public; grant delete on stk_file to public; grant insert on stk_file to public; |