/*
================================================================================
档案代号:pjl_file
档案名称:网络活动关系基本资料设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjl_file
(
pjl01       varchar2(10) NOT NULL,   /*网络代号                               */
pjl02       varchar2(4) NOT NULL,    /*前活动代号                             */
pjl03       varchar2(4) NOT NULL,    /*活动代号                               */
pjl04       varchar2(1),             /*关系类型                               */
pjl05       number(15,3),            /*松弛时间                               */
pjldate     date,                    /*最近修改日期                           */
pjlgrup     varchar2(10),            /*资料所有部门                           */
pjlmodu     varchar2(10),            /*资料修改者                             */
pjluser     varchar2(10)             /*资料所有者                             */
);

create unique index pjl_pk on pjl_file (pjl01,pjl02,pjl03);
alter table pjl_file add  constraint pjl_pk primary key  (pjl01,pjl02,pjl03) enable validate;
grant select on pjl_file to public;
grant index on pjl_file to public;
grant update on pjl_file to public;
grant delete on pjl_file to public;
grant insert on pjl_file to public;