/* ================================================================================ 档案代号:tqg_file 档案名称:通路关系单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tqg_file ( tqg01 varchar2(10) NOT NULL, /*上级通路代码 */ tqg02 number(5) NOT NULL, /*项次 */ tqg03 varchar2(10), /*下级通路代码 */ tqg04 date, /*生效日期 */ tqg05 date /*失效日期 */ ); create index tqg_02 on tqg_file (tqg01,tqg03); create unique index tqg_pk on tqg_file (tqg01,tqg02); alter table tqg_file add constraint tqg_pk primary key (tqg01,tqg02) enable validate; grant select on tqg_file to public; grant index on tqg_file to public; grant update on tqg_file to public; grant delete on tqg_file to public; grant insert on tqg_file to public; |