hotel

Tables (5)

Untitled (hotel)

  • Key (hotel_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (name) — VARCHAR(100) — NOT NULL

Untitled (room)

  • Key (room_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (name) — BIGINT — NOT NULL
  • Field (capacity) — VARCHAR(100) — NOT NULL
  • Field2 (floor) — TINYINT — NOT NULL
  • Field3 (bathtub_flag) — TINYINT — NOT NULL
  • Field4 (view_type) — TINYINT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Key (hotel_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT

Untitled (member)

  • Key (member_id) — BIGINT — Primary key — NOT NULL
  • Field (password) — VARCHAR(20) — NOT NULL

Untitled (reservation)

  • Key (reservation_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (check_in_date) — DATETIME — NOT NULL
  • Field (check_out_date) — DATETIME — NOT NULL
  • Key (member_id) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (hotel_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Field (number_of_user) — INT — NOT NULL

Untitled (rooms_reservation)

  • Key (room_reservation_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Key (room_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Key (reservation_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT