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