クリエイトします。

一般予約参加者テーブル
CREATE TABLE PARTICIPATION
(RESERVE_ID VARCHAR2(100) PRIMARY KEY,
CUSTOMER_ID VARCHAR2(100),
CUSTOMER_COUNTORY VARCHAR2(100),
PASSPORT_EXPIRATOIN TIMESTAMP(100),
PASSPORT_RECEIPT TIMESTAMP(100),
CUSTOMER_FIRST_NAME VARCHAR2(100),
CUSTOMER_LAST_NAME VARCHAR2(100),
CUSTOMER_KANA_FIRST_NAME VARCHAR2(100),
CUSTOMER_KANA_LAST_NAME VARCHAR2(100),
CUSTOMER_ENGLISH_FIRST_NAME VARCHAR2(100),
CUSTOMER_ENGLISH_LAST_NAME VARCHAR2(100),
BIRTHDAY TIMESTAMP (100),
GENDER VARCHAR2(10),
POST VARCHAR2(100),
PREFECTURE VARCHAR2 (100),
CITY VARCHAR2 (100),
TOWN VARCHAR2(100),
BUILDING VARCHAR2(100),
PHONE VARCHAR2(100),
MAIL VARCHAR2(100),
INSURANCE_ID VARCHAR2(100)
)

一般予約内容テーブル
CREATE TABLE RESERVATION_DETAIL
(RESERVE_ID VARCHAR2(100) PRIMARY KEY,
RESERVE_DATE TIMESTAMP(100),
PRODUCT_ID VARCHAR2(100),
PRICE VARCHAR2(100),
AIRPORT VARCHAR2(100),
PRODUCT_START_DATE TIMESTAMP(100),
FRIGHT_TIME TIMESTAMP(100),
DISCOUNT_NAME VARCHAR2(100),
DISCOUNT_RATE NUMBER(100),
RESERVE_CUSTOMER_COUNTORY VARCHAR2(100),
RESERVE_CUSTOMER_PASSPORT_EXPIRATION TIMESTAMP(100),
RESERVE_CUSTOMER_PASSPORT_RECEIPT TIMESTAMP(100),
RESERVE_CUSTOMER_FIRST_NAME VARCHAR2(100),
RESERVE_CUSTOMER_LAST_NAME VARCHAR2(100),
RESERVE_CUSTOMER_KANA_FIRST_NAME VARCHAR2(100),
RESERVE_CUSTOMER_KANA_LAST_NAME VARCHAR2(100),
RESERVE_CUSTOMER_ENGLISH_FIRST_NAME VARCHAR2(100),
RESERVE_CUSTOMER_ENGLISH_LAST_NAME VARCHAR2(100),
BIRTHDAY TIMESTAMP (100),
gender varchar2(10),
post varchar2(100),
prefecture varchar2 (100),
city varchar2 (100),
town varchar2(100),
building varchar2(100),
phone varchar2(100),
mail varchar2(100),
SETTLEMENT VARCHAR2 (1),
SETTLEMENT_SITUATION VARCHAR2(1),
CREDIT_NUMBER VARCHAR2 (100),
TABITOMO_ID VARCHAR2(100)
)

法人予約内容テーブル
CREATE TABLE CORPORATION
(CORPORATION_RESERVE_ID VARCHAR2(100) PRIMARY KEY,
RESERVE_DATE TIMESTAMP(100),
PERSON_NUMBER NUMBER(100),
BUDGET NUMBER(100),
CORPORATION_NAME VARCHAR2(100),
CORPORATION_KANA_NAME VARCHAR2(100),
DEPARTMENT_NAME VARCHAR2(100),
DEPARTMENT_KANA_NAME VARCHAR2(100),
REPRESENTATIVE_NAME VARCHAR2(100),
REPRESENTATIVE_KANA_NAME VARCHAR2(100),
POST VARCHAR2(100),
PREFECTURE VARCHAR2 (100),
CITY VARCHAR2 (100),
TOWN VARCHAR2(100),
BUILDING VARCHAR2(100),
PHONE VARCHAR2(100),
MAIL VARCHAR2(100)
)

