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)