wifi

Tables (3)

DISTANCE (Untitled3)

  • mgrNum (Key) — TEXT — Primary key — NOT NULL
  • dist (Field2) — REAL

HISTORY (Untitled2)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • lat1 (Field2) — REAL
  • lnt1 (Field3) — REAL
  • date (Field4) — DATE

WIFI (Untitled)

  • mgrNum (Key) — TEXT — Primary key — NOT NULL
  • mgrNum (Key2) — TEXT — Foreign key → DISTANCE.mgrNum — NOT NULL
  • fc (Field2) — TEXT
  • mainNum (Field3) — TEXT
  • add1 (Field4) — TEXT
  • add2 (Field5) — TEXT
  • instlFloor (Field6) — TEXT
  • instlTy (Field7) — TEXT
  • instlMby (Field8) — TEXT
  • svc (Field9) — TEXT
  • cmcwr (Field10) — TEXT
  • cstcYear (Field11) — TEXT
  • inoutDoor (Field12) — TEXT
  • remarS3 (Field13) — TEXT
  • lat2 (Field14) — REAL
  • lnt2 (Field15) — REAL
  • workDttm (Field16) — TEXT
  • Field17