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