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