/* ================================================================================ 档案代号:cda_file 档案名称:成本中心成本项目分摊方式资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cda_file ( cda01 varchar2(10) DEFAULT '' NOT NULL, /*成本中心*/ cda02 varchar2(10) DEFAULT '' NOT NULL, /*成本项目*/ cda04 varchar2(1), /*no use */ cda05 varchar2(24) DEFAULT '' NOT NULL, /*会计科目*/ cda06 varchar2(1), /*分摊方式 */ cda07 number(9,4) /*分摊权数 */ ); create unique index cda_pk on cda_file (cda01,cda02,cda05); alter table cda_file add constraint cda_pk primary key (cda01,cda02,cda05) enable validate; grant select on cda_file to public; grant index on cda_file to public; grant update on cda_file to public; grant delete on cda_file to public; grant insert on cda_file to public; |