Entity Relationship Diagram for Social Media Full Stack Application

EntityRelationshipDiagram.md

erDiagram
  USER {
    integer id PK
    string username UK
    string fname
    string mname "optional"
    string lname
    string initials "initialized programmatically"
    string profile_color "initialized randomly"
    string password
  }
  POST {
    integer id PK
    datetime creation_date
    boolean edited "default false"
    string text_body
    integer writer_id FK
  }
  LIKE {
    integer id PK
    integer liking_user_id FK
    integer liked_post_id FK
  }
  USER ||--o{ POST : "creates, is created by"
  USER ||--o{ LIKE : "leaves, is left by"
  POST ||--o{ LIKE : "contains, is contained by"

Loading