chat
Tables (4)
chat-room (Untitled3)
- roomnum (Key) — Primary key — NOT NULL
- userCount (Field)
message (Untitled2)
- msgID (Key) — Primary key — NOT NULL
- content (Field3)
- roomnum (Key2) — Foreign key → chat-room.roomnum — NOT NULL
- sendAt (Field2)
- userID (Key3) — Foreign key → user.userID — NOT NULL
- type (Field)
room-user (Untitled4)
- userID (Key) — Foreign key → user.userID — NOT NULL
- roomnum (Key2) — Foreign key → chat-room.roomnum — NOT NULL
- joinedAt (Field)
- lastReadAt (Field2)
user (Untitled)
- userID (Key) — Primary key — NOT NULL
- userName (Field)
- userPW (Field2)