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