/* ================================================================================ 档案代号:stm_file 档案名称:生产量值统计档--By 产品别 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table stm_file ( stm01 number(5) NOT NULL, /*年度 */ stm02 number(5) NOT NULL, /*月份 */ stm03 varchar2(10) NOT NULL, /*产品别 */ stm04 number(15,3), /*生产数量 */ stm05 number(20,6), /*生产成本 */ stm06 number(15,3), /*生产数量 */ /*生产数量(不含重工) */ stm07 number(20,6) /*生产成本 */ /*生产成本(不含重工) */ ); create unique index stm_pk on stm_file (stm01,stm02,stm03); alter table stm_file add constraint stm_pk primary key (stm01,stm02,stm03) enable validate; grant select on stm_file to public; grant index on stm_file to public; grant update on stm_file to public; grant delete on stm_file to public; grant insert on stm_file to public; |