Hotel Reservation Back ERD
Tables (5)
Board
- id — BIGINT — Primary key
- author_id — BIGINT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Bookings
- id — BIGINT — Primary key
- guest_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- status — VARCHAR(30)
- id (id2) — BIGINT — Foreign key → User.id
Comments
- id — BIGINT — Primary key
- post_id — BIGINT — NOT NULL
- author — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
Rooms
- id — BIGINT — Primary key
- room_number — VARCHAR(20) — NOT NULL
- room_type — VARCHAR(50) — NOT NULL
- price — DOUBLE — NOT NULL
- status — VARCHAR(30)
User
- id — BIGINT — Primary key
- first_name — VARCHAR(20) — NOT NULL
- last_name — VARCHAR(20) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- role — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL