/*
================================================================================
档案代号:pjma_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjma_file
(
pjma01      varchar2(30) NOT NULL,   /*本阶wbs编码                            */
pjma02      number(5) NOT NULL,      /*项次                                   */
pjma03      varchar2(10),            /*设备类型                               */
pjma04      number(10),              /*台数                                   */
pjma05      number(15,3),            /*需求量(使用时间)                       */
pjmaacti    varchar2(1),             /*资料有效码                             */
pjmadate    date,                    /*最近修改日                             */
pjmagrup    varchar2(10),            /*资料所有部门                           */
pjmamodu    varchar2(10),            /*资料修改者                             */
pjmauser    varchar2(10)             /*资料所有者                             */
);

create unique index pjma_pk on pjma_file (pjma01,pjma02);
alter table pjma_file add  constraint pjma_pk primary key  (pjma01,pjma02) enable validate;
grant select on pjma_file to public;
grant index on pjma_file to public;
grant update on pjma_file to public;
grant delete on pjma_file to public;
grant insert on pjma_file to public;