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