/*
================================================================================
档案代号:obi_file
档案名称:混合包装方式档
档案目的:混合包装方式单头档
上游档案:
下游档案:
============.========================.==========================================
*/
create table obi_file
(
obi01       varchar2(16) DEFAULT '' NOT NULL, /*混装编号*/
obi02       varchar2(80),            /*包装说明                               */
obi03       number(15,3),            /*包装长度                               */
obi04       number(15,3),            /*包装宽度                               */
obi05       number(15,3),            /*包装高度                               */
obi06       number(15,3),            /*包装内长                               */
obi07       number(15,3),            /*包装内宽                               */
obi08       number(15,3),            /*包装内高                               */
obi09       number(15,3),            /*包装体积                               */
obi10       number(15,3),            /*包装容积                               */
obi11       number(15,3),            /*包装重量                               */
obi12       varchar2(10),            /*末维属性组                             */
obi13       varchar2(255),           /*备注                                   */
obi14       varchar2(10),            /*属性群组                               */
obiacti     varchar2(1),             /*资料有效码                             */
obidate     date,                    /*资料修改日期                           */
obigrup     varchar2(10),            /*资料所属群组                           */
obimodu     varchar2(10),            /*资料修改者                             */
obiuser     varchar2(10)             /*资料所有者                             */
);

create unique index obi_pk on obi_file (obi01);
alter table obi_file add  constraint obi_pk primary key  (obi01) enable validate;
grant select on obi_file to public;
grant index on obi_file to public;
grant update on obi_file to public;
grant delete on obi_file to public;
grant insert on obi_file to public;