Slack

Tables (8)

ChannelMembers

  • UserId — int — Foreign key → users.id — NOT NULL
  • Channelid — int — Foreign key → channels.id — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime

channelChats

  • id — int — Primary key — NOT NULL
  • UserId — int — Foreign key → users.id — NOT NULL
  • ChannelId — int — Foreign key → channels.id — NOT NULL
  • createdAt — datetime
  • content — text
  • updatedAt — datetime

channels

  • id — int — Primary key — NOT NULL
  • name — VAR(30)
  • WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
  • private — tinyint(1)
  • createdAt — datetime
  • updatedAt — datetime

dms

  • id — int — Primary key — NOT NULL
  • content — text
  • createdAt — datetime
  • updatedAt — datetime
  • Senderd — int — Foreign key → users.id — NOT NULL
  • Receiverd — int — Foreign key → users.id — NOT NULL
  • Workspaced (KeyWorkspaced) — int — Foreign key → workspaces.Key — NOT NULL

mentions

  • id — int — Primary key — NOT NULL
  • WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
  • Senderd — int — Foreign key → users.id — NOT NULL
  • Receiverd — int — Foreign key → users.id — NOT NULL
  • category — enum('chat','dm','system')
  • chatId — int
  • createdAt — datetime
  • updatedAt — datetime

users

  • id — int — Primary key — NOT NULL
  • email — VAR(30)
  • nickname — VAR(30)
  • password — VAR(100)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime

workepacemembers

  • UserId — int — Foreign key → users.id — NOT NULL
  • WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
  • loggedInAt — datetime
  • createdAt — datetime
  • updatedAt — datetime

workspaces

  • Key — Primary key — NOT NULL
  • OwnerId — int — Foreign key → users.id — NOT NULL
  • name — VAR(30)
  • url — VAR(30)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime