Office

Tables (4)

Customer (Untitled)

  • CUS_EMAIL (Key) — Primary key — NOT NULL
  • CUS_PASSWORD (Field)
  • CUS_NAME (Field2)
  • CUS_GENDER (Field3)
  • CUS_COMPANY (Field5)
  • CUS_PHONE (Field6)
  • CUS_ADDRESS (Field7)
  • CUS_latitute (Field8)
  • CUS_longitude (Field9)

Location (Untitled4)

  • Location ID (Key) — Primary key — NOT NULL
  • CUS_ID (Key2) — Foreign key → Customer.CUS_EMAIL — NOT NULL
  • latitude (Field2)
  • longitude (Field3)

Reservation (Untitled2)

  • RESERVATION_ID (Key) — Primary key — NOT NULL
  • CUS_ID (Key2) — Foreign key → Customer.CUS_EMAIL — NOT NULL
  • SO_ID (Key3) — Foreign key → Share Office.SO_ID — NOT NULL
  • RESERVATION_STARTTIME (Field2)
  • RESERVATION_ENDTIME (Field4)
  • RESERVATION_CANCEL (Field3)
  • RESERVATION_CANCELDATE (Field5)
  • RESERVATION_TOTAL (Field6)

Share Office (Untitled3)

  • SO_ID (Key) — Primary key — NOT NULL
  • SO_NAME (Field)
  • SO_LATITUDE (Field2)
  • SO_LONGITUDE (Field3)
  • SO_24HOURS (Field4)
  • SO_WIFI (Field5)
  • SO_PRINTER (Field6)
  • SO_AC_HOLD (Field7)
  • SO_CAFE_HOLD (Field8)
  • SO_BOX (Field9)
  • SO_DOORLOCK (Field10)
  • SO_ELECT (Field11)
  • SO_365DAYS (Field12)
  • SO_HEATER (Field13)
  • SO_PARKING (Field14)
  • SO_LOUNGE (Field15)
  • SO_KITCHEN (Field16)
  • SO_WATER (Field17)
  • SO_ROOFTOP (Field18)
  • SO_SNACK (Field19)
  • SO_LOCKER (Field20)
  • SO_TV (Field21)
  • SO_WHITEBOARD (Field22)
  • SO_BATH (Field23)
  • SO_PRICE (Field24)
  • SO_ROOMTYPE (Field25)