/*
================================================================================
档案代号: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;