/*
================================================================================
档案代号:pjw_file
档案名称:poc取得方式
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjw_file
(
pjw01       varchar2(10) NOT NULL,   /*方式编号                               */
pjw02       varchar2(80),            /*说明                                   */
pjw03       varchar2(1),             /*类型                                   */
pjw04       number(10),              /*起始值                                 */
pjw05       number(10),              /*上限值                                 */
pjwacti     varchar2(1),             /*资料有效码                             */
pjwdate     date,                    /*最近修改日                             */
pjwgrup     varchar2(10),            /*资料所有部门                           */
pjwmodu     varchar2(10),            /*资料修改者                             */
pjwuser     varchar2(10)             /*资料所有者                             */
);

create unique index pjw_pk on pjw_file (pjw01);
alter table pjw_file add  constraint pjw_pk primary key  (pjw01) enable validate;
grant select on pjw_file to public;
grant index on pjw_file to public;
grant update on pjw_file to public;
grant delete on pjw_file to public;
grant insert on pjw_file to public;