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