/*
================================================================================
档案代号:cjp_file
档案名称:联产品入库比例档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cjp_file
(
cjp01       varchar2(40) NOT NULL,   /*主件料件编号                           */
                                     /*储存该产品结构组合的主件料件编号。     */
                                     /*主件料件编号需在料件基本资料主档中。   */
cjp02       number(5) NOT NULL,      /*年度                                   */
cjp03       number(5) NOT NULL,      /*月份                                   */
cjp04       varchar2(40) NOT NULL,   /*联产品料件号编号                       */
                                     /*储存该主件联产品料号                   */
                                     /*元件料件编号需在料件基本资料主档中。   */
cjp05       varchar2(4),             /*联产品单位                             */
                                     /*储存该联产品的单位                     */
cjp06       number(9,4)              /*分配率                                 */
);

create unique index cjp_pk on cjp_file (cjp01,cjp02,cjp03,cjp04);
alter table cjp_file add  constraint cjp_pk primary key  (cjp01,cjp02,cjp03,cjp04) enable validate;
grant select on cjp_file to public;
grant index on cjp_file to public;
grant update on cjp_file to public;
grant delete on cjp_file to public;
grant insert on cjp_file to public;