final

Tables (7)

Clap (clap)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Id (memberId) — BIGINT — Foreign key → Member.Id — NOT NULL
  • Id (feedId) — BIGINT — Foreign key → Feed.Id — NOT NULL

Feed (feed)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field (imgUrl) — VARCHAR(255)
  • Field (content) — TEXT(280)
  • Field (missionName) — VARCHAR(80)
  • Field (createdAt) — DATETIME
  • Field (modifiedAt) — DATETIME
  • Id (memberId) — BIGINT — Foreign key → Member.Id — NOT NULL
  • Field (clapCount) — BIGINT

Member (member)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field (kakaoId) — BIGINT
  • Field (nickname) — VARCHAR(80)
  • Field (name) — VARCHAR(80)
  • Field (email) — VARCHAR(80)
  • Field (password) — VARCHAR(255)
  • Field (profilePhoto) — VARCHAR(255)
  • Field (createdAt) — DATETIME
  • Field (modifiedAt) — DATETIME

MissionStatus (missionStatus)

  • Key — Primary key — NOT NULL
  • Field (missionStatus) — Boolean
  • Id (memberId) — BIGINT — Foreign key → Member.Id — NOT NULL
  • Id (missionId) — BIGINT — Foreign key → Missions.Id — NOT NULL

Missions (missions)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field (missionName) — VARCHAR(80)
  • Field (missionContent) — VARCHAR(220)
  • Field (missionImageUrl) — VARCHAR(255)
  • Field (missionType) — VARCHAR(80)

MyPost (post)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field (createdAt) — DATETIME
  • Field (modifiedAt) — DATETIME
  • Id (memberId) — BIGINT — Foreign key → Member.Id — NOT NULL
  • Id (submitMission) — BIGINT — Foreign key → SubmitMission.Id — NOT NULL

SubmitMission (Untitled)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field (status) — VARCHAR(10)
  • Field (creeatedAt) — DATETIME
  • Field (modifiedAt) — DATETIME
  • Id (memberId) — BIGINT — Foreign key → Member.Id — NOT NULL
  • Field (imgUrl) — VARCHAR(255)
  • Id (missionId) — BIGINT — Foreign key → Missions.Id — NOT NULL