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)