test
Tables (6)
Hotel
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
Member
- member_id — VARCHAR(100) — Primary key — NOT NULL
- username — VARCHAR(100)
- password — VARCHAR(100)
PointHistory
- Key — BIGINT — Primary key — NOT NULL
- member_id — VARCHAR(100) — Foreign key → Member.member_id — NOT NULL
- created_at — DATETIME
- is_use (use_status) — TINYINT(1)
Reservation
- reservation_no — VARCHAR(100) — Primary key — NOT NULL
- member_id — VARCHAR(100) — Foreign key → Member.member_id — NOT NULL
- room_id — BIGINT — Foreign key → Room.room_id — NOT NULL
- hotel_id — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
- check_in_at — DATETIME
- check_out_at — DATETIME
- people_count — INT
Review
- review_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → Room.room_id — NOT NULL
- image_url — VARCHAR(100)
- is_public — TINYINT(1)
- title — VARCHAR(100)
- context — VARCHAR(1000)
Room
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
- name — VARCHAR(100)
- capacity — TINYINT
- floor — TINYINT
- bathtub_flag — TINYINT(1)
- view_type — TINYINT
- created_at — DATETIME
- price — INT
- image_url — VARCHAR(100)