/* ================================================================================ 档案代号:bhb_file 档案名称:费用项目提拨单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bhb_file ( bhb01 varchar2(10) NOT NULL, /*版本 */ bhb02 number(5) NOT NULL, /*年度 */ bhb03 varchar2(6) NOT NULL, /*费用项目 */ bhb04 varchar2(6) NOT NULL, /*来源费用项目 */ bhb05 varchar2(1), /*提拨方式 */ /*提拨方式 1.固定金额 2.比率 */ bhb06 number(20,6) /*提拨比率或金额 */ ); create unique index bhb_pk on bhb_file (bhb01,bhb02,bhb03,bhb04); alter table bhb_file add constraint bhb_pk primary key (bhb01,bhb02,bhb03,bhb04) enable validate; grant select on bhb_file to public; grant index on bhb_file to public; grant update on bhb_file to public; grant delete on bhb_file to public; grant insert on bhb_file to public; |