Pension Reservation
Tables (4)
Customer
- Customer ID (customer_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Age (age) — INT
Payment
- Payment ID (payment_id) — INT — Primary key — NOT NULL
- Total Cost (total_cost) — VARCHAR(255)
- Pmethod (pmethod) — VARCHAR(255)
- Pdate (pdate) — VARCHAR(50)
- Pstate (pstate) — VARCHAR(50)
- Reservation ID (reservation_id) — INT — Foreign key → Reservation.Reservation ID — NOT NULL
Reservation
- Reservation ID (reservation_id) — INT — Primary key — NOT NULL
- Check in (check_in) — VARCHAR(50)
- Check out (check_out) — VARCHAR(50)
- Rdate (rdate) — VARCHAR(50)
- Rstate (rstate) — VARCHAR(50)
- Customer ID (customer_id) — INT — Foreign key → Customer.Customer ID — NOT NULL
- Room ID (room_id) — INT — Foreign key → Room.Room ID — NOT NULL
Room
- Room ID (room_id) — INT — Primary key — NOT NULL
- Rname (rname) — VARCHAR(255)
- Fixed Number (fixed_number) — INT
- Rprice (rprice) — VARCHAR(255)