/* ================================================================================ 档案代号:cme_file 档案名称:料件分类毛利费用率维护 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cme_file ( cme01 number(5) NOT NULL, /*年度 */ cme02 number(5) NOT NULL, /*月份 */ cme03 varchar2(10) NOT NULL, /*成本分群 */ cme04 number(15,3), /*销售费用率 */ cme05 number(15,3), /*销售毛利率 */ cme031 varchar2(10) DEFAULT '' NOT NULL, /*产品分类*/ cme06 varchar2(1) DEFAULT '1' NOT NULL /*料件分类来源*/ ); create unique index cme_pk on cme_file (cme01,cme02,cme03,cme031,cme06); alter table cme_file add constraint cme_pk primary key (cme01,cme02,cme03,cme031,cme06) enable validate; grant select on cme_file to public; grant index on cme_file to public; grant update on cme_file to public; grant delete on cme_file to public; grant insert on cme_file to public; |