cs
Tables (3)
Customer
- id — INT
- name — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
Reservation
- id — INT
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- customer_id — INT — Foreign key → Customer.id
- room_id — INT — Foreign key → Room.id
Room
- id — INT
- room_number — INT — NOT NULL
- room_type — VARCHAR(255) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL