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