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)