hotel
Tables (7)
Hotels
- Key (hotel_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(100)
Rate
- Key (rate_id) — BIGINT — Primary key — NOT NULL
- Field (season) — VARCHAR(20)
- Field (price) — INTEGER
- Field (start_date) — DATE
- Field (end_date) — DATE
- Key (room_id) — BIGINT — Foreign key → Rooms.Key — NOT NULL
Reservations
- Key (reservation_id) — BIGINT — Primary key — NOT NULL
- Field (check_in) — DATE
- Field2 (check_out) — DATE
- Field (guest_count) — INTEGER
- Field (reservation_people_name) — VARCHAR(30)
- Field (phone_number) — VARCHAR(20)
- Field (reservation_number) — VARCHAR(100)
- Field2 (reservation_status) — VARCHAR(50)
- Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL
- Key (room_id) — BIGINT — Foreign key → Rooms.Key — NOT NULL
Rooms
- Key (room_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(100)
- Field (capacity) — TINYINT
- Field (floor) — TINYINT
- Field (bathtub_flag) — TINYINT(1)
- Field (view_type) — TINYINT
- Field (created_at) — DATETIME
- Key (hotel_id) — BIGINT — Foreign key → Hotels.Key — NOT NULL
Untitled (point)
- Key (point_id) — BIGINT — Primary key — NOT NULL
- Field (amount) — INTEGER
- Field2 (created_at) — DATE
- Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL
Untitled (reviews)
- Key (review_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL
- Key (hotel_id) — BIGINT — Foreign key → Hotels.Key — NOT NULL
- Field (title) — VARCHAR(100)
- Field2 (content) — TEXT
- Field (review_image) — VARCHAR(255)
- Field (created_at) — DATE
- Field (is_outbreak) — BOOLEAN
Users
- Key (user_id) — VARCHAR(50) — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
- Field (password) — VARCHAR(50)
- Field (role) — VARCHAR(30)