farmily-v1

Tables (13)

plant

  • id — SERIAL
  • users_id — INTEGER — Foreign key → users.id — NOT NULL
  • ref_plant_species_id — INTEGER — Foreign key → ref_plant_species.id — NOT NULL
  • nickname — VARCHAR(50)
  • profile_image_url — TEXT
  • health_status — VARCHAR(50)
  • health_checked_at — TIMESTAMP
  • love_temperature — DECIMAL(5, 2)
  • is_active — BOOLEAN
  • station_point — VARCHAR(255)
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP

plant_achievement

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • ref_achievement_id — INTEGER — Foreign key → ref_achievement.id — NOT NULL
  • created_at — TIMESTAMP

plant_activity_counts

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • activity_type — VARCHAR(20) — NOT NULL
  • total_count — INTEGER
  • updated_at — TIMESTAMP

plant_activity_log

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

plant_diary

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • content — TEXT
  • image_url — TEXT
  • happened_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_at — TIMESTAMP

plant_health_logs

  • id — SERIAL
  • plant_timelapse_id — INTEGER — Foreign key → plant_timelapse.id — NOT NULL
  • ref_plant_disease_id — INTEGER — Foreign key → ref_plant_disease.id — NOT NULL
  • bbox — TEXT
  • confidence — DECIMAL(5, 2)
  • created_at — TIMESTAMP

plant_sensor_log

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • temperature — DECIMAL(5, 2)
  • humidity — DECIMAL(5, 2)
  • soil_moisture — DECIMAL(5, 2)
  • illuminance — DECIMAL(7, 2)
  • created_at — TIMESTAMP

plant_status

  • plant_id — INTEGER — Foreign key → plant.id
  • water_status — VARCHAR(20)
  • disease_status — VARCHAR(20)
  • is_pledged — BOOLEAN
  • updated_at — TIMESTAMP

plant_timelapse

  • id — SERIAL
  • plant_id — INTEGER — Foreign key → plant.id — NOT NULL
  • image_url — TEXT
  • created_at — TIMESTAMP

ref_achievement

  • id — SERIAL
  • name — VARCHAR(100)
  • description — TEXT
  • icon_url — TEXT
  • action_type — VARCHAR(20)
  • required_count — INTEGER
  • created_at — TIMESTAMP

ref_plant_disease

  • id — SERIAL
  • name — VARCHAR(100)
  • symptom — TEXT
  • duration — INTEGER
  • causation — TEXT
  • instruction — TEXT
  • created_at — TIMESTAMP

ref_plant_species

  • id — SERIAL
  • name — VARCHAR(100)
  • image_url — TEXT
  • temp_target — INTEGER
  • temp_range — VARCHAR(50)
  • humid_target — INTEGER
  • humid_range — VARCHAR(50)
  • soil_target — INTEGER
  • soil_range — VARCHAR(50)
  • illuminance — INTEGER
  • created_at — TIMESTAMP

users

  • id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • profile_image_url — TEXT
  • fcm_token — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — BOOLEAN