/* ================================================================================ 档案代号:cac_file 档案名称:成本项目分摊系数资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cac_file ( cac01 varchar2(10) NOT NULL, /*成本中心 */ cac02 varchar2(10) NOT NULL, /*成本项目 */ cac03 number(15,3) /*分摊系数 */ ); create unique index cac_pk on cac_file (cac01,cac02); alter table cac_file add constraint cac_pk primary key (cac01,cac02) enable validate; grant select on cac_file to public; grant index on cac_file to public; grant update on cac_file to public; grant delete on cac_file to public; grant insert on cac_file to public; |