MBTI

Tables (11)

BalanceGame (Untitled8)

  • gameId (Key) — bigint — Primary key — NOT NULL
  • firstOption (Field) — text
  • secondOption (Field2) — text
  • firstOptionCount (Field3) — bigint
  • secondOptionCount (Field4) — bigint

BalanceGameResponse (Untitled9)

  • responseId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • mbtiTypeId (Key3) — bigint — Foreign key → Member.mbtiTypeId — NOT NULL
  • gameId (Key4) — bigint — Foreign key → BalanceGame.gameId — NOT NULL
  • selectOption (Field) — bigint

Board (Untitled7)

  • boardId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • mbtiTypeId (Key3) — bigint — Foreign key → Member.mbtiTypeId — NOT NULL
  • title (Field) — varchar
  • content (Field2) — text
  • createdAt (Field3) — timestamp
  • modifiedAt (Field4) — timpestamp

ImageGame (Untitled10)

  • gameId (Key) — bigint — Primary key — NOT NULL
  • topic (Field) — varchar(100)

ImageGameResponse (Untitled11)

  • responseId (Key) — bigint — Primary key — NOT NULL
  • memberId (Key2) — bigint — Foreign key → Member.memberId — NOT NULL
  • gameId (Key3) — bigint — Foreign key → ImageGame.gameId — NOT NULL
  • mbtiTypeId (Key4) — bigint — Foreign key → Mbti.mbtiTypeId — NOT NULL

Mbti (Untitled3)

  • mbtiTypeId (Key) — bigint — Primary key — NOT NULL
  • mbtiName (Field) — varchar

Mbti_Answer_Option (Untitled4)

  • optionId (Key) — bigint — Primary key — NOT NULL
  • questionId (Key2) — bigint — Foreign key → Mbti_Question.questionId — NOT NULL
  • optionText (Field) — text
  • firstScore (Field2) — bigint
  • secondScore (Field3) — bigint

Mbti_Question (Untitled2)

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

Mbtmi (Untitled12)

  • mbtmiId (Key) — bigint — Primary key — NOT NULL
  • mbtiTypeId (Key2) — bigint — Foreign key → Mbti.mbtiTypeId — NOT NULL
  • description (Field) — text
  • description2 (Field2) — text
  • description3 (Field3) — text

Member (Untitled)

  • memberId (Key) — bigint — Primary key — NOT NULL
  • mbtiTypeId (Key2) — bigint — Foreign key → Mbti.mbtiTypeId — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • nickName (Field3) — varchar
  • memberStatus (Field5) — enum

Result (Untitled6)

  • resultId (Key) — bigint — Primary key — NOT NULL
  • mbtiTypeId (Key3) — bigint — Foreign key → Mbti.mbtiTypeId — NOT NULL
  • eScore (Field) — bigint
  • iScore (Field2) — bigint
  • sScore (Field3) — bigint
  • nScore (Field4) — bigint
  • fScore (Field5) — bigint
  • tScore (Field6) — bigint
  • jScore (Field7) — bigint
  • pScore (Field8) — bigint