Backend for YT like app

• Model link

ER Diagram

erDiagram
    users {
        string id PK
        string username
        string email
        string fullname
        string avatar
        string coverImage
        string password
        string refreshToken
        Date createdAt
        Date updatedAt
        ObjectId[] watchHistory
    }

    videos {
        string id PK
        string videoFile
        string thumbnail
        string title
        string description
        number duration
        number views
        boolean isPublished
        Date createdAt
        Date updatedAt
        ObjectId owner FK
    }

    playlists {
        string id PK
        string name
        string description
        Date createdAt
        Date updatedAt
        ObjectId[] videos FK
        ObjectId owner FK
    }

    tweets {
        string id PK
        string content
        Date createdAt
        Date updatedAt
        ObjectId owner FK
    }

    likes {
        string id PK
        Date createdAt
        Date updatedAt
        ObjectId comment FK
        ObjectId video FK
        ObjectId tweet FK
        ObjectId likedBy FK
    }

    comments {
        string id PK
        string content
        Date createdAt
        Date updatedAt
        ObjectId video FK
        ObjectId owner FK
    }

    subscriptions {
        string id PK
        Date createdAt
        Date updatedAt
        ObjectId subscriber FK
        ObjectId channel FK
    }

    users ||--o{ videos : "owns"
    users ||--o{ playlists : "owns"
    users ||--o{ tweets : "owns"
    users ||--o{ comments : "authors"
    users ||--o{ likes : "gives"
    users ||--o{ subscriptions : "subscribes to"
    users ||--o{ subscriptions : "is channel for"

    videos ||--o{ comments : "has"
    videos ||--o{ likes : "has"
    videos }o--o{ playlists : "is part of"

    tweets ||--o{ likes : "has"

    comments ||--o{ likes : "has"

Loading