test

Tables (7)

Bookmark (bookmark)

  • id — Primary key — NOT NULL
  • message (message_id) — Foreign key → Message.id — NOT NULL
  • member (member_id) — Foreign key → Member.id — NOT NULL
  • Field

Channel (Untitled4)

  • id — Primary key — NOT NULL
  • workspace (workspace_id) — Foreign key → Workspace.id — NOT NULL
  • slackId (slack_id)
  • name

ChannelSubscription (channel_subscription)

  • id — Primary key — NOT NULL
  • channel (channel_id) — Foreign key → Channel.id — NOT NULL
  • member (member_id) — Foreign key → Member.id — NOT NULL
  • viewOrder (view_order)

Member (member)

  • id — Primary key — NOT NULL
  • workspace (workspace_id) — Foreign key → Workspace.id — NOT NULL
  • slackId (slack_id)
  • thumbnailUrl (thumbnail_url)
  • isFirstLogin (first_login)

Message (message)

  • id — Primary key — NOT NULL
  • member (member_id) — Foreign key → Member.id — NOT NULL
  • channel (channel_id) — Foreign key → Channel.id — NOT NULL
  • slackId (slack_message_id)
  • text
  • postedDate (posted_date)
  • modifiedDate (modified_date)

Reminder (reminder)

  • id — Primary key — NOT NULL
  • message (message_id) — Foreign key → Message.id — NOT NULL
  • member (member_id) — Foreign key → Member.id — NOT NULL
  • remindDate (remind_date)

Workspace (workspace)

  • id — Primary key — NOT NULL
  • teamId (team_id)
  • botToken (access_token)