/*
================================================================================
档案代号:rpe_file
档案名称:族群料件关连档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rpe_file
(
rpe01       varchar2(40) NOT NULL,   /*族群料件                               */
                                     /*必须其来源码性质为Family Part,Configue */
                                     /*Part ('A','C')                         */
                                     /*Family Part 之成员组件为(F,C)          */
                                     /*Configue Part 之成员组件为(T)          */
rpe02       number(5) NOT NULL,      /*序号                                   */
                                     /*此为系统内部自行维护序号               */
rpe03       varchar2(40) NOT NULL,   /*成员料件                               */
                                     /*必须其来源码性质为Family Part, Configur-*/
                                     /*ed part,FAS(T)                         */
rpe04       date NOT NULL,           /*生效日期                               */
rpe05       date                     /*失效日期                               */
);

create unique index rpe_pk on rpe_file (rpe01,rpe02,rpe03,rpe04);
alter table rpe_file add  constraint rpe_pk primary key  (rpe01,rpe02,rpe03,rpe04) enable validate;
grant select on rpe_file to public;
grant index on rpe_file to public;
grant update on rpe_file to public;
grant delete on rpe_file to public;
grant insert on rpe_file to public;