Slack
Tables (8)
ChannelMembers
- UserId — int — Foreign key → users.id — NOT NULL
- Channelid — int — Foreign key → channels.id — NOT NULL
- createdAt — datetime
- updatedAt — datetime
channelChats
- id — int — Primary key — NOT NULL
- UserId — int — Foreign key → users.id — NOT NULL
- ChannelId — int — Foreign key → channels.id — NOT NULL
- createdAt — datetime
- content — text
- updatedAt — datetime
channels
- id — int — Primary key — NOT NULL
- name — VAR(30)
- WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
- private — tinyint(1)
- createdAt — datetime
- updatedAt — datetime
dms
- id — int — Primary key — NOT NULL
- content — text
- createdAt — datetime
- updatedAt — datetime
- Senderd — int — Foreign key → users.id — NOT NULL
- Receiverd — int — Foreign key → users.id — NOT NULL
- Workspaced (KeyWorkspaced) — int — Foreign key → workspaces.Key — NOT NULL
mentions
- id — int — Primary key — NOT NULL
- WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
- Senderd — int — Foreign key → users.id — NOT NULL
- Receiverd — int — Foreign key → users.id — NOT NULL
- category — enum('chat','dm','system')
- chatId — int
- createdAt — datetime
- updatedAt — datetime
users
- id — int — Primary key — NOT NULL
- email — VAR(30)
- nickname — VAR(30)
- password — VAR(100)
- createdAt — datetime
- updatedAt — datetime
- deletedAt — datetime
workepacemembers
- UserId — int — Foreign key → users.id — NOT NULL
- WorkspaceId — int — Foreign key → workspaces.Key — NOT NULL
- loggedInAt — datetime
- createdAt — datetime
- updatedAt — datetime
workspaces
- Key — Primary key — NOT NULL
- OwnerId — int — Foreign key → users.id — NOT NULL
- name — VAR(30)
- url — VAR(30)
- createdAt — datetime
- updatedAt — datetime
- deletedAt — datetime