/* ================================================================================ 档案代号:adb_file 档案名称:集团组织单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table adb_file ( adb01 varchar2(10) NOT NULL, /*上层公司编号 */ adb02 varchar2(10) NOT NULL, /*下层公司编号 */ adb03 date, /*生效日期 */ adb04 date, /*失效日期 */ adb05 varchar2(1), /*转拨计价方式 */ adb06 number(9,4) /*转拨百分比 */ ); create index adb_02 on adb_file (adb02); create unique index adb_pk on adb_file (adb01,adb02); alter table adb_file add constraint adb_pk primary key (adb01,adb02) enable validate; grant select on adb_file to public; grant index on adb_file to public; grant update on adb_file to public; grant delete on adb_file to public; grant insert on adb_file to public; |