MBTI 투게더
MBTI 투게더 ERD
테이블 (10)
applicant
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- Key (recId) — int — 외래 키 → recruitment.Key — NOT NULL
- Key (nickname) — varchar(20) — 외래 키 → user.Key — NOT NULL
- permitted — boolean
comment
- Key (comId) — int — 기본 키 — NOT NULL
- Key (postId) — int — 외래 키 → post.Key — NOT NULL
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- nickname — varchar(20) — NOT NULL
- comText — text — NOT NULL
- comDate — date — NOT NULL
- isDeleted — boolean
- secret — varchar(50)
follow
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- Key (following) — varchar(50) — 외래 키 → user.Key — NOT NULL
- Key (nickname) — varchar(20) — 외래 키 → user.Key — NOT NULL
groupInfo
- Key (groupId) — int — 기본 키 — NOT NULL
- groupName — varchar(50) — NOT NULL
- groupImg — varchar(250)
- groupIntro — text
- groupLocation — varchar(50)
- groupdate — date
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- Key (nickname) — varchar(20) — 외래 키 → user.Key — NOT NULL
- groupEndDate — date
- Key (recId) — int — 외래 키 → recruitment.Key — NOT NULL
- groupState — varchar(10) — NOT NULL
likeInfo
- Key (postId) — int — 외래 키 → post.Key — NOT NULL
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- isLiked — boolean — NOT NULL
participant
- Key (groupId) — int — 외래 키 → groupInfo.Key — NOT NULL
- Key (email) — varchar(50) — 외래 키 → user.Key — NOT NULL
- Key (nickname) — varchar(20) — 외래 키 → user.Key — NOT NULL
post
- Key (postId) — int — 기본 키 — NOT NULL
- email — varchar(50)
- nickname — varchar(20) — NOT NULL
- postTitle — varchar(50) — NOT NULL
- postText — text — NOT NULL
- postDate — date — NOT NULL
- editDate — date
- groupId — int
recruitment
- Key (recId) — int — 기본 키 — NOT NULL
- recEndDate — date — NOT NULL
- recState — boolean
user
- Key (email) — varchar(50) — 기본 키 — NOT NULL
- password — varchar(100) — NOT NULL
- nickname — varchar(20) — NOT NULL
- intro — text
- Field (profileImg) — varchar(250)
- MBTI — varchar(4) — NOT NULL
- userSignDate — date — NOT NULL
- isBanned — boolean
- isDeleted — boolean
- role — varchar(10) — NOT NULL
- googleConnected — boolean
views
- Key (postId) — int — 외래 키 → post.Key — NOT NULL
- views — int — NOT NULL