Safe Slack

Tables (10)

channel_members

  • id — INT — Primary key
  • user_id — INT — Foreign key → users.id — NOT NULL
  • channel_id — INT — Foreign key → channels.id — NOT NULL
  • status — ENUM('pending', 'approved', 'rejected')
  • joined_at — TIMESTAMP

channels

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • is_default — BOOLEAN
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • workspace_id — INT — Foreign key → workspaces.id — NOT NULL
  • created_by — INT — Foreign key → users.id — NOT NULL

files

  • id — INT — Primary key
  • uploaded_by — INT — Foreign key → users.id — NOT NULL
  • channel_id — INT — Foreign key → channels.id — NOT NULL
  • min_role_id — INT — Foreign key → roles.id — NOT NULL
  • filename — VARCHAR(255)
  • s3_url — TEXT
  • valid_from — DATE
  • valid_to — DATE
  • uploaded_at — TIMESTAMP

invite_codes

  • id — INT — Primary key
  • created_by — INT — Foreign key → users.id — NOT NULL
  • workspace_id — INT — Foreign key → workspaces.id — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • expires_at — DATETIME
  • used — BOOLEAN
  • created_at — DATETIME
  • used_at — DATETIME

messages

  • id — INT — Primary key
  • user_id (user_Id) — INT — Foreign key → users.id — NOT NULL
  • channel_id — INT — Foreign key → channels.id — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP

roles

  • id — INT — Primary key
  • name — VARCHAR(50) — NOT NULL
  • level — INT — NOT NULL

users

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — TEXT — NOT NULL
  • profile_image — VARCHAR(255)
  • is_email_verified — BOOLEAN
  • created_at — TIMESTAMP

workspace_join_requests

  • id — INT — Primary key
  • user_id — INT — Foreign key → users.id — NOT NULL
  • workspace_id — INT — Foreign key → workspaces.id — NOT NULL
  • status — ENUM('pending', 'approved', 'rejected')
  • requested_at — TIMESTAMP
  • processed_at — TIMESTAMP

workspace_members

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • role_id — INT — Foreign key → roles.id — NOT NULL
  • workspace_id — INT — Foreign key → workspaces.id — NOT NULL
  • is_workspace_admin — BOOLEAN
  • is_contractor — BOOLEAN
  • start_date — DATE
  • end_date — DATE

workspaces

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP