/*
================================================================================
档案代号:oge_file
档案名称:出货唛头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oge_file
(
oge01       varchar2(16) NOT NULL,   /*出货单号                               */
oge101      varchar2(30),            /*正唛                                   */
oge102      varchar2(30),            /*正唛                                   */
oge103      varchar2(30),            /*正唛                                   */
oge104      varchar2(30),            /*正唛                                   */
oge105      varchar2(30),            /*正唛                                   */
oge106      varchar2(30),            /*正唛                                   */
oge107      varchar2(30),            /*正唛                                   */
oge108      varchar2(30),            /*正唛                                   */
oge109      varchar2(30),            /*正唛                                   */
oge110      varchar2(30),            /*正唛                                   */
oge111      varchar2(30),            /*正唛                                   */
oge112      varchar2(30),            /*正唛                                   */
oge201      varchar2(30),            /*侧唛                                   */
oge202      varchar2(30),            /*侧唛                                   */
oge203      varchar2(30),            /*侧唛                                   */
oge204      varchar2(30),            /*侧唛                                   */
oge205      varchar2(30),            /*侧唛                                   */
oge206      varchar2(30),            /*侧唛                                   */
oge207      varchar2(30),            /*侧唛                                   */
oge208      varchar2(30),            /*侧唛                                   */
oge209      varchar2(30),            /*侧唛                                   */
oge210      varchar2(30),            /*侧唛                                   */
oge211      varchar2(30),            /*侧唛                                   */
oge212      varchar2(30)             /*侧唛                                   */
);

create unique index oge_pk on oge_file (oge01);
alter table oge_file add  constraint oge_pk primary key  (oge01) enable validate;
grant select on oge_file to public;
grant index on oge_file to public;
grant update on oge_file to public;
grant delete on oge_file to public;
grant insert on oge_file to public;