/*
================================================================================
档案代号:tqc_file
档案名称:集团组织机构单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqc_file
(
tqc01       varchar2(10) NOT NULL,   /*上级组织机构代码                       */
tqc02       date,                    /*生效日期                               */
tqc03       date,                    /*实效日期                               */
tqcacti     varchar2(1),             /*资料有效否                             */
tqcuser     varchar2(10),            /*资料所有者                             */
tqcgrup     varchar2(10),            /*资料所有群                             */
tqcmodu     varchar2(10),            /*资料修改者                             */
tqcdate     date                     /*最近修改日期                           */
);

create unique index tqc_pk on tqc_file (tqc01);
alter table tqc_file add  constraint tqc_pk primary key  (tqc01) enable validate;
grant select on tqc_file to public;
grant index on tqc_file to public;
grant update on tqc_file to public;
grant delete on tqc_file to public;
grant insert on tqc_file to public;