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