| id |
int(11)
|
|
|
|
| name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| strain_id |
int(11)
|
|
|
|
| grow_type |
enum('indoor', 'outdoor', 'greenhouse')
|
utf8mb4_unicode_ci
|
|
|
| medium |
enum('soil', 'coco', 'hydro', 'aero', 'other')
|
utf8mb4_unicode_ci
|
|
|
| plant_count |
int(11)
|
|
|
|
| start_date |
date
|
|
|
|
| harvest_date |
date
|
|
|
|
| current_stage |
enum('soil_prep', 'germination', 'seedling', 'vegetative', 'flowering', 'flushing', 'harvest', 'curing')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'harvested', 'archived')
|
utf8mb4_unicode_ci
|
|
|
| yield_grams |
decimal(10,2)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
