IMCP

Tables (8)

Child_GPS (Untitled3)

  • Key — VARCHAR(20) — Foreign key → Child_Info.Key — NOT NULL
  • TIME (time) — DATETIME
  • Latitude (latitude) — DOUBLE
  • Longitude (longitude) — DOUBLE

Child_GPS_Initial (Untitled7)

  • Key — VARCHAR(20) — Foreign key → Child_Info.Key — NOT NULL
  • Latitude — DOUBLE
  • Longitude (Logitude) — DOUBLE

Child_Info (Untitled2)

  • Key — VARCHAR(20) — Foreign key → Private_Key.Key — NOT NULL
  • Name (name) — VARCHAR(20)
  • Birth (birth) — DATE
  • Image (img) — VARCHAR(100)
  • Missing (missing) — BOOLEAN
  • Danger (danger) — BOOLEAN
  • Help (help) — BOOLEAN

Parent_GPS (Untitled6)

  • ID (id) — VARCHAR(20) — Foreign key → Parent_Info.ID — NOT NULL
  • Time (Field) — DATETIME
  • Latitude (Field2) — DOUBLE
  • Longitude (Field3) — DOUBLE

Parent_Info (Untitled4)

  • ID (id) — VARCHAR(20) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Name (name) — VARCHAR(20)
  • Phone (phone) — VARCHAR(15)
  • Email (email) — VARCHAR(30)

Parent_Token (Untitled8)

  • Token (token) — VARCHAR(255) — Primary key — NOT NULL
  • ID (id) — VARCHAR(20) — Foreign key → Parent_Info.ID — NOT NULL

Private_Key (Untitled)

  • Key — VARCHAR(20) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)

PtoC (Untitled5)

  • ID (id) — VARCHAR(20) — Foreign key → Parent_Info.ID — NOT NULL
  • Key — VARCHAR(20) — Foreign key → Child_Info.Key — NOT NULL