super42
Tables (7)
Block (block)
- Block Id (Key) — Int — Primary key — NOT NULL
- Blocker Id (blocker_id) — Int — Foreign key → User.UserId — NOT NULL
- Blocked Id (blocked_id) — Int — Foreign key → User.UserId — NOT NULL
Chatroom (chatroom)
- Chatroom Id (chatroom_id) — Int — Primary key — NOT NULL
- Last message (last_message) — VARCHAR
- Updated at (updated at) — Date
Friend (friend)
- Friend Id (friend_id) — Int — Primary key — NOT NULL
- User1 Id (user1_id) — Int — Foreign key → User.UserId — NOT NULL
- User2 Id (user2_id) — Int — Foreign key → User.UserId — NOT NULL
- Created at (created_at) — Date
Friend Request (friend_request)
- Friend Request Id (friend_request_id) — Int — Primary key — NOT NULL
- From User Id (from_user_id) — Int — Foreign key → User.UserId — NOT NULL
- To User Id (to_user_id) — Int — Foreign key → User.UserId — NOT NULL
- Status (status) — choices
- Created at (created_at) — Date
Match (match)
- Match Id (match_id) — Int — Primary key — NOT NULL
- UserId (user_id) — Int — Foreign key → User.UserId — NOT NULL
- Oppenent Id (oppenent_id) — Int — Foreign key → User.UserId — NOT NULL
- User Score (user_score) — Int
- Oppenent Score (oppenent_score) — Int
- Timestamp (timestamp) — Date
Message (message)
- Message Id (message_id) — Int — Primary key — NOT NULL
- Chatroom Id (chatroom_id) — Int — Foreign key → Chatroom.Chatroom Id — NOT NULL
- Sender Id (sender_id) — Int — Foreign key → User.UserId — NOT NULL
- Receiver Id (receiver_id) — Int — Foreign key → User.UserId — NOT NULL
- Content (content) — VARCHAR
- Timestamp (timestamp) — Date
- Is read (is_read) — Boolean
User (user)
- UserId (user_id) — Int — Primary key — NOT NULL
- Email (email) — VARCHAR
- Nickname (nickname) — VARCHAR — NOT NULL
- Password (password) — VARCHAR
- Avatar (avatar) — VARCHAR
- Is active (is_active) — Boolean