/*
================================================================================
档案代号:pmy_file
档案名称:厂商分类代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmy_file
(
pmy01       varchar2(10) NOT NULL,   /*厂商分类代码                           */
pmy02       varchar2(80),            /*厂商分类说明                           */
pmy03       varchar2(1),             /*No Use                                 */
pmy04       varchar2(1),             /*No Use                                 */
pmy05       varchar2(1),             /*No Use                                 */
pmy06       varchar2(1),             /*No Use                                 */
pmy07       varchar2(1),             /*No Use                                 */
pmy08       varchar2(1),             /*No Use                                 */
pmy09       varchar2(1),             /*No Use                                 */
pmy10       varchar2(1),             /*No Use                                 */
pmyacti     varchar2(1),             /*资料有效码                             */
pmyuser     varchar2(10),            /*资料所有者                             */
pmygrup     varchar2(10),            /*资料所有部门                           */
pmymodu     varchar2(10),            /*资料修改者                             */
pmydate     date                     /*最近修改日                             */
);

create unique index pmy_pk on pmy_file (pmy01);
alter table pmy_file add  constraint pmy_pk primary key  (pmy01) enable validate;
grant select on pmy_file to public;
grant index on pmy_file to public;
grant update on pmy_file to public;
grant delete on pmy_file to public;
grant insert on pmy_file to public;