/*
================================================================================
档案代号:ztb_file
档案名称:档案名称单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ztb_file
(
ztb01       varchar2(15) NOT NULL,   /*档案编号                               */
                                     /*Table name                             */
ztb02       varchar2(10) NOT NULL,   /*database name                          */
                                     /*资料库名称                             */
ztb03       varchar2(30) NOT NULL,   /*栏位代码                               */
ztb04       varchar2(20),            /*data type                              */
                                     /*资料型态                               */
ztb05       varchar2(1),             /*属性                                   */
                                     /*属性 (p/c)                             */
ztb06       varchar2(7),             /*中文说明                               */
                                     /*开始 for datetime                      */
ztb07       varchar2(7),             /*英文说明                               */
                                     /*结束 for datetime                      */
ztb08       varchar2(8),             /*简体说明                               */
                                     /*长度                                   */
ztb09       varchar2(1),             /*No Use                                 */
ztb10       number(5),               /*No Use                                 */
ztb11       varchar2(15)             /*预设值                                 */
);

create unique index ztb_pk on ztb_file (ztb01,ztb02,ztb03);
alter table ztb_file add  constraint ztb_pk primary key  (ztb01,ztb02,ztb03) enable validate;
grant select on ztb_file to public;
grant index on ztb_file to public;
grant update on ztb_file to public;
grant delete on ztb_file to public;
grant insert on ztb_file to public;