/*
================================================================================
档案代号:pms_file
档案名称:常用特殊说明单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pms_file
(
pms01       varchar2(4) NOT NULL,    /*特殊常用说明编号                       */
pms02       varchar2(255)            /*备注                                   */
                                     /*本栏位可以输入一些简要说明, 在查询时可以*/
                                     /*很快分辨出特殊常用说明编号的用意, 以加速*/
                                     /*特殊常用说明之使用                     */
);

create unique index pms_pk on pms_file (pms01);
alter table pms_file add  constraint pms_pk primary key  (pms01) enable validate;
grant select on pms_file to public;
grant index on pms_file to public;
grant update on pms_file to public;
grant delete on pms_file to public;
grant insert on pms_file to public;