m

Tables (4)

esp (Untitled3)

  • node — Primary key
  • mac
  • rssi
  • last
  • date
  • seq — NOT NULL

esp_place (Untitled4)

  • node — Primary key — NOT NULL
  • place_id
  • node (node2) — Foreign key → esp.node
  • place_id (place_id2) — Foreign key → place_info.place_id — NOT NULL

place_info (Untitled2)

  • place_id — Primary key — NOT NULL
  • name

wifi data (Untitled)

  • node
  • every10
  • maccount
  • date