hotel
Tables (8)
hotels (Untitled)
- Key (hotel_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
members (Untitled3)
- Key (member_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
points (Untitled4)
- Key (point_id) — BIGINT — Primary key — NOT NULL
- Field (amount) — INT — NOT NULL
- Field (earned_at) — DATETIME — NOT NULL
- Field (expires_at) — DATE — NOT NULL
- Field (status) — TINYINT — NOT NULL
- Key (member_id) — BIGINT — Foreign key → members.Key — NOT NULL
- Key (reservation_id) — BIGINT — Foreign key → reservations.Key
reservations (Untitled8)
- Key (reservation_id) — BIGINT — Primary key — NOT NULL
- Field (reservation_no) — VARCHAR(36) — NOT NULL
- Field (check_in) — DATE — NOT NULL
- Field (check_out) — DATE — NOT NULL
- Field (guest_count) — TINYINT — NOT NULL
- Field (status) — TINYINT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Key (room_id) — BIGINT — Foreign key → rooms.Key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → members.Key — NOT NULL
review_images (Untitled7)
- Key (image_id) — BIGINT — Primary key — NOT NULL
- Field (image_url) — VARCHAR(255) — NOT NULL
- Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL
reviews (Untitled5)
- Key (review_id) — BIGINT — Primary key — NOT NULL
- Field (rating) — DECIMAL(2,1) — NOT NULL
- Field (content) — VARCHAR(1000) — NOT NULL
- Field (visible_flag) — TINYINT(1) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Key (reservation_id) — BIGINT — Foreign key → reservations.Key — NOT NULL
room_images (Untitled6)
- Key (image_id) — BIGINT — Primary key — NOT NULL
- Field (image_url) — VARCHAR(255) — NOT NULL
- Key (room_id) — BIGINT — Foreign key → rooms.Key — NOT NULL
rooms (Untitled2)
- Key (room_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (capacity) — TINYINT — NOT NULL
- Field (floor) — TINYINT — NOT NULL
- Field (bathtub_flag) — TINYINT(1) — NOT NULL
- Field (view_type) — TINYINT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (price) — INT — NOT NULL
- Key (hotel_id) — BIGINT — Foreign key → hotels.Key — NOT NULL