/* ================================================================================ 档案代号:ocd_file 档案名称:客户其它地址档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ocd_file ( ocd01 varchar2(10) NOT NULL, /*客户编号 */ ocd02 varchar2(10) NOT NULL, /*客户地址 */ ocd03 varchar2(80), /*说明 */ ocd04 varchar2(10), /*邮递区号 */ ocd221 varchar2(255), /*地址-1 */ ocd222 varchar2(255), /*地址-2 */ ocd223 varchar2(255), /*地址-3 */ ocd224 varchar2(40), /*电话-1 */ ocd225 varchar2(40), /*电话-2 */ ocd226 varchar2(40), /*传真-1 */ ocd227 varchar2(40), /*传真-2 */ ocd228 varchar2(40), /*联络人-1 */ ocd229 varchar2(40), /*联络人-2 */ ocd230 varchar2(255), /*地址-4 */ ocd231 varchar2(255) /*地址-5 */ ); create unique index ocd_pk on ocd_file (ocd01,ocd02); alter table ocd_file add constraint ocd_pk primary key (ocd01,ocd02) enable validate; grant select on ocd_file to public; grant index on ocd_file to public; grant update on ocd_file to public; grant delete on ocd_file to public; grant insert on ocd_file to public; |