exam_hotel

Tables (6)

Files

  • file_id — VARCHAR(255) — Primary key — NOT NULL
  • file_origin_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • file_extension — VARCHAR(255) — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id

Hotels

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

PointHistories

  • point_history_id — Primary key — NOT NULL
  • transactionType — VARCHAR(255) — NOT NULL
  • points — INT — NOT NULL
  • date_time — DATETIME — NOT NULL
  • description — VARCHAR(255)
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL

Reservations

  • reservation_d — BIGINT — Primary key — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • number_of_people — INT — NOT NULL
  • reserver_name — VARCHAR(255) — NOT NULL
  • contact_number — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL

Rooms

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

Users

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • member_auth (user_auth) — VARCHAR(255) — NOT NULL