External Links
Data Entity
Description
Organization-configurable external resource URLs and metadata displayed to peer mentors and coordinators, providing curated access to Bufdir guidelines, training materials, organizational handbooks, and other relevant external content.
Data Structure
| Name | Type | Description | Constraints |
|---|---|---|---|
id |
uuid |
Unique identifier for the external link record | PKrequiredunique |
organization_id |
uuid |
Organization that owns and configured this link, enforcing multi-tenant isolation | required |
title |
string |
Display title of the external resource shown in the resources screen | required |
description |
text |
Brief description of the resource content and purpose | - |
url |
string |
Full URL of the external resource | required |
category |
string |
Grouping category for organizing links in the resources screen | required |
icon |
string |
Icon identifier or emoji used to visually represent the link in the UI | - |
sort_order |
integer |
Display order within the category, lower values appear first | required |
is_active |
boolean |
Whether the link is currently visible to users; allows soft-disabling without deletion | required |
open_in_app_browser |
boolean |
If true, opens in an in-app browser; if false, opens in the system default browser | required |
visible_to_roles |
json |
Array of role IDs that can see this link; empty array or null means visible to all roles | - |
created_by |
uuid |
User ID of the administrator who created this link | required |
created_at |
datetime |
Timestamp when the link was created | required |
updated_at |
datetime |
Timestamp of the last modification | required |
Database Indexes
idx_external_links_org_active
Columns: organization_id, is_active
idx_external_links_org_category_sort
Columns: organization_id, category, sort_order
idx_external_links_created_by
Columns: created_by
Validation Rules
valid_url_format
error
Validation failed
title_not_blank
error
Validation failed
category_not_blank
error
Validation failed
valid_organization_reference
error
Validation failed
valid_roles_array
error
Validation failed
url_max_length
error
Validation failed
Business Rules
organization_scoped_visibility
Links are scoped to the owning organization; users can only see links belonging to their own organization
role_based_link_visibility
When visible_to_roles is populated, only users with matching roles can see the link; null or empty means all roles
soft_disable_over_delete
Links should be deactivated (is_active=false) rather than deleted to preserve audit history; hard delete allowed for draft links only
admin_only_management
Only Organization Admins and Global Admins can create, update, or delete external links
category_ordering
Links within a category are displayed sorted by sort_order ascending; ties broken by title alphabetically