erDiagram
    users ||--o{ sessions : "manages_authentication"
    users ||--o{ follows : "creates_follow_relationships"
    users ||--o{ posts : "creates_content"
    users ||--o{ comments : "writes_discussions"
    users ||--o{ likes : "gives_reactions"
    users ||--o{ bookmarks : "saves_content"
    users ||--o{ group_members : "participates_in_groups"
    users ||--o{ groups : "creates_communities"
    users ||--o{ event_responses : "rsvp_to_events"
    users ||--o{ events : "organizes_activities"
    users ||--o{ private_messages : "sends_private_messages"
    users ||--o{ group_messages : "sends_group_messages"
    users ||--o{ notifications : "receives_activity_alerts"
    users ||--o{ polls : "creates_interactive_content"
    users ||--o{ poll_votes : "participates_in_polls"
    users ||--o{ shares : "distributes_content"
    users ||--o{ invitations : "sends_group_invites"
    users ||--o| notification_settings : "configures_alerts"
    users ||--o{ private_conversations : "engages_in_private_chats"

    posts ||--o{ comments : "sparks_discussions"
    posts ||--o{ likes : "receives_reactions"
    posts ||--o{ post_privacy : "controls_visibility"
    posts ||--o{ bookmarks : "gets_saved"
    posts ||--o{ shares : "gets_distributed"

    groups ||--o{ group_members : "has_participants"
    groups ||--o{ group_posts : "contains_discussions"
    groups ||--o{ events : "hosts_activities"
    groups ||--o{ group_conversations : "facilitates_communication"
    groups ||--o{ polls : "runs_interactive_content"
    groups ||--o{ invitations : "manages_access"
    groups ||--o{ shares : "receives_shared_content"

    events ||--o{ event_responses : "tracks_participation"

    polls ||--o{ poll_options : "defines_choices"
    poll_options ||--o{ poll_votes : "collects_responses"

    private_conversations ||--o{ private_messages : "contains_chat_history"
    group_conversations ||--o{ group_messages : "contains_group_chat_history"

    private_conversations ||--o{ shares : "receives_shared_content"

    users {
        INTEGER id PK
        VARCHAR email UK
        VARCHAR password
        VARCHAR first_name
        VARCHAR last_name
        DATE date_of_birth
        TEXT avatar
        VARCHAR nickname
        TEXT about_me
        BOOLEAN is_private
        VARCHAR status
        DATETIME last_status_change
        DATETIME created_at
        DATETIME updated_at
        VARCHAR gender
        BOOLEAN is_deleted
        VARCHAR birthday_privacy
        VARCHAR gender_privacy
    }

    sessions {
        INTEGER id PK
        INTEGER user_id FK
        TEXT token UK
        DATETIME expires_at
        DATETIME created_at
        DATETIME updated_at
    }

    follows {
        INTEGER id PK
        INTEGER follower_id FK
        INTEGER following_id FK
        VARCHAR status
        DATETIME created_at
        DATETIME updated_at
    }

    posts {
        INTEGER id PK
        INTEGER user_id FK
        TEXT content
        TEXT image_url
        VARCHAR privacy
        INTEGER share_count
        DATETIME created_at
        DATETIME updated_at
    }

    post_privacy {
        INTEGER id PK
        INTEGER post_id FK
        INTEGER user_id FK
        DATETIME created_at
    }

    comments {
        INTEGER id PK
        INTEGER post_id FK
        INTEGER user_id FK
        TEXT content
        TEXT image_url
        DATETIME created_at
        DATETIME updated_at
    }

    likes {
        INTEGER id PK
        INTEGER user_id FK
        TEXT entity_type
        INTEGER entity_id
        TEXT reaction_type
        DATETIME created_at
    }

    groups {
        INTEGER id PK
        VARCHAR name
        TEXT description
        INTEGER creator_id FK
        VARCHAR privacy
        TEXT avatar
        VARCHAR content_creation
        VARCHAR create_posts
        VARCHAR create_polls
        VARCHAR create_events
        VARCHAR send_messages
        DATETIME created_at
        DATETIME updated_at
    }

    group_members {
        INTEGER id PK
        INTEGER group_id FK
        INTEGER user_id FK
        TEXT status
        TEXT role
        INTEGER invited_by FK
        INTEGER requestor_id FK
        DATETIME created_at
        DATETIME updated_at
    }

    group_posts {
        INTEGER id PK
        INTEGER group_id FK
        INTEGER user_id FK
        TEXT content
        TEXT image_url
        DATETIME created_at
        DATETIME updated_at
    }

    events {
        INTEGER id PK
        INTEGER group_id FK
        INTEGER creator_id FK
        VARCHAR title
        TEXT description
        DATETIME event_date
        TEXT location
        BOOLEAN canceled
        TEXT cancel_reason
        DATETIME created_at
        DATETIME updated_at
    }

    event_responses {
        INTEGER id PK
        INTEGER event_id FK
        INTEGER user_id FK
        VARCHAR response
        DATETIME created_at
        DATETIME updated_at
    }

    private_conversations {
        INTEGER id PK
        INTEGER participant1_id FK
        INTEGER participant2_id FK
        INTEGER last_message_id FK
        INTEGER unread_count1
        INTEGER unread_count2
        BOOLEAN participant1_deleted
        BOOLEAN participant2_deleted
        DATETIME participant1_deleted_at
        DATETIME participant2_deleted_at
        DATETIME created_at
        DATETIME updated_at
    }

    group_conversations {
        INTEGER id PK
        INTEGER group_id FK
        INTEGER last_message_id FK
        DATETIME created_at
        DATETIME updated_at
    }

    private_messages {
        INTEGER id PK
        INTEGER conversation_id FK
        INTEGER sender_id FK
        TEXT content
        BOOLEAN is_read
        BOOLEAN is_deleted
        DATETIME created_at
    }

    group_messages {
        INTEGER id PK
        INTEGER conversation_id FK
        INTEGER sender_id FK
        TEXT content
        BOOLEAN is_read
        BOOLEAN is_deleted
        DATETIME created_at
    }

    notifications {
        INTEGER id PK
        INTEGER user_id FK
        INTEGER actor_id FK
        VARCHAR type
        VARCHAR entity_type
        INTEGER entity_id
        VARCHAR title
        TEXT message
        BOOLEAN is_read
        VARCHAR redirect_url
        VARCHAR redirect_type
        DATETIME created_at
        DATETIME updated_at
    }

    bookmarks {
        INTEGER id PK
        INTEGER user_id FK
        INTEGER post_id FK
        DATETIME created_at
        DATETIME updated_at
    }

    invitations {
        INTEGER id PK
        INTEGER inviter_id FK
        INTEGER invitee_id FK
        INTEGER group_id FK
        TEXT status
        DATETIME created_at
    }

    polls {
        INTEGER id PK
        INTEGER user_id FK
        INTEGER group_id FK
        TEXT title
        TEXT description
        BOOLEAN allow_multiple_choices
        TIMESTAMP expires_at
        TIMESTAMP created_at
        TIMESTAMP updated_at
    }

    poll_options {
        INTEGER id PK
        INTEGER poll_id FK
        TEXT option_text
        INTEGER option_order
        TIMESTAMP created_at
    }

    poll_votes {
        INTEGER id PK
        INTEGER poll_id FK
        INTEGER option_id FK
        INTEGER user_id FK
        TIMESTAMP created_at
    }

    shares {
        INTEGER id PK
        INTEGER post_id FK
        INTEGER user_id FK
        INTEGER conversation_id FK
        INTEGER group_id FK
        INTEGER message_id FK
        DATETIME created_at
    }

    notification_settings {
        INTEGER id PK
        INTEGER user_id FK
        BOOLEAN sound_enabled
        VARCHAR sound_theme
        BOOLEAN browser_push_enabled
        BOOLEAN quiet_hours_enabled
        VARCHAR quiet_hours_start
        VARCHAR quiet_hours_end
        TEXT muted_conversations
        DATETIME created_at
        DATETIME updated_at
    }

flowchart TD
    A[User Visits GigaBit] --> B{Registered?}
    B -->|No| C[Sign Up Process]
    B -->|Yes| D[Login Process]

    C --> C1[Enter Details<br/>Email/Password/Name]
    C1 --> C2[Validate Input<br/>Check Email Uniqueness]
    C2 --> C3[Hash Password<br/>Create User Record]
    C3 --> C4[JWT Token Generated<br/>Session Created]
    C4 --> E[Main Dashboard]

    D --> D1[Enter Credentials<br/>Email/Password]
    D1 --> D2[Validate Credentials<br/>Check Password Hash]
    D2 --> D3{JWT Token Created<br/>Session Established}
    D3 --> E

    E --> F{Choose Action}

    F -->|View Feed| G[Browse Posts]
    F -->|Create Content| H[Post Creation]
    F -->|Connect| I[Social Features]
    F -->|Communicate| J[Messaging]
    F -->|Join Community| K[Groups]
    F -->|Organize| L[Events]

    G --> G1[Load Timeline<br/>From Followed Users]
    G1 --> G2[Display Posts<br/>With Reactions]
    G2 --> G3[Real-time Updates<br/>Via WebSocket]
    G3 --> G4[User Interactions<br/>Like/Comment/Share]

    H --> H1[Compose Post<br/>Text + Images]
    H1 --> H2[Set Privacy<br/>Public/Followers/Custom]
    H2 --> H3[Submit Post<br/>Save to Database]
    H3 --> H4[Broadcast to Feed<br/>Notify Followers]
    H4 --> H5[Real-time Display<br/>In User Timelines]

    I --> I1{Follow Users}
    I --> I2{Search People}
    I --> I3{Profile Management}

    I1 --> I1A[Click Follow<br/>On Profile]
    I1A --> I1B{Account Type?}
    I1B -->|Public| I1C[Immediate Follow<br/>Status: Accepted]
    I1B -->|Private| I1D[Send Request<br/>Status: Pending]
    I1D --> I1E[Wait for Approval<br/>Notification Sent]
    I1E --> I1F{Approved?}
    I1F -->|Yes| I1C
    I1F -->|No| I1G[Request Declined<br/>Optional Retry]

    I2 --> I2A[Search by Name<br/>Email/Nickname]
    I2A --> I2B[Display Results<br/>With Profiles]
    I2B --> I2C[View Profiles<br/>Send Messages/Follow]

    I3 --> I3A[Update Profile<br/>Avatar/Bio/Settings]
    I3A --> I3B[Privacy Controls<br/>Visibility Settings]
    I3B --> I3C[Save Changes<br/>Update Database]

    J --> J1{Message Type}
    J1 -->|Private| J2[Select User<br/>Start Conversation]
    J1 -->|Group| J3[Join Group Chat<br/>Send Group Message]

    J2 --> J2A[Open Chat<br/>Load Message History]
    J2A --> J2B[Type Message<br/>Send via WebSocket]
    J2B --> J2C[Real-time Delivery<br/>Read Receipts]
    J2C --> J2D[Typing Indicators<br/>Online Status]

    J3 --> J3A[Group Chat Interface<br/>Member List]
    J3A --> J3B[Send Messages<br/>@Mentions Support]
    J3B --> J3C[All Members Receive<br/>Instantly]

    K --> K1{Browse Groups}
    K1 -->|Public| K2[View Group<br/>Request to Join]
    K1 -->|Private| K3[Need Invitation<br/>Or Admin Approval]

    K2 --> K2A[Join Request<br/>Status: Requested]
    K2A --> K2B{Admin Approves?}
    K2B -->|Yes| K2C[Become Member<br/>Access Group Content]
    K2B -->|No| K2D[Request Denied<br/>Cannot Access]

    K3 --> K3A[Receive Invitation<br/>From Group Member]
    K3A --> K3B{Accept Invite?}
    K3B -->|Yes| K2C
    K3B -->|No| K3C[Decline Invitation]

    L --> L1[Create Event<br/>In Group]
    L1 --> L2[Set Details<br/>Date/Location/Description]
    L2 --> L3[Invite Members<br/>Send Notifications]
    L3 --> L4[Members RSVP<br/>Going/Not Going/Maybe]
    L4 --> L5[Track Attendance<br/>Send Reminders]
    L5 --> L6[Event Day<br/>Real-time Updates]

    F -->|Get Notified| M[Notification System]
    M --> M1[Receive Alerts<br/>For All Activities]
    M1 --> M2[Like/Comment/Follow<br/>Message/Event Updates]
    M2 --> M3[Real-time Delivery<br/>Via WebSocket]
    M3 --> M4[Customizable Settings<br/>Sound Themes/Muting]

    E --> N[Real-time Engine]
    N --> N1[WebSocket Connection<br/>Persistent Link]
    N1 --> N2[Live Updates<br/>Instant Synchronization]
    N2 --> N3[Typing Indicators<br/>Status Changes]
    N3 --> N4[Push Notifications<br/>Background Sync]

    style A fill:#e1f5fe
    style E fill:#f3e5f5
    style N fill:#e8f5e8