/*
================================================================================
档案代号:oqw_file
档案名称:生产地资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oqw_file
(
oqw01       varchar2(10) NOT NULL,   /*生产地编号                             */
oqw02       varchar2(80),            /*生产地名称                             */
oqw03       varchar2(10),            /*隶属国别编号                           */
oqwacti     varchar2(1),             /*资料有效码                             */
oqwuser     varchar2(10),            /*资料所有者                             */
oqwgrup     varchar2(10),            /*资料所有部门                           */
oqwmodu     varchar2(10),            /*资料修改者                             */
oqwdate     date                     /*最近修改日                             */
);

create unique index oqw_pk on oqw_file (oqw01);
alter table oqw_file add  constraint oqw_pk primary key  (oqw01) enable validate;
grant select on oqw_file to public;
grant index on oqw_file to public;
grant update on oqw_file to public;
grant delete on oqw_file to public;
grant insert on oqw_file to public;