AI ERD
Tables (5)
Untitled (user_charge)
- Key (chargeId) — Int(11) — Primary key — NOT NULL
- Field (charge) — Int(11) — NOT NULL
- Field2 (joinId) — Int(11)
- Field3 (userId) — Int(11)
- Field4 (red) — tinyint(4) — NOT NULL
- Field5 (exposure) — decimal(10,4) — NOT NULL
- Field6 (reach) — decimal(10,4) — NOT NULL
- Field7 (location_name) — varchar(40)
- Field8 (level) — varchar(40)
- Field9 (lat) — decimal(10,8)
- Field10 (lon) — decimal(11,8)
- Field11 (roadCode) — Int(10)
- Field12 (emdCode) — Int(8)
- Field (spdAvg) — float
- Field (updatedAt) — datetime — NOT NULL
Untitled (total_user_pattern)
- Key (patternId) — Int(11) — Primary key — NOT NULL
- Field (userId) — Int(11) — NOT NULL
- Field2 (dataType) — ENUM — Pattern, Time, Exposure, Reach
- Field3 (dataJson) — json
- Field4 (createdAt) — datetime — NOT NULL
- Field5 (updatedAt) — datetime — NOT NULL
Untitled (daily_user_pattern)
- Key (patternId) — Int(11) — Primary key — NOT NULL
- Field (dataType) — enum — Pattern, Time, Exposure, Reach
- Field2 (drivingDay) — varchar(10) — NOT NULL
- Field3 (dataJson) — json
- Field4 (userId) — Int(11) — NOT NULL
- Field5 (createdAt) — datetime — NOT NULL
- Field6 (updatedAt) — datetime — NOT NULL
Untitled (etc_data)
- Key — Primary key — NOT NULL
- loc pk (locId) — Int(11) — Foreign key → user gps location table.loc pk — NOT NULL
- Field2 (createdAt) — datatime — NOT NULL
- Field3 (updatedAt) — datetime — NOT NULL
- Field4
- Field
user gps location table (user_location)
- loc pk (locId) — Int(11) — Primary key — NOT NULL
- 캠페인 joinId (joinId) — Int(11)
- dalgo userId (userId) — Int(11) — NOT NULL
- latitude (lat) — decimal(10,8) — NOT NULL
- lontitude (lon) — decimal(10,8) — NOT NULL
- 속도 (spd) — float
- 비콘 연결 여부 (connected) — tinyint(4) — NOT NULL
- 정산 여부 (charged) — tinyint(4) — NOT NULL
- 확인 필요 (final) — tinyint(4) — NOT NULL
- 비콘 상태값 (actual) — tinyint(4) — NOT NULL
- 생성일 (createdAt) — datetime — NOT NULL
- 수정일 (updatedAt) — datetime — NOT NULL