/*
================================================================================
档案代号:ogdi_file
档案名称:包装资料档
档案目的:包装资料档(行业别架构)
上游档案:
下游档案:
============.========================.==========================================
*/
create table ogdi_file
(
ogdi01      varchar2(16) DEFAULT '' NOT NULL, /*出货通知单号*/
ogdi03      number(10) DEFAULT '0' NOT NULL, /*项次*/
ogdi04      number(5) DEFAULT '0' NOT NULL, /*序号(1.整箱 234.. 并箱)*/
ogdislk01   varchar2(1)              /*包装类型                               */
);

create unique index ogdi_pk on ogdi_file (ogdi01,ogdi03,ogdi04);
alter table ogdi_file add  constraint ogdi_pk primary key  (ogdi01,ogdi03,ogdi04) enable validate;
grant select on ogdi_file to public;
grant index on ogdi_file to public;
grant update on ogdi_file to public;
grant delete on ogdi_file to public;
grant insert on ogdi_file to public;