MeetBTI

Tables (16)

Answer (질문의 선택지)

  • answerId (Key) — bigint — Primary key — NOT NULL
  • questionId (Key2) — bigint — Foreign key → Question.questionId — NOT NULL
  • content (Field) — text
  • score (Field2) — bigint

Balancegame (벨런스 게임)

  • balanveGameId (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(50)
  • leftOption (Field2) — varchar(100)
  • rigthOption (Field3) — varchar(100)
  • nickName (Field4) — varchar(10)
  • gameStatus (Field5) — varchar(10)
  • createdAt (Field6) — timeStamp

Balancegame_comment (벨런스 게임 댓글)

  • commentId (Key) — bigint — Primary key — NOT NULL
  • gameId (Key2) — bigint — Foreign key → Balancegame.balanveGameId — NOT NULL
  • memberId (Key3) — bigint — Foreign key → Member.memberId — NOT NULL
  • content (Field) — text
  • createdAt (Field2) — timeStamp
  • modifiedAt (Field3) — timeStamp

Balancegame_result (벨런스 게임 결과)

  • resultId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key3) — bigint — Foreign key → Member.memberId — NOT NULL
  • balanceGameId (Key2) — bigint — Foreign key → Balancegame.balanveGameId — NOT NULL
  • selectOption (Field) — varchar(1)

Heart (좋아요)

  • heartId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • postId (Key3) — bigint — Foreign key → Post.postId — NOT NULL
  • commentId (Key4) — bigint — Foreign key → Post_comment.commentId — NOT NULL
  • balanveGameId (Key5) — bigint — Foreign key → Balancegame.balanveGameId — NOT NULL
  • ImageGameId (Key6) — bigint — Foreign key → Imagegame.ImageGameId — NOT NULL

Imagegame (이미지 게임)

  • ImageGameId (Key) — bigint — Primary key — NOT NULL
  • topic (Field) — text
  • nickName (Field2) — varchar(10)
  • gameStatus (Field3) — varchar(!0)
  • createdAt (Field4) — timeStamp

Imagegame_comment (이미지 게임 댓글)

  • commentId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • ImageGameId (Key3) — bigint — Foreign key → Imagegame.ImageGameId — NOT NULL
  • content (Field) — text
  • createdAt (Field2) — timeStamp
  • modifiedAt (Field3) — timeStamp

Imagegame_result (이미지 게임 결과)

  • resultId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key3) — bigint — Foreign key → Member.memberId — NOT NULL
  • gameId (Key2) — bigint — Foreign key → Imagegame.ImageGameId — NOT NULL
  • selectOption (Field) — varchar(4)

Member (사용자)

  • memberId (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(30)
  • password (Field2) — varchar(100)
  • nickName (Field3) — varchar(10)
  • createdAt (Field4) — timeStamp
  • image (Field10) — varchar(255)
  • memberStatus (Field11) — varchar(10)
  • banExpiration (Field12) — date

Post (게시글)

  • postId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • title (Field) — varchar(50)
  • content (Field2) — text
  • createdAt (Field3) — timeStamp
  • modifiedAt (Field4) — timeStamp
  • category (Field5) — varchar(4)
  • postStatus (Field6) — varchar(10)
  • image (Field7) — varchar(255)

Post_comment (게시글댓글)

  • commentId (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.postId — NOT NULL
  • memberId (Key3) — bigint — Foreign key → Member.memberId — NOT NULL
  • content (Field) — text
  • createdAt (Field2) — timeStamp
  • modifiedAt (Field3) — timeStamp

Question (MBTI질문)

  • questionId (Key) — bigint — Primary key — NOT NULL
  • content (Field) — text
  • tendency (Field2) — varchar(5)

Report (신고)

  • reportId (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.postId — NOT NULL
  • commentId (Key3) — bigint — Foreign key → Post_comment.commentId — NOT NULL
  • reason (Field) — varchar(10)
  • reportStatus (Field2) — varcahr(10)

Role (권한)

  • roleId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • role (Field) — varchar(10)

Test_result (테스트 결과)

  • resultId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • mbti (Field) — varchar(4)
  • scoreEI (Field2) — int
  • scoreSN (Field3) — int
  • scoreFT (Field4) — int
  • scoreJP (Field5) — int
  • secondMbti (Field6) — varchar(4)
  • createdAt (Field7) — timeStamp

View (조회)

  • viewId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • postId (Key3) — bigint — Foreign key → Post.postId — NOT NULL