/* ================================================================================ 档案代号:cdb_file 档案名称:每月人工/制费档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cdb_file ( cdb01 number(5) DEFAULT '0' NOT NULL, /*年度*/ cdb02 number(5) DEFAULT '0' NOT NULL, /*月份*/ cdb03 varchar2(10) DEFAULT '' NOT NULL, /*成本中心*/ cdb04 varchar2(10) DEFAULT '' NOT NULL, /*成本项目*/ cdb05 number(15,3) DEFAULT '0' NOT NULL, /*成本*/ cdb06 number(15,3) DEFAULT '0' NOT NULL, /*分摊基础指标总数*/ cdb07 number(15,6) DEFAULT '0' NOT NULL, /*单位成本*/ cdb08 varchar2(1) DEFAULT '' NOT NULL, /*分摊方式*/ cdbdate date, /*最近修改日 */ cdbgrup varchar2(10), /*资料所有部门 */ cdbmodu varchar2(10), /*资料修改者 */ cdbuser varchar2(10) /*资料所有者 */ ); create unique index cdb_pk on cdb_file (cdb01,cdb02,cdb03,cdb04,cdb08); alter table cdb_file add constraint cdb_pk primary key (cdb01,cdb02,cdb03,cdb04,cdb08) enable validate; grant select on cdb_file to public; grant index on cdb_file to public; grant update on cdb_file to public; grant delete on cdb_file to public; grant insert on cdb_file to public; |