商品テーブル
CREATE TABLE PRODUCT
(
PRODUCT_ID VARCHAR2(100) PRIMARY KEY,
PRODUCT_CLASS VARCHAR2(10),
PRODUCT_NAME VARCHAR2(1000),
MAX_PARTICIPATION NUMBER(100),
END_DATE TIMESTAMP(100),
COUNTRY VARCHAR2(100),
COUNTRY_RATE NUMBER(100),
REGION VARCHAR2(100),
HOTEL VARCHAR2(100),
HOTEL_ADDRESS VARCHAR2(100),
PRODUCT_PERIOD TIMESTAMP(100),
PRODUCT_PERIOD_START TIMESTAMP(100),
PRODUCT_PERIOD_END TIMESTAMP(100),
PRODUCT_PRICE NUMBER(100),
SURCHARGE NUMBER(100),
PRODUCT_CATEGORY VARCHAR2(10),
PRODUCT_EXPLAINATION VARCHAR2(10000),
AIRPORT VARCHAR2(100),
AIRPORT_FEE NUMBER(100),
ARRIVAL_AIRPORT VARCHAR2(100),
ARRIVAL_AIRPORT_FEE NUMBER(100),
FIRST_DATE TIMESTAMP(100),
REMAIN_SEAT NUMBER(100)
)

商品毎閲覧回数テーブル
CREATE TABLE PRODUCT_READ
(
PRODUCT_ID VARCHAR2(100) PRIMARY KEY,
PRODUCT_SEEN_NUMBER NUMBER(100)
)

保険テーブル
CREATE TABLE INSURANCE
(
INSURANCE_ID VARCHAR2(100) PRIMARY KEY,
INSURANCE_NAME VARCHAR2(1000),
INSURANCE_PRICE NUMBER(100),
INSURANCE_EXPLAINATION VARCHAR2(10000)
)

ユーザテーブル
CREATE TABLE USERS
(
USER_ID VARCHAR2(100) PRIMARY KEY,
PASSWORD VARCHAR2(10),
COUNTORY VARCHAR2(100),
PASSPORT_EXPIRATON TIMESTAMP(100),
PASSPORT_RECEIPT TIMESTAMP(100),
FIRST_NAME VARCHAR2(100),
LAST_NAME VARCHAR2(100),
KANA_FIRST_NAME VARCHAR2(100),
KANA_LAST_NAME VARCHAR2(100),
ENGLISH_FIRST_NAME VARCHAR2(100),
ENGLISH_LAST_NAME VARCHAR2(100),
NICKNAME VARCHAR2(100),
BIRTHDAY TIMESTAMP(100),
GENDER VARCHAR2(10),
POST VARCHAR2(100),
PREFECTURE VARCHAR2 (100),
CITY VARCHAR2 (100),
TOWN VARCHAR2(100),
BUILDING VARCHAR2(100),
PHONE VARCHAR2(100),
MAIL VARCHAR2(100),
MAIL_MAGAZINE VARCHAR2(1),
AGREE VARCHAR2(1),
COUPON NUMBER(10)
)

お気に入り商品テーブル
CREATE TABLE FAVORITE
(
USER_ID VARCHAR2(100) PRIMARY KEY,
PRODUCT_ID VARCHAR2(100),
REGIST_DATE TIMESTAMP(100)
)

閲覧商品履歴テーブル
CREATE TABLE PRODUCT_SEEN_HISTORY
(
IP_ADDRESS VARCHAR2(100) PRIMARY KEY,
PRODUCT_ID VARCHAR2(100),
READ_DATE TIMESTAMP(100)
)

レビューテーブル
CREATE TABLE REVIEW
(
PRODUCT_ID VARCHAR2(100) PRIMARY KEY,
USER_ID VARCHAR2(100) PRIMARY KEY,
REVIEW_DATE TIMESTAMP(100),
RATING VARCHAR2(100),
REVIEW VARCHAR2(10000)
)

たびとも投稿テーブル
CREATE TABLE TABITOMO_POST
(
TABITOMO_ID VARCHAR2(100) PRIMARY KEY,
USER_ID VARCHAR2(100),
PRODUCT_ID VARCHAR2(100),
AIRPORT VARCHAR2(100),
PRODUCT_START_DATE TIMESTAMP(100),
INBITATION_NUMBER NUMBER(100),
REMAIN_INBIRATION_NUMBER NUMBER(100),
MESSAGE VARCHAR2(10000),
TABITOMO_POST_DATE TIMESTAMP(100)
)

たびとも返信テーブル
CREATE TABLE TABITOMO_REPLY
(
TABITOMO_ID VARCHAR2(100) PRIMARY KEY,
USER_ID VARCHAR2(100),
TABITOMO_POST_DATE TIMESTAMP(100),
MESSAGE VARCHAR2(10000)
)

たびとも申請テーブル
CREATE TABLE TABITOMO_APPLY
(
TABITOMO_ID VARCHAR2(100) PRIMARY KEY,
USER_ID VARCHAR2(100),
APPROVAL VARCHAR2(1)
)

チャット
CREATE TABLE CHAT
(
SEND_USER_ID VARCHAR2(100) PRIMARY KEY,
RECEIVE_USER_ID VARCHAR2(100),
SEND_DATE TIMESTAMP(100),
MESSAGE VARCHAR2(10000)
)