/*
================================================================================
档案代号:zoc_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zoc_file
(
zoc01       varchar2(15) NOT NULL,   /*档案代号                               */
zoc02       varchar2(20) NOT NULL,   /*栏位代号                               */
zoc03       varchar2(20),            /*型态                                   */
zoc04       varchar2(8),             /*长度                                   */
zoc05       varchar2(1),             /*资料类型                               */
zoc06       varchar2(100),           /*资料预设值                             */
zoc07       varchar2(15),            /*资料判断档案                           */
zoc08       varchar2(20),            /*资料判断栏位                           */
zoc09       varchar2(20),            /*关联key值                              */
zoc10       varchar2(255),           /*资料检核逻辑                           */
zoc11       varchar2(255)            /*资料说明                               */
);

create unique index zoc_pk on zoc_file (zoc01,zoc02);
alter table zoc_file add  constraint zoc_pk primary key  (zoc01,zoc02) enable validate;
grant select on zoc_file to public;
grant index on zoc_file to public;
grant update on zoc_file to public;
grant delete on zoc_file to public;
grant insert on zoc_file to public;