/*
================================================================================
档案代号:tqf_file
档案名称:通路关系单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqf_file
(
tqf01       varchar2(10) NOT NULL,   /*上级通路代码                           */
tqf02       date,                    /*生效日期                               */
tqf03       date,                    /*失效日期                               */
tqfacti     varchar2(1),             /*资料有效否                             */
tqfuser     varchar2(10),            /*资料所有者                             */
tqfgrup     varchar2(10),            /*资料所有群                             */
tqfmodu     varchar2(10),            /*资料修改者                             */
tqfdate     date                     /*最近修改日期                           */
);

create unique index tqf_pk on tqf_file (tqf01);
alter table tqf_file add  constraint tqf_pk primary key  (tqf01) enable validate;
grant select on tqf_file to public;
grant index on tqf_file to public;
grant update on tqf_file to public;
grant delete on tqf_file to public;
grant insert on tqf_file to public;