--drop table COMPANY_ZONE; create table COMPANY_ZONE ( COMPANY_ID VARCHAR2(16) default ' ' not null, ZONE_ID VARCHAR2(16) default ' ' not null, TM_SMP VARCHAR2(2) default ' ' not null, primary key(ZONE_ID,COMPANY_ID) ); --drop table TITLE_COMPANY; create table TITLE_COMPANY ( TITLE_ID VARCHAR2(16) default ' ' not null, COMPANY_ID VARCHAR2(16) default ' ' not null, TM_SMP VARCHAR2(2) default ' ' not null, primary key(TITLE_ID) ) ;