slack-socket

Tables (8)

channelchats

  • id — int — Primary key — NOT NULL
  • content — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • UserId — int
  • ChannelId — int
  • INDEX — `ChannelId`
  • INDEX — `UserId`

channelmembers

  • UserId — int — Primary key — NOT NULL
  • ChannelId — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • INDEX — `UserId`

channels

  • id — int — Primary key — NOT NULL
  • private — tinyint(1)
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • WorkspaceId — int
  • INDEX — `WorkspaceId`

dms

  • id — int — Primary key — NOT NULL
  • content — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • WorkspaceId — int
  • SenderId — int
  • ReceiverId — int
  • WorkspacedId — int
  • INDEX — `dms_ibfk_3`
  • INDEX — `dms_ibfk_2`
  • INDEX — `WorkspaceId`

mentions

  • id — int — Primary key — NOT NULL
  • category — enum — NOT NULL
  • ChatId — int
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • WorkspaceId — int
  • SenderId — int
  • ReceiverId — int
  • WorkspacedId — int
  • INDEX — `ReceiverId`
  • INDEX — `SenderId`
  • INDEX — `WorkspaceId`

users

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

workspacemembers

  • WorkspaceId — int — Primary key — NOT NULL
  • UserId — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • loggedInAt — datetime
  • INDEX — `UserId`

workspaces

  • id — int — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • url — varchar(30) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • OwnerId — int
  • INDEX — `OwnerId`