Hotel Reservation Back ERD

Tables (5)

Board

  • id — BIGINT — Primary key
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

Bookings

  • id — BIGINT — Primary key
  • guest_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • status — VARCHAR(30)
  • id (id2) — BIGINT — Foreign key → User.id

Comments

  • id — BIGINT — Primary key
  • post_id — BIGINT — NOT NULL
  • author — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

Rooms

  • id — BIGINT — Primary key
  • room_number — VARCHAR(20) — NOT NULL
  • room_type — VARCHAR(50) — NOT NULL
  • price — DOUBLE — NOT NULL
  • status — VARCHAR(30)

User

  • id — BIGINT — Primary key
  • first_name — VARCHAR(20) — NOT NULL
  • last_name — VARCHAR(20) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • role — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL