Chat

Tables (8)

channelchats

  • id — INT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • ChannelId — INT — Foreign key → channels.id
  • UserId — INT — Foreign key → users.id
  • INDEX — `ChannelId`
  • INDEX — `UserId`

channelmembers

  • ChannelId — INT — Foreign key → channels.id — NOT NULL
  • UserId — INT — Foreign key → users.id — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `UserId`

channels

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • private — TINYINT(1)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • WorkspaceId — INT — Foreign key → workspaces.id
  • INDEX — `WorkspaceId`

dms

  • id — INT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • WorkspaceId — INT — Foreign key → workspaces.id
  • SenderId — INT — Foreign key → users.id
  • ReceiverId — INT — Foreign key → users.id
  • INDEX — `WorkspaceId`
  • INDEX — `SenderId`
  • INDEX — `ReceiverId`

mentions

  • id — INT — Primary key — NOT NULL
  • category — ENUM('chat', 'dm', 'system') — NOT NULL
  • chatId — INT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • WorkspaceId — INT — Foreign key → workspaces.id
  • SenderId — INT — Foreign key → users.id
  • ReceiverId — INT — Foreign key → users.id
  • INDEX — `WorkspaceId`
  • INDEX — `SenderId`
  • INDEX — `ReceiverId`

users

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME

workspacemembers

  • WorkspaceId — INT — Foreign key → workspaces.id — NOT NULL
  • UserId — INT — Foreign key → users.id — NOT NULL
  • loggedInAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `UserId`

workspaces

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • url — VARCHAR(30) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • OwnerId — INT — Foreign key → users.id
  • INDEX — `OwnerId`