MBTI SNS
Tables (6)
Chattings (Untitled4)
- chat_id (Key) — int — Primary key — NOT NULL
- createdAt (Field2) — Date
- updatedAt (Field3) — Date
Comments (Untitled6)
- comment_id (Key) — int — Primary key — NOT NULL
- post_id (Key2) — int — Foreign key → Posts.post_id — NOT NULL
- user_id (Key3) — int — Foreign key → Users.user_id — NOT NULL
- text (Field) — String
- createdAt (Field2) — Date
- updatedAt (Field3) — Date
Messages (Untitled5)
- message_id (Key) — int — Primary key — NOT NULL
- chat_id (Key2) — int — Foreign key → Chattings.chat_id — NOT NULL
- content (Field) — String
- createdAt (Field2) — Date
- updatedAt (Field3) — Date
Posts (Untitled3)
- post_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → Users.user_id — NOT NULL
- boardType (Field) — Enum — ISTJ, ISFJ, INFJ, INTJ ISTP, ISFP, INFP, INTP ESTP, ESFP, ENFP, ENTP ESTJ, ESFJ, ENFJ, ENTJ All
- title (Field2) — String
- text (Field3) — String
- image (Field4) — Json — NOT NULL
- likes (Field5) — int
- createdAt (Field6) — Date
- updatedAt (Field7) — Date
UserChatting (Untitled2)
- user_id (Key) — int — Foreign key → Users.user_id — NOT NULL
- chat_id (Key2) — int — Foreign key → Chattings.chat_id — NOT NULL
Users (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- firstName (Field) — String
- lastName (Field2) — String
- email (Field3) — String
- phoneNumber (Field4) — String
- isVerificated (Field5) — bool
- password (Field6) — String
- thumnail (Field7) — json — NOT NULL — 유저의 프로필사진
- gender (Field8) — Enum — M: 남자 W: 여자
- nickname (Field9) — String
- mbtiType (Field10) — Enum — ISTJ, ISFJ, INFJ, INTJ ISTP, ISFP, INFP, INTP ESTP, ESFP, ENFP, ENTP ESTJ, ESFJ, ENFJ, ENTJ
- createdAt (Field11) — Date
- updatedAt (Field12) — Date