/* ================================================================================ 档案代号:oap_file 档案名称:单据出货地址档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oap_file ( oap01 varchar2(16) NOT NULL, /*单据单号 */ oap02 varchar2(1), /*No Use */ oap03 varchar2(80), /*全名 */ /*全名 (no use) */ oap041 varchar2(255), /*地址 */ oap042 varchar2(255), /*地址 */ oap043 varchar2(255), /*地址 */ oap044 varchar2(255), /*地址-4 */ oap045 varchar2(255) /*地址-5 */ ); create unique index oap_pk on oap_file (oap01); alter table oap_file add constraint oap_pk primary key (oap01) enable validate; grant select on oap_file to public; grant index on oap_file to public; grant update on oap_file to public; grant delete on oap_file to public; grant insert on oap_file to public; |