/* ================================================================================ 档案代号: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; |