fdskmqweof
Tables (11)
CleanUp (CopyOfCopyOfUntitled42)
- CleanArea (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffID (Key2) — INT — Foreign key → Staff.StaffID — NOT NULL
- CleanStatus (Field) — VARCHAR2 — NOT NULL — Y or N
- CleanMembers (Field2) — INT — NOT NULL
- CleanTime (Field3) — DATETIME — NOT NULL
Facilities (CopyOfCopyOfUntitled4)
- FacilityName (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffID (Key2) — INT — Foreign key → Staff.StaffID — NOT NULL
- RepairStatus (Field) — VARCHAR2 — NOT NULL — Y or N
- FacilityPrice (Field2) — FLOAT
- FacilityCapacity (Field3) — INT
- FacilityOpeningHour (Field4) — VARCHAR2
Guest
- GuestMail (Field6) — VARCHAR2 — Primary key — NOT NULL
- GuestName (Field) — VARCHAR2 — NOT NULL
- PaymentInfo (Field2) — VARCHAR2 — NOT NULL
- GuestPhoneNumber (Field3) — VARCHAR2 — NOT NULL
- Unpaid (Field5) — FLOAT
Items (CopyOfCopyOfCopyOfCopyOfUntitled42)
- ItemName (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffID (Key2) — INT — Foreign key → Staff.StaffID — NOT NULL
- ItemArea (Field) — VARCHAR2 — NOT NULL
- ItemStock (Field2) — INT — NOT NULL
- ItemNeed (Field3) — INT — NOT NULL
- ItemBudget (Field4) — FLOAT — NOT NULL
- OrderStatus (Field5) — VARCHAR2 — NOT NULL
Parking (CopyOfCopyOfCopyOfUntitled4)
- CarNumber (Key) — VARCHAR2 — Primary key — NOT NULL
- ParkingStaffID (Key3) — VARCHAR2 — Foreign key → Staff.StaffID — NOT NULL
- GuestMail (Field6) — VARCHAR2 — Foreign key → Guest.GuestMail — NOT NULL
- CarModel (Field) — VARCHAR2
- ParkIN (Field2) — DATETIME — NOT NULL
- ParkOUT (Field3) — DATETIME
PickUp (CopyOfCopyOfCopyOfUntitled42)
- ReserveNumber (Key2) — VARCHAR2 — Foreign key → Reservation.ReserveNumber — NOT NULL
- StaffID (Key) — VARCHAR2 — Foreign key → Staff.StaffID — NOT NULL
- GuestMail (Field62) — VARCHAR2 — Foreign key → Reservation.GuestMail — NOT NULL
- ArriveTime (Field) — DATETIME — NOT NULL
- PickupSpot (Field2) — VARCHAR2 — NOT NULL
- Persons (Field3) — INT — NOT NULL
- AvailableTime (Field4) — VARCHAR2
Reservation (Untitled2)
- ReserveNumber (Key) — VARCHAR2 — Primary key — NOT NULL
- RoomNumber (Key3) — VARCHAR2(4) — Foreign key → Room.RoomNumber — NOT NULL
- GuestMail (Field62) — VARCHAR2 — Foreign key → Guest.GuestMail — NOT NULL
- NumberofMembers (Field2) — INT — NOT NULL
- CheckIn (Field4) — DATE — NOT NULL
- CheckOut (Field5) — DATE — NOT NULL
- RealCheckIn (Field) — DATETIME
- RealCheckOut (Field3) — DATETIME
- PaymentStatus (Field6) — VARCHAR2 — NOT NULL — Y or N
- RerservePickUp (Field7) — VARCHAR2 — NOT NULL — Y or N
- CancelStatus (Field8) — VARCHAR2 — NOT NULL — Y or N
Room
- RoomNumber (Key) — VARCHAR2(4) — Primary key — NOT NULL
- ReserveStatus (Field) — VARCHAR2 — NOT NULL — Y or N
- RoomPrice (Field2) — FLOAT — NOT NULL
- RoomCapacity (Field3) — INT — NOT NULL
- Bed (Field4) — VARCHAR2 — NOT NULL — Single or Double or Twin
- View (Field5) — VARCHAR2 — NOT NULL
- Smoking (Field6) — VARCHAR2 — NOT NULL — Y or N
- Damaged (Field7) — VARCHAR2 — NOT NULL — Y or N
Services (CopyOfUntitled4)
- ServiceName (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffID (Key2) — VARCHAR2 — Foreign key → Staff.StaffID — NOT NULL
- ServicePrice (Field) — FLOAT
- ServiceAvailability (Field2) — VARCHAR2
Staff (Untitled3)
- StaffID (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffName (Field) — VARCHAR2 — NOT NULL
- StaffRole (Field2) — VARCHAR2 — NOT NULL
- StaffArea (Field3) — VARCHAR2 — NOT NULL
- StaffAddress (Field4) — VARCHAR2 — NOT NULL
- StaffMail (Field5) — VARCHAR2 — NOT NULL
- StaffPhoneNumber (Field8) — VARCHAR2 — NOT NULL
- StaffSalary (Field6) — FLOAT — NOT NULL
- StaffAccount (Field7) — VARCHAR2 — NOT NULL
- StaffMemo (Field9) — VARCHAR2 — NOT NULL
TourSpot (Untitled4)
- TourName (Key) — VARCHAR2 — Primary key — NOT NULL
- StaffID (Key2) — VARCHAR2 — Foreign key → Staff.StaffID — NOT NULL
- TourOpeningHours (Field) — VARCHAR2
- TourPrice (Field2) — FLOAT
- TourCapacity (Field3) — VARCHAR2
- TourAvailability (Field4) — VARCHAR2