/* ================================================================================ 档案代号:bgk_file 档案名称:费用基础金额档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bgk_file ( bgk01 varchar2(10) NOT NULL, /*版本 */ bgk02 varchar2(10) NOT NULL, /*部门编号 */ bgk03 varchar2(6) NOT NULL, /*分摊类别 */ bgk04 number(20,6), /*金额 */ bgk05 varchar2(1) /*No Use */ ); create unique index bgk_pk on bgk_file (bgk01,bgk02,bgk03); alter table bgk_file add constraint bgk_pk primary key (bgk01,bgk02,bgk03) enable validate; grant select on bgk_file to public; grant index on bgk_file to public; grant update on bgk_file to public; grant delete on bgk_file to public; grant insert on bgk_file to public; |