/* ================================================================================ 档案代号:stl_file 档案名称:销售量值统计档--By 产品别 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table stl_file ( stl01 number(5) NOT NULL, /*年度 */ stl02 number(5) NOT NULL, /*月份 */ stl03 varchar2(10) NOT NULL, /*产品别 */ stl04 number(15,3), /*销售数量 */ stl05 number(20,6), /*销售金额 */ stl06 number(20,6), /*销售成本 */ stl07 number(15,3), /*销退数量 */ stl08 number(20,6), /*销退金额 */ stl09 number(20,6) /*销退成本 */ ); create unique index stl_pk on stl_file (stl01,stl02,stl03); alter table stl_file add constraint stl_pk primary key (stl01,stl02,stl03) enable validate; grant select on stl_file to public; grant index on stl_file to public; grant update on stl_file to public; grant delete on stl_file to public; grant insert on stl_file to public; |