slack
Tables (4)
dms (Untitled2)
- id — NotNull — Primary key — NOT NULL
- WorkspaceId (id22) — Long — Foreign key → workspaces.OwnerId — NOT NULL
- SenderId (id3) — Long — Foreign key → user.id — NOT NULL
- content — text
- createdAt — datetime
- updatedAt — datetime
- ReceiverId (Field)
user
- id — Long — Primary key — NOT NULL
- username (email) — NotNull
- nickname — NotNull
- password — NotNull
- createdAt — datetime
- updateAt — datetime
- deleteAt — datetime
workspacemembers
- UserId — Long — Foreign key → user.id — NOT NULL
- WorkspaceId — Long — Foreign key → workspaces.OwnerId — NOT NULL
- createdAt — datetime
- updatedAt — datetime
- loggedInAt — datetime
workspaces (Untitled)
- id — Long — Primary key — NOT NULL
- OwnerId (id2) — Long — Foreign key → user.id — NOT NULL
- name — NotNull
- url — NotNull
- createdAt — datetime
- updateAt — datetime
- deletedAt — datetime