MBTI SNS_siyeon

Tables (7)

board (Untitled3)

  • board_id (Key) — int — Primary key — NOT NULL
  • name (Field) — string — NOT NULL
  • createAt (Field2) — datetime — NOT NULL
  • updateAt (Field3) — datetime — NOT NULL

chatting (Untitled6)

  • chatting_id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • createAt (Field) — datetime — NOT NULL
  • updateAt (Field2) — datetime — NOT NULL

comment (Untitled4)

  • comment_id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • post_id (Key2) — int — Foreign key → post.post_id — NOT NULL
  • user_id (user_id2) — int — Foreign key → post.user_id — NOT NULL
  • board_id (Key22) — int — Foreign key → post.board_id — NOT NULL
  • content (Field) — string — NOT NULL
  • createAt (Field2) — datetime — NOT NULL
  • updateAt (Field3) — datetime — NOT NULL

message (Untitled5)

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

post (Untitled2)

  • post_id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • board_id (Key2) — int — Foreign key → board.board_id — NOT NULL
  • name (Field) — string — NOT NULL
  • content (Field2) — string — NOT NULL
  • image (Field3) — json — NOT NULL
  • category (Field4) — ENUM — NOT NULL
  • like (Field7) — int — NOT NULL
  • createAt (Field5) — datetime — NOT NULL
  • updateAt (Field6) — datetime — NOT NULL

user (Untitled)

  • user_id — int — Primary key — NOT NULL
  • name — string — NOT NULL
  • email (Field) — string — NOT NULL
  • password (Field2) — string — NOT NULL
  • sex (Field3) — bool — NOT NULL
  • image (Field4) — json — NOT NULL
  • myMBTI (Field5) — ENUM — NOT NULL
  • phoneNum (Field6) — string — NOT NULL
  • isCertified (Field7) — bool — NOT NULL
  • createAt (Field8) — datetime — NOT NULL
  • updateAt (Field9) — datetime — NOT NULL

verification (Untitled7)

  • veri_id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • isVerified (Field) — bool — NOT NULL
  • creatAt (Field2) — datetime — NOT NULL
  • updateAt (Field3) — datetime — NOT NULL