디버거

테이블 (4)

Device (device)

  • Device PK (device_id) — INT — 기본 키 — NOT NULL
  • User PK (user_id) — INT — 외래 키 → User.User PK — NOT NULL
  • Target Crop (target_crop) — ENUM
  • Device Latitude (device_latitude) — DECIMAL — NOT NULL
  • Device Longitude (device_longitude) — DECIMAL — NOT NULL
  • Created At (created_at) — TIMESTAMP — NOT NULL
  • Updated At (updated_at) — TIMESTAMP — NOT NULL
  • Deleted At (deleted_at) — TIMESTAMP

FCM Token (fcm_token)

  • FCM Token PK (fcm_token_id) — INT — 기본 키 — NOT NULL
  • User PK (user_id) — INT — 외래 키 → User.User PK — NOT NULL
  • Token Value (token_value) — VARCHAR — NOT NULL
  • Platform (platform) — ENUM — NOT NULL
  • Created At (created_at) — TIMESTAMP — NOT NULL
  • Updated At (updated_at) — TIMESTAMP — NOT NULL

Image (image)

  • Image PK (image_id) — INT — 기본 키 — NOT NULL
  • Device PK (device_id) — INT — 외래 키 → Device.Device PK — NOT NULL
  • URL (url) — VARCHAR — NOT NULL
  • Height (height) — INT — NOT NULL
  • Width (width) — INT — NOT NULL
  • Latitude (latitude) — DECIMAL — NOT NULL
  • Longitude (longitude) — DECIMAL — NOT NULL
  • Corp (corp) — ENUM
  • Created At (created_at) — TIMESTAMP — NOT NULL
  • BBOX Confidence (bbox_confidence) — TEXT — { "corp":"배추", "total":2, "risk":"초기", "object": [ { "id":0, "points": [ { "xtl": 1123, "ytl": 321, "xbr": 3122, "ybr":…

User (user)

  • User PK (user_id) — INT — 기본 키 — NOT NULL
  • Email (email) — VARCHAR — NOT NULL
  • Password (password) — VARCHAR — NOT NULL
  • Created At (created_at) — TIMESTAMP — NOT NULL
  • Updated At (updated_at) — TIMESTAMP — NOT NULL
  • Deleted At (deleted_at) — TIMESTAMP