Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Users Posts Comment Likes

    Uploaded by

    Sarthak Sharma
    The document describes the schema tables and entity relationship diagram for a basic social media application. It includes tables for Users, Posts, Comments, Likes, and Friends with defining attributes like email, password, content, timestamps, and foreign keys. The ER diagram visually shows the one-to-many relationships between Users and Posts/Comments/Likes as well as the many-to-many relationship between Users via the Friends table.

    Copyright:

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

    Users Posts Comment Likes

    Uploaded by

    Sarthak Sharma
    5 views3 pages
    The document describes the schema tables and entity relationship diagram for a basic social media application. It includes tables for Users, Posts, Comments, Likes, and Friends with defining attributes like email, password, content, timestamps, and foreign keys. The ER diagram visually shows the one-to-many relationships between Users and Posts/Comments/Likes as well as the many-to-many relationship between Users via the Friends table.

    Original Description:

    rfddfdfgdgd

    Original Title

    hj

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the schema tables and entity relationship diagram for a basic social media application. It includes tables for Users, Posts, Comments, Likes, and Friends with defining attributes like email, password, content, timestamps, and foreign keys. The ER diagram visually shows the one-to-many relationships between Users and Posts/Comments/Likes as well as the many-to-many relationship between Users via the Friends table.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    5 views3 pages

    Users Posts Comment Likes

    Uploaded by

    Sarthak Sharma
    The document describes the schema tables and entity relationship diagram for a basic social media application. It includes tables for Users, Posts, Comments, Likes, and Friends with defining attributes like email, password, content, timestamps, and foreign keys. The ER diagram visually shows the one-to-many relationships between Users and Posts/Comments/Likes as well as the many-to-many relationship between Users via the Friends table.

    Copyright:

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

    Schema table

    USERS POSTS COMMENT LIKES


    Email Content Content User_id
    Encryped_password Post_id User_id Post_id
    Reset_password_token Created_at Post_id Created_at
    Sign_in_count Updated_at Created_at Updated_at
    Created_at Updated_at
    Updated_at
    Avatatr_file_name
    Avatar_content_type
    Avatar_file_name
    Avatar_updated_at
    ER DIAGRAM

    USERS

    USERS POSTS

    PK User_id PK User_id
    COMMENTS
    Name Content
    PK User_id
    Gender

    Email Content

    FK Post_id

    LIKES

    PK User_id

    FK Post_id
    FRIENDS

    PK User_id

    Friend_id

    You might also like