FarmGuardian
Tables (5)
devices
- device_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- device_uuid — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- target_crop — VARCHAR(50)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)
fcm_tokens
- fcm_token_id — BIGINT — Primary key — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
- token_value — VARCHAR(512) — NOT NULL
- platform — VARCHAR(50) — NOT NULL
origin_images
- origin_image_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → devices.device_id — NOT NULL
- cloud_url — VARCHAR(512) — NOT NULL
- height — INT — NOT NULL
- width — INT — NOT NULL
- created_at — DATETIME(6)
- analysis_result — JSON
refresh_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- client_uuid — VARCHAR(255) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — VARCHAR(50)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deleted_at — DATETIME(6)