Hyundai

Tables (5)

Car Table

  • carid — VARCHAR — Primary key — NOT NULL
  • name — VARCHAR
  • userid — VARCHAR — Foreign key → User Table.userid — NOT NULL
  • Field (date) — DATETIME

Card Table

  • cardid — VARCHAR — Primary key — NOT NULL
  • name — VARCHAR
  • mobilecarid — VARCHAR — Foreign key → Mobile Car Table.mobilecarid — NOT NULL
  • Field (date) — DATETIME

Mobile Car Table

  • mobilecarid — VARCHAR — Primary key — NOT NULL
  • carid — VARCHAR — Foreign key → Car Table.carid — NOT NULL
  • deviceid (mobileid) — VARCHAR — Foreign key → Mobile Table.deviceid — NOT NULL
  • Field (date) — DATETIME

Mobile Table

  • deviceid (mobileid) — VARCHAR — Primary key — NOT NULL
  • pushId (pushid) — VARCHAR
  • name — VARCHAR
  • userid — VARCHAR — Foreign key → User Table.userid — NOT NULL
  • Field (date) — DATETIME

User Table

  • userid — VARCHAR — Primary key — NOT NULL
  • name — VARCHAR
  • Field (date) — DATETIME