Scribd Logo
Upload

Welcome to Scribd!

  • 190 views

    Chat App ERD

    Uploaded by

    Ndebueze Damian
    This document outlines the database tables and relationships for group chats, user chats, contacts, and user settings in a messaging application. The group chats table tracks group information and messages. The user chats table stores individual user messages and recipients. The contacts table saves user contacts. And the settings table holds a user's notification, language, and backup preferences.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Chat App ERD

    Uploaded by

    Ndebueze Damian
    190 views1 page
    This document outlines the database tables and relationships for group chats, user chats, contacts, and user settings in a messaging application. The group chats table tracks group information and messages. The user chats table stores individual user messages and recipients. The contacts table saves user contacts. And the settings table holds a user's notification, language, and backup preferences.

    Original Title

    Chat app ERD

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the database tables and relationships for group chats, user chats, contacts, and user settings in a messaging application. The group chats table tracks group information and messages. The user chats table stores individual user messages and recipients. The contacts table saves user contacts. And the settings table holds a user's notification, language, and backup preferences.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    190 views1 page

    Chat App ERD

    Uploaded by

    Ndebueze Damian
    This document outlines the database tables and relationships for group chats, user chats, contacts, and user settings in a messaging application. The group chats table tracks group information and messages. The user chats table stores individual user messages and recipients. The contacts table saves user contacts. And the settings table holds a user's notification, language, and backup preferences.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    Group Chats

    PK chat_id int
    Group
    FK1 group id int
    PK group_id int
    time_stamp date_time
    FK users_id int()
    user_id int
    FK group_chat id int
    creation_date dataTime
    FK group_admin(s) _id int()

    User Chats

    PK chat_id int

    FK1 user id int


    User
    time_stamp date_time
    PK user_id int
    reciever_id int
    FK groups_id int

    creation_date date

    username varChar()
    first_name varChar()

    last_name varChar() Contacts


    date_of_birth date()
    PK contact_id int
    FK contact_id int()
    online_status_boolean FK1 username varChar()
    FK settings_id int()
    date_added date_time

    FK user_id int

    Settings

    PK settings_id int

    FK1 user_id int

    notifications_settings boolean()
    language_settings varChar()

    backup_settings boolean()

    You might also like