Local repo
Data Model
The core data model centers on users, posts, relationships, groups, and notifications.
1 minread
9sections
9blocks
Data Modeldata-model.md
The data model supports a familiar social graph with strong identity and community context.
Core entities#
User#
- account id
- handle
- campus affiliation
- profile completeness
- privacy settings
Profile#
- display name
- bio
- avatar
- cover media
- interests
- location
Post#
- author id
- audience type
- body
- media attachments
- visibility state
- ranking features
Comment and reaction#
- post id
- author id
- parent comment id
- reaction type
- moderation status
Relationship#
- requester id
- recipient id
- relationship status
- follow state
- mutual connection count
Group and event#
- owner id
- visibility rules
- membership state
- event schedule
- RSVP counts
Notification#
- actor id
- recipient id
- event type
- delivery channel
- read state
Modeling notes#
- Posts, comments, and reports should support soft deletion plus moderation audit trails.
- Relationship status should capture pending, accepted, blocked, and limited visibility states.
- Notification payloads should be typed so in-app and email rendering can share the same event source.