/*
================================================================================
档案代号:zt_file
档案名称:档案名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zt_file
(
zt01        varchar2(15) NOT NULL,   /*档案编号                               */
zt02        varchar2(80),            /*档案名称                               */
zt02e       varchar2(80),            /*档案英文名称                           */
zt02c       varchar2(80),            /*档案简体中文名称                       */
zt03        varchar2(3),             /*系统别                                 */
zt04        varchar2(4),             /*使用别                                 */
zt05        date,                    /*产生日期                               */
zt06        varchar2(10),            /*产生者                                 */
zt07        varchar2(1),             /*T/S建议 (Table/Synonym)                */
zt08        number(5),               /*No Use                                 */
zt09        varchar2(2),             /*档案类别                               */
zt10        varchar2(1),             /*No Use                                 */
zt11        varchar2(1),             /*No Use                                 */
zt12        varchar2(1),             /*No Use                                 */
zt13        varchar2(1)              /*No Use                                 */
);

create unique index zt_pk on zt_file (zt01);
alter table zt_file add  constraint zt_pk primary key  (zt01) enable validate;
grant select on zt_file to public;
grant index on zt_file to public;
grant update on zt_file to public;
grant delete on zt_file to public;
grant insert on zt_file to public;