test

Tables (7)

hotels

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

point

  • point_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • point — BIGINT
  • created_at — DATETIME
  • Field

reservations

  • reservation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • checked_in_date — DATETIME
  • checked_out_date — DATETIME
  • people_count — TINYINT
  • Field

review

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • content — VARCHAR(200)
  • Field2

role

  • role_id — BIGINT — Primary key — NOT NULL
  • role_name — VARCHAR(100)
  • Field

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • role_id — BIGINT — Foreign key → role.role_id — NOT NULL
  • username — VARCHAR(100)
  • password — VARCHAR(100)
  • Field