Hotel

Tables (3)

Customer (Untitled)

  • customer_id (Field) — NUMBER(10) — Primary key
  • customer_name (Field2) — VARCHAR2(260)
  • password (Field3) — VARCHAR(260)
  • birth (Field4) — DATE
  • phone_number (Field5) — VARCHAR2(260)
  • email (Field6) — VARCHAR2(260)

Hotel (CopyOfUntitled)

  • hotel_id (Field) — NUMBER(10) — Primary key
  • hotel_name (Field2) — VARCHAR2(260)
  • address (Field3) — VARCHAR2(260)
  • hotel_number (Field5) — NUMBER(8)
  • price (Field4) — NUMBER(8)
  • rating (Field6) — NUMBER(2, 1)
  • hotel_image (Field7) — BLOB

Reservation (CopyOfCopyOfUntitled)

  • reserve_id (Field) — NUMBER(10) — Primary key
  • customer_id (Field9) — NUMBER(10) — Foreign key → Customer.customer_id
  • hotel_id (Field10) — NUMBER(10) — Foreign key → Hotel.hotel_id
  • customer_id (Field2) — NUMBER(10)
  • hotel_id (Field3) — NUMBER(10)
  • reserv_date (Field4) — TIMESTAMP
  • checkin_date (Field5) — DATE
  • checkout_date (Field6) — DATE
  • room_number (Field7) — NUMBER(2)
  • people_number (Field8)