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