My plant
Tables (4)
User (Untitled)
- user_id (ID) — varchar(30) — Primary key
- password — varchar(50)
- name — varchar(20)
- create_date (생성날짜) — date
plant (Untitled2)
- plant_id (Key) — Integer — Primary key — NOT NULL
- plant_name (이름) — varchar
- plant_Scientific_name (학명) — varchar
- plant_english_name (영명) — varchar
- plant_nick_name (유통명) — varchar
- plant_origin_region (원산지) — varchar
plant_list (Untitled3)
- list_id (id) — integer — Primary key
- plant_id (Key) — Integer — Foreign key → plant.plant_id — NOT NULL
- plant_image (식물 이미지) — imgage
plant_more_info (CopyOfUntitled2)
- plant_id (Key) — Integer — Primary key — NOT NULL
- plant_ classification (분류) — varchar
- plant_growth type (생육형태) — varchar
- plant_growth _height (생장높이) — varchar
- plant_growth_width (생장너비) — varchar
- plant_indoor_garden_composition (실내정원구성) — varchar
- plant_ecotype (생태형) — varchar
- plant_leaf_pattern (잎무늬) — varchar
- plant_scent (향기) — varchar
- plant_reproduction_method (번식방법) — varchar
- Plant_info_management _evel (정보관리수준) — varchar
- plant_management_requirements (관리요구도) — varchar
- plant_light_demand (광요구도) — varchar
- plant_placement (배치장소) — varchar
- plant_growth_rate (생장속도) — varchar
- plant_growth temperature (생육적온도) — varchar
- plant_minimum_winter_temperature (겨울최저온도) — varchar
- plant_humidity (습도) — varchar
- plant_fertilizer (비료) — varchar
- plant_watering_spring (물주기 봄) — varchar
- plant_watering_summer (물주기 여름) — varche
- plant_watering_autumn (물주기 가을) — varchar
- plant_watering_winter (물주기 겨울) — varchar