FLOW

Tables (7)

extension_activity_logs

  • id — UUID
  • user_id — UUID — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

fixed_blocked_extensions

  • id — UUID
  • extension — VARCHAR(20) — NOT NULL
  • display_name — VARCHAR(50)
  • is_blocked — BOOLEAN
  • is_system — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

system_settings

  • id — UUID
  • setting_key — VARCHAR(100) — NOT NULL
  • setting_value — TEXT
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_custom_blocked_extensions

  • id — UUID
  • user_id — UUID
  • extension — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP
  • UNIQUE(user_id, — extension)

user_fixed_blocked_extensions

  • id — UUID
  • user_id — UUID
  • extension_id — UUID
  • is_blocked — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(user_id, — extension_id)

user_sessions

  • id — UUID
  • user_id — UUID
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP