/*
================================================================================
档案代号:tqb_file
档案名称:组织机构资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqb_file
(
tqb01       varchar2(10) NOT NULL,   /*组织机构代码                           */
tqb02       varchar2(80) NOT NULL,   /*组织机构名称                           */
tqb03       varchar2(10) NOT NULL,   /*组织机构类别                           */
tqbacti     varchar2(1),             /*有效否                                 */
tqbuser     varchar2(10),            /*资料所有者                             */
tqbgrup     varchar2(10),            /*资料所有部门                           */
tqbmodu     varchar2(10),            /*资料修改者                             */
tqbdate     date,                    /*最后修改日期                           */
tqb04       varchar2(1),             /*是否记录营运中心                       */
tqb05       varchar2(10)             /*营运中心代码                           */
);

create unique index tqb_pk on tqb_file (tqb01);
alter table tqb_file add  constraint tqb_pk primary key  (tqb01) enable validate;
grant select on tqb_file to public;
grant index on tqb_file to public;
grant update on tqb_file to public;
grant delete on tqb_file to public;
grant insert on tqb_file to public;