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