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`