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