/*
================================================================================
档案代号:zob_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zob_file
(
zob01       varchar2(10) NOT NULL,   /*资料代号                               */
zob02       varchar2(15) NOT NULL,   /*档案代号                               */
zob03       varchar2(1),             /*必要否                                 */
zob04       varchar2(1),             /*汇入否                                 */
zob05       varchar2(1)              /*仅汇出人工输入字段                     */
);

create unique index zob_pk on zob_file (zob01,zob02);
alter table zob_file add  constraint zob_pk primary key  (zob01,zob02) enable validate;
grant select on zob_file to public;
grant index on zob_file to public;
grant update on zob_file to public;
grant delete on zob_file to public;
grant insert on zob_file to public;