farm
Tables (12)
plant
- id — BIGINT — Primary key — NOT NULL
- users_id — BIGINT — Foreign key → users.id — NOT NULL
- ref_plant_species_id — BIGINT — Foreign key → ref_plant_species.id — NOT NULL
- nickname — VARCHAR(50)
- profile_image_url — TEXT
- health_status — VARCHAR(50)
- health_checked_at — DATETIME
- love_temperature — INTEGER — NOT NULL
- is_active — BOOLEAN
- station_point — VARCHAR(255)
- started_at — DATETIME
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
plant_achievement
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — Foreign key → plant.id — NOT NULL
- ref_achievement_id — BIGINT — Foreign key → ref_achievement.id — NOT NULL
- created_at — DATETIME — NOT NULL
plant_activity_counts
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — Foreign key → plant.id — NOT NULL
- activity_type — VARCHAR(50) — NOT NULL
- total_count — INTEGER
- updated_at — DATETIME — NOT NULL
plant_activity_log
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — Foreign key → plant.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
plant_diary
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — Foreign key → plant.id — NOT NULL
- content — TEXT
- image_url — TEXT
- happened_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
plant_health_logs
- id — BIGINT — Primary key — NOT NULL
- plant_timelapse_id — BIGINT — Foreign key → plant_timelapse.id — NOT NULL
- ref_plant_disease_id — BIGINT — Foreign key → ref_plant_disease.id — NOT NULL
- confidence — DECIMAL(5,2)
- created_at — DATETIME — NOT NULL
plant_sensor_log
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — 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 — DATETIME — NOT NULL
plant_timelapse
- id — BIGINT — Primary key — NOT NULL
- plant_id — BIGINT — Foreign key → plant.id — NOT NULL
- image_url — TEXT
- created_at — DATETIME — NOT NULL
ref_achievement
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- icon_url — TEXT
- action_type — VARCHAR(50)
- required_count — INTEGER
- created_at — DATETIME — NOT NULL
ref_plant_disease
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- symptoms — TEXT
- solution — TEXT
- created_at — DATETIME — NOT NULL
ref_plant_species
- id — BIGINT — Primary key — NOT NULL
- 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 — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100)
- profile_image_url — TEXT
- fcm_token — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL