selact

Tables (8)

channelchats

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

channelmembers

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

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

dms

  • id — int — Primary key — NOT NULL
  • content — text — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • SenderId — int — Foreign key → users.id
  • ReceiverId — int — Foreign key → users.id
  • WorkspaceId — int — Foreign key → workspaces.id

mentions

  • id — int — Primary key — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • SenderId — int — Foreign key → users.id
  • ReceiverId — int — Foreign key → users.id
  • WorkspaceId — int — Foreign key → workspaces.id
  • ChannelId — int — Foreign key → channels.id

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

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

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