🏠 Overview › 🧩 Components ›🧩 Resource Links Table (PostgreSQL)

Resource Links Table (PostgreSQL)

Component Detail

Data Layer low complexity backend
0
Dependencies
0
Dependents
0
Entities
0
Integrations

Description

PostgreSQL table storing the org-configurable external resource link catalogue. Each row belongs to one organization and optionally targets a specific role. Supports category grouping, display ordering, and active/inactive toggles without requiring an app release.

Feature: External Resource Links

resource-links-table

Responsibilities

  • Persist link entries per organization with category, display name, description, and URL
  • Support optional role_filter for peer-mentor-specific or coordinator-specific links
  • Support display_order for category and item sequencing
  • Support is_active flag for toggling links without deletion

Interfaces

SELECT * FROM resource_links WHERE org_id = $1 AND (role_filter IS NULL OR role_filter = $2) AND is_active = true ORDER BY category, display_order
INSERT / UPDATE / DELETE resource_links