/*
================================================================================
档案代号:tqi_file
档案名称:客户层级关系单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqi_file
(
tqi01       varchar2(10) NOT NULL,   /*上级客户代码                           */
tqi02       date,                    /*生效日期                               */
tqi03       date,                    /*失效日期                               */
tqiacti     varchar2(1),             /*有效码                                 */
tqiuser     varchar2(10),            /*资料所有者                             */
tqigrup     varchar2(10),            /*资料所有部门                           */
tqimodu     varchar2(10),            /*资料修改者                             */
tqidate     date                     /*最近修改日                             */
);

create unique index tqi_pk on tqi_file (tqi01);
alter table tqi_file add  constraint tqi_pk primary key  (tqi01) enable validate;
grant select on tqi_file to public;
grant index on tqi_file to public;
grant update on tqi_file to public;
grant delete on tqi_file to public;
grant insert on tqi_file to public;