/*
================================================================================
档案代号:tqd_file
档案名称:集团组织机构单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqd_file
(
tqd01       varchar2(10) NOT NULL,   /*上级组织机构代码                       */
tqd02       number(5) NOT NULL,      /*项次                                   */
tqd03       varchar2(10),            /*下级组织机构代码                       */
tqd04       varchar2(10),            /*所属通路代码                           */
tqd05       date,                    /*生效日期                               */
tqd06       date                     /*失效日期                               */
);

create        index tqd_02 on tqd_file (tqd01,tqd03);
create unique index tqd_pk on tqd_file (tqd01,tqd02);
alter table tqd_file add  constraint tqd_pk primary key  (tqd01,tqd02) enable validate;
grant select on tqd_file to public;
grant index on tqd_file to public;
grant update on tqd_file to public;
grant delete on tqd_file to public;
grant insert on tqd_file to public;