gardener-1

Tables (19)

Answer (QnA-Answer)

  • PK (id) — Primary key — NOT NULL
  • FK (question_id) — Foreign key → Question.PK — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 제목 (title)
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

CardNews (Notice-CardNews)

  • PK (id) — Primary key — NOT NULL
  • 제목 (title)
  • 내용 (content)

Challenge (Notice-Challenge)

  • PK (id) — Primary key — NOT NULL
  • 제목 (title)
  • 내용 (content)

Comment (Community-comment)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • FK (post_id) — Foreign key → Post.PK — NOT NULL
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Comment (Challenge-comment)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • FK (challenge_id) — Foreign key → Challenge.PK — NOT NULL
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Follower (follow-follower)

  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 팔로워 (follower)
  • 팔로잉 (following)

General User (User)

  • PK (id) — Primary key — NOT NULL
  • 닉네임 (ID)
  • 비밀번호 (password)
  • 이메일 (email)
  • 포인트 (score)
  • 이름 (name)
  • 생년월일 (birth)

Like (likes)

  • PK (post_id) — Foreign key → Post.PK — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL

MyPlant (User-myplant)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 식물명 (name)
  • 사진 (image)

Notice

  • PK (id) — Primary key — NOT NULL
  • 제목 (title)
  • 내용 (content)

Plant (Search)

  • PK (id) — Primary key — NOT NULL
  • 식물명 (name)
  • 식물사진 (photo)
  • 관수주기(봄) (water_period_spring)
  • 관수주기(여름) (water_period_summer)
  • 관수주기(가을) (water_period_autumn)
  • 관수주기(겨울) (water_period_winter)
  • 생장속도 (growth_velocity)
  • 생장형 (growth_form)
  • 광도요구 (sunlight)
  • 생육온도 (growth_temp)
  • 관리수준 (care_difficulty)
  • 습도 (humidity)
  • 설명 (content)
  • 계절 (management_level)
  • 꽃 (flower)

Post (Community-post)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 제목 (title)
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)
  • 태그 (tag)

Question (QnA-Question)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 제목 (title)
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Reply (Challenge-reply)

  • PK (id) — Primary key — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • FK (comment_id) — Foreign key → Comment.PK — NOT NULL
  • FK (challenge_id) — Foreign key → Challenge.PK — NOT NULL
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Reply (CardNews-Reply)

  • PK (id) — Primary key — NOT NULL
  • FK (cardnews_id) — Foreign key → CardNews.PK — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Reply (Community-reply)

  • PK (id) — Primary key — NOT NULL
  • FK (post_id) — Foreign key → Post.PK — NOT NULL
  • FK (comment_id) — Foreign key → Comment.PK — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL
  • 내용 (content)
  • 게시일 (created_at)
  • 수정일 (updated_at)

Scrap

  • PK (id) — Primary key — NOT NULL
  • FK (plant_id) — Foreign key → Plant.PK — NOT NULL
  • FK (generalUser_id) — Foreign key → General User.PK — NOT NULL

Tagged_posts (Community-tagged_posts)

  • PK (id) — Primary key — NOT NULL
  • FK (post_tag) — Foreign key → Post.PK — NOT NULL
  • FK (tag) — Foreign key → Tags.PK — NOT NULL

Tags (Community-tag)

  • PK (id) — Primary key — NOT NULL