디버거
테이블 (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