airbnb

Tables (6)

option_main

  • stay_id — int — NOT NULL
  • room — int — NOT NULL
  • bedroom — int
  • bathroom — int
  • kitchen — int

option_sub

  • item — VARCHAR(50)

reservation

  • id — int — Primary key — NOT NULL
  • id (id2) — int — Foreign key → user.id — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • stay_id — int — NOT NULL
  • host_id — int — NOT NULL
  • confirmation — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • number_of_guest — int — NOT NULL
  • total_charge — int — NOT NULL

stay

  • id — int — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • latitude — DECIMAL(10,7) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • thumbnail — text
  • review_rating — DECIMAL(3,2)
  • day_cost — int — NOT NULL
  • discount_rate — float
  • cleaning_fee — int
  • service_fee — int
  • accommondation_tax — int
  • created_at — TIMESTAMP — NOT NULL
  • host_id — int — NOT NULL
  • activate — boolean — NOT NULL
  • maximum_guest — int — NOT NULL
  • Field

user

  • id — int — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • birth — date
  • 회원등급 (status) — varchar(45) — NOT NULL
  • gender — char(1) — NOT NULL
  • created_at — Timestamp

wishlist

  • id — int — NOT NULL
  • user_id — int — NOT NULL
  • stay_id — int — NOT NULL