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