sl

Tables (8)

channelChats

  • id — serial
  • content — text — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • channelId — integer — NOT NULL
  • userId — integer — NOT NULL

channelMembers

  • channelId — integer — Primary key — NOT NULL
  • userId — integer — Primary key — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

channels

  • id — serial
  • name — varchar(30) — NOT NULL
  • private — boolean — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • workspaceId — integer — NOT NULL

dms

  • id — serial
  • content — text — NOT NULL
  • createdAt — timestamp
  • workspaceId — integer — NOT NULL
  • senderId — integer — NOT NULL
  • receiverId — integer — NOT NULL

mentions

  • id — serial
  • category — varchar(10)
  • dm::character — varying
  • system::character — varying)::text))
  • chatId — integer — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • workspaceId — integer — NOT NULL
  • senderId — integer
  • receiverId — integer

users

  • id — serial
  • email — varchar(30) — NOT NULL
  • nickname — varchar(30) — NOT NULL
  • password — varchar(100) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • deletedAt — timestamp

workspaceMembers

  • workspaceId — integer — Primary key — NOT NULL
  • userId — integer — Primary key — NOT NULL
  • loggedInAt — timestamp
  • createdAt — timestamp
  • updatedAt — timestamp

workspaces

  • id — serial
  • name — varchar(30) — NOT NULL
  • url — varchar(30) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • deletedAt — timestamp
  • ownerId — integer — NOT NULL