boostbnb

Tables (5)

Copy Of Untitled (Price)

  • Key (price_id) — varchar(20) — Primary key — NOT NULL
  • Field (date) — date
  • Field (price) — int
  • Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (User)

  • Key (id) — varchar(20) — Primary key — NOT NULL
  • Field (nickname) — varchar(36)
  • Field (profile_img_url) — text
  • Field (password) — varchar(255)

Untitled (Accommodation)

  • Key (id) — varchar(20) — Primary key — NOT NULL
  • Key (host_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — text
  • Field (img) — text
  • Field (option) — text
  • Field (personnel) — int
  • Field (position) — point

Untitled (Reservation)

  • Key (reservation_id) — varchar(20) — Primary key — NOT NULL
  • Key (user_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (fee) — int
  • Field (checkin_day) — date
  • Field (checkout_day) — date
  • Field (personnel) — int

Untitled (Review)

  • Key (revirew_id) — int — Primary key — NOT NULL
  • Key (writer_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (rate) — int
  • Field (content) — text
  • Field (write_at) — date
  • Key (accommodation_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL