18 lines
467 B
SQL
18 lines
467 B
SQL
--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)
|
|
) ;
|