/*
================================================================================
档案代号:tqj_file
档案名称:客户层级关系单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqj_file
(
tqj01       varchar2(10) NOT NULL,   /*上级客户代码                           */
tqj02       number(5) NOT NULL,      /*项次                                   */
tqj03       varchar2(10) NOT NULL,   /*下级客户代码                           */
tqj04       date,                    /*生效日期                               */
tqj05       date                     /*失效日期                               */
);

create unique index tqj_pk on tqj_file (tqj01,tqj02);
alter table tqj_file add  constraint tqj_pk primary key  (tqj01,tqj02) enable validate;
grant select on tqj_file to public;
grant index on tqj_file to public;
grant update on tqj_file to public;
grant delete on tqj_file to public;
grant insert on tqj_file to public;