a407
Tables (7)
User (user)
- id — int — Primary key — NOT NULL
- uid — varchar
- createdAt — varchar
- main_plant_id — int
alert
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- plantlst_id — int — Foreign key → plantlst.plantdata_id — NOT NULL
- alert — int
- createdAt — varchar
diary
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- userDiary — LONGTEXT
- plantDiary — LONGTEXT
- createdAt — varchar
- updatedAt — varchar
- image — varchar
- plant_nickname — varchar
iotdata
- id (PK) — int — Primary key — NOT NULL
- name — varchar
iotlst
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- iotdata_id — int — Foreign key → iotdata.id — NOT NULL
- nickname — varchar
- current — int
- wish — int
plantdata
- id — int — Primary key — NOT NULL
- name — varchar
- lifespanPrev — int
- lifespanNext — int
- tempPrev — int
- tempNext — int
- humiPrev — int
- humiNext — int
- uvPrev — int
- uvNext — int
plantlst
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- plantdata_id — int — Foreign key → plantdata.id — NOT NULL
- nickname — varchar
- image — varchar
- createdAt — varchar