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