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