bangbang

Tables (5)

Untitled (User)

  • Key (id) — int — Primary key — NOT NULL
  • Field (loginId) — varchar(20)
  • Field (password) — varchar(20)
  • Field (nickname) — varchar(20)
  • Field (type) — varchar(20)

Untitled (Review)

  • Key (id) — int — Primary key — NOT NULL
  • Key (writer_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (hotel_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (star_rating) — int
  • Field (body) — text

Untitled (Hotel)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (coord) — point
  • Field (address) — varchar(100)

Untitled (Reserve)

  • Key (id) — int — Primary key — NOT NULL
  • Key (reserver_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (room_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (check_in_date) — date
  • Field (check_out_date) — date

Untitled (Room)

  • Key (id) — int — Primary key — NOT NULL
  • Key (hotel_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field (occupancy) — int
  • Field (price_per_night) — int
  • Field (description) — text