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)