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