Skip to main content
The WebLink entity represents social media and web profile links in the Well system. It can be associated with people, companies, and workspaces, and includes platform identification and URL validation.

Table structure

Table name: web_links

Main fields

NameTypeRequiredConstraintsAllowed ValuesDescriptionExample
idstring, UUID, πŸ”’ systemβ€”Unique identifier (read-only)β€”Unique ID”web-link-uuid-123”
platformstringβšͺ NoPlatform identifierwebsite, linkedin, x, github, etc.Platform or service name”linkedin”
urlstringβœ… YesValid URL formatFull profile URLComplete URL to the profile”https://linkedin.com/in/johndoe”
created_atstring (ISO 8601) πŸ”’ systemβ€”auto timestampβ€”Creation timestamp”2023-01-01T12:00:00Z”
updated_atstring (ISO 8601) πŸ”’ systemβ€”auto timestampβ€”Last update timestamp”2023-01-01T12:00:00Z”
deleted_atstring | null πŸ”’ systemβ€”nullable ISO 8601β€”Deletion timestamp (soft delete)β€œ2024-01-01T12:00:00Z”

Relations

Many-to-Many relations

  • People: Can be associated with multiple people
  • Companies: Can be associated with multiple companies
  • Workspaces: Can be associated with multiple workspaces

Relationship schema

WebLink (N) ←→ (N) People
WebLink (N) ←→ (N) Companies
WebLink (N) ←→ (N) Workspaces

# Direct relationship without intermediate tables
# Each web link can belong to multiple people/companies/workspaces
# Each person/company/workspace can have multiple web links
⌘I