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