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