chatNodeJS
Tables (6)
Chat (Untitled5)
- Id (chatId) — Primary key — NOT NULL
- chat
- createdAt (Field)
- roomId — Foreign key → Room.Id — NOT NULL
- userId — Foreign key → User.Id — NOT NULL
ChatRoomMember (Untitled3)
- Id (chatRoomMemberId) — Primary key — NOT NULL
- createdAt (Field)
- userId — Foreign key → User.Id — NOT NULL
- roomId — Foreign key → Room.Id — NOT NULL
Follow (Untitled4)
- createdAt (Field)
- followerId — Foreign key → User.Id — NOT NULL
- followingId — Foreign key → User.Id — NOT NULL
Friendship (Untitled6)
- status
- createdAt
- userAId — Foreign key → User.Id — NOT NULL
- userBId — Foreign key → User.Id — NOT NULL
Room (Untitled2)
- Id (roomId) — Primary key — NOT NULL
- roomType
- createdAt (Field2)
User (Untitled)
- Id (userId) — Primary key — NOT NULL
- email
- nick (Field2)
- password
- createdAt