Messenger

Tables (10)

blockit (Untitled6)

  • blockit (Key) — INT — Primary key — NOT NULL
  • createdAt (Field) — DATE
  • user_id (Key2) — INT — Foreign key → user.user_id

chatMessage (Untitled5)

  • message_id (Key) — INT — Primary key — NOT NULL
  • chatroom_id (Key2) — INT — Foreign key → chatRoom.chatroom_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → user.user_id
  • createdAt (Field) — DATE
  • massage (Field2) — VARCHAR(300)
  • chatread (Field3) — TINYINT(1)
  • opromm_id (Key4) — INT — Foreign key → openchatRoom.opromm_id — NOT NULL

chatMessageLike (Untitled11)

  • cm_like (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → user.user_id
  • message_id (Key3) — INT — Foreign key → chatMessage.message_id — NOT NULL

chatRoom (Untitled4)

  • chatroom_id (Key) — INT — Primary key — NOT NULL
  • roomName (Field2) — VARCHAR(20)
  • createdAt (Field) — DATE
  • user_id (Key2) — INT — Foreign key → user.user_id
  • profile_id (Key3) — INT — Foreign key → multiProfile.profile_id — NOT NULL

hobby (Untitled9)

  • hobby_id (Key) — INT — Primary key — NOT NULL
  • hobby (Field) — VARCHAR(50)
  • profile_id (Key2) — INT — Foreign key → multiProfile.profile_id — NOT NULL

multiProfile (Untitled2)

  • profile_id (Key) — INT — Primary key — NOT NULL
  • profileImg (Field) — VARCHAR(200)
  • coverImg (Field2) — VARCHAR(200)
  • statusMsg (Field4) — VARCHAR(30)
  • school (Field5) — VARCHAR(20)
  • rectal (Field6) — VARCHAR(30)
  • residence (Field7) — VARCHAR(30)
  • status (Field8) — VARCHAR(20)
  • nickName (Field3) — VARCHAR(20)
  • user_id (Key2) — INT — Foreign key → user.user_id

openchatRoom (Untitled15)

  • opromm_id (Key) — INT — Primary key — NOT NULL
  • oproomName (Field) — VARCHAR(20)
  • createdAt (Field2) — DATE
  • Introducemsg (Field3) — VARCHAR(150)
  • user_id (Key2) — INT — Foreign key → user.user_id
  • profile_id (Key3) — INT — Foreign key → multiProfile.profile_id — NOT NULL

openchatRoomlike (Untitled14)

  • oprommlike_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → user.user_id
  • opromm_id (Key3) — INT — Foreign key → openchatRoom.opromm_id — NOT NULL

sociallogin (Untitled7)

  • soclogin_id (Key) — INT — Primary key — NOT NULL
  • soc_type (Field) — VARCHAR(100)
  • soc_account_id (Field2) — VARCHAR(100)
  • soc_key (Field3) — VARCHAR(80)
  • soc_value (Field4) — VARCHAR(200)
  • user_id (Key2) — INT — Foreign key → user.user_id

user (Untitled)

  • user_id (Key) — INT — Primary key
  • id (Field11) — VARCHAR(20)
  • name (Field4) — VARCHAR(20)
  • email (Field) — VARCHAR(25)
  • password (Field2) — VARCHAR(25)
  • mobile (Field3) — VARCHAR(20)
  • birth (Field5) — CHAR(10)
  • createdAt (Field9) — DATE
  • updatedAt (Field10) — DATE
  • following (Field6) — INT
  • followers (Field7) — INT