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