Chat
Tables (8)
channelchats
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- ChannelId — INT — Foreign key → channels.id
- UserId — INT — Foreign key → users.id
- INDEX — `ChannelId`
- INDEX — `UserId`
channelmembers
- ChannelId — INT — Foreign key → channels.id — NOT NULL
- UserId — INT — Foreign key → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `UserId`
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
- INDEX — `WorkspaceId`
dms
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- WorkspaceId — INT — Foreign key → workspaces.id
- SenderId — INT — Foreign key → users.id
- ReceiverId — INT — Foreign key → users.id
- INDEX — `WorkspaceId`
- INDEX — `SenderId`
- INDEX — `ReceiverId`
mentions
- id — INT — Primary key — NOT NULL
- category — ENUM('chat', 'dm', 'system') — NOT NULL
- chatId — INT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- WorkspaceId — INT — Foreign key → workspaces.id
- SenderId — INT — Foreign key → users.id
- ReceiverId — INT — Foreign key → users.id
- INDEX — `WorkspaceId`
- INDEX — `SenderId`
- INDEX — `ReceiverId`
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
- WorkspaceId — INT — Foreign key → workspaces.id — NOT NULL
- UserId — INT — Foreign key → users.id — NOT NULL
- loggedInAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `UserId`
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
- INDEX — `OwnerId`