hotel
Tables (5)
Untitled (hotel)
- Key (hotel_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- Field (name) — VARCHAR(100) — NOT NULL
Untitled (room)
- Key (room_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- Field (name) — BIGINT — NOT NULL
- Field (capacity) — VARCHAR(100) — NOT NULL
- Field2 (floor) — TINYINT — NOT NULL
- Field3 (bathtub_flag) — TINYINT — NOT NULL
- Field4 (view_type) — TINYINT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Key (hotel_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
Untitled (member)
- Key (member_id) — BIGINT — Primary key — NOT NULL
- Field (password) — VARCHAR(20) — NOT NULL
Untitled (reservation)
- Key (reservation_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- Field (check_in_date) — DATETIME — NOT NULL
- Field (check_out_date) — DATETIME — NOT NULL
- Key (member_id) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Key (hotel_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
- Field (number_of_user) — INT — NOT NULL
Untitled (rooms_reservation)
- Key (room_reservation_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- Key (room_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
- Key (reservation_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT