/* ================================================================================ 档案代号:caj_file 档案名称:固定/变动成本分析资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table caj_file ( caj01 number(5) NOT NULL, /*年度 */ caj02 number(5) NOT NULL, /*月份 */ caj04 varchar2(40) NOT NULL, /*主件料号 */ /*需存在在料件基本资料主档 */ caj05 number(20,6), /*本月投入金额 */ caj06 number(20,6), /*固定成本 */ caj07 number(20,6) /*变动成本 */ ); create unique index caj_pk on caj_file (caj01,caj02,caj04); alter table caj_file add constraint caj_pk primary key (caj01,caj02,caj04) enable validate; grant select on caj_file to public; grant index on caj_file to public; grant update on caj_file to public; grant delete on caj_file to public; grant insert on caj_file to public; |