Developers/Database

Developers/Database

Quick reference of current tables and their primary purpose.

Auth and User Core

• users: core account identity and status.
• user_profiles: personal profile fields and preferences.
• roles: RBAC role catalog.
• user_roles: user-to-role assignments.
• refresh_tokens: login session refresh tokens.
• email_tokens: signup confirmation and password reset tokens.
• backend_error_logs: backend runtime error persistence.

Content and Timeline

• timelines: timeline catalog (professional, personal, events, sports).
• entity_types: entity taxonomy.
• event_types: event taxonomy.
• memories: main post/event records.
• memory_media: media attached to memories.
• memory_comments: comments on memories.
• memory_reactions: reactions on memories.
• memory_tagged_users: users tagged in memory records and participation status.

Social Graph and Invitations

• kinship_types: kinship catalog.
• friendship_levels: friendship level catalog.
• user_connections: social connection records between users.
• user_invitations: invitation lifecycle and token hash context.

Admin, Widgets and Navigation

• widget_catalog: widget master catalog.
• widget_variants: supported variants per widget.
• widget_role_visibility: role-level widget visibility.
• widget_layout_rules: widget placement/order rules.
• widget_config_audit: audit trail for widget governance changes.
• sidebar_button_catalog: sidebar buttons catalog.
• sidebar_button_role_visibility: button visibility by role.
• components_catalog: unified catalog for buttons/widgets.
• component_widget_children: links parent component to widget children.
• component_button_children: links parent component to button children.

Operations and Support

• audit_logs: security and operational audit events.
• outbox_events: event outbox for async processing.
• contact_us_tickets: contact-us submissions and notification status.
• user_resetable_tables: allowlist used by DEV user-data reset utility.

Maintenance Rule

• Keep this page updated whenever a table is added, removed, renamed, or repurposed.

Last update: 2026-06-15 14:32:05 UTC