MBTI SNS

Tables (6)

Userchatting (Untitled)

  • user_id (Key) — int — Foreign key → user.user_id — NOT NULL
  • chatting_id (Key2) — int — Foreign key → chatting.chatting_id — NOT NULL

chatting (Untitled12)

  • chatting_id (Key) — int — Primary key — NOT NULL
  • createdtime (Field3) — datetime

comment (Untitled11)

  • comment_id (Key) — int — Primary key — NOT NULL
  • post_id (Key2) — int — Foreign key → post.post_id — NOT NULL
  • user_id (Key22) — int — Foreign key → post.user_id — NOT NULL
  • user_id (Key3) — int — Foreign key → user.user_id — NOT NULL
  • content (Field) — string
  • createdAt (Field3) — datetime

message (Untitled13)

  • message_id (Key) — int — Primary key — NOT NULL
  • chatting_id (Key2) — int — Foreign key → chatting.chatting_id — NOT NULL
  • content (Field4) — string
  • createdAt (Field3) — datetime
  • user_id (Field) — int

post (Untitled10)

  • post_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
  • title (Field) — string
  • content_text (Field2) — string
  • content_img (Field3) — BLOB
  • createdAt (Field5) — datetime
  • updatedAt (Field8) — datetime
  • like (Field6) — int
  • boardType (Field4) — Enum

user (Untitled7)

  • user_id (Key) — int — Primary key — NOT NULL
  • firstName (Field) — string
  • lastName (Field2) — string
  • email (Field4) — string
  • password (Field5) — string
  • profileImg (Field6) — BLOB
  • phonNumber (Field3) — string
  • isVerificated (Field10) — boolean
  • nickname (Field7) — string
  • gender (Field8) — boolean
  • mbtiType (Field9) — ENUM