/*
================================================================================
档案代号:tql_file
档案名称:客户类系列档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tql_file
(
tql01       varchar2(10) NOT NULL,   /*客户代号                               */
tql02       number(5) NOT NULL,      /*项次                                   */
tql03       varchar2(2) NOT NULL,    /*代码类别                               */
tql04       varchar2(10)             /*代码代号                               */
);

create unique index tql_pk on tql_file (tql01,tql02,tql03);
alter table tql_file add  constraint tql_pk primary key  (tql01,tql02,tql03) enable validate;
grant select on tql_file to public;
grant index on tql_file to public;
grant update on tql_file to public;
grant delete on tql_file to public;
grant insert on tql_file to public;