|
|
| Line 1: |
Line 1: |
| == Developers/Database ==
| |
|
| |
|
| Quick reference of current tables and their primary purpose.
| |
|
| |
|
| === Auth and User Core === | | === user_invitations.invited_user_id === |
| * users: core account identity and status. | | * Purpose: bind invitation record to the concrete invited account after signup creates the user. |
| * user_profiles: personal profile fields and preferences. | | * Starts as NULL when invitation is created and is filled when signup enters pending confirmation. |
| * roles: RBAC role catalog.
| | * Used in confirmation flow to match the exact invited user and safely create/attach pending connection. |
| * 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
| |
user_invitations.invited_user_id
- Purpose: bind invitation record to the concrete invited account after signup creates the user.
- Starts as NULL when invitation is created and is filled when signup enters pending confirmation.
- Used in confirmation flow to match the exact invited user and safely create/attach pending connection.
