# UniCourse realm Schema

erDiagram
    User ||--o{ Following: FOLLOWED_BY
    User ||--o{ Badge: aaa
    User ||--o{ Collection: aaa
    User ||--o{ Activity: aaa
    User ||--o{ Review: aaa
    User ||--o{ Favorite: aaa
    Course }o--o{ Collection: aaa
    Course ||--o{ Activity: aaa
    Course ||--o{ Review: aaa
    Course ||--o{ Favorite: aaa

    FOLLOWED_BY {
        string a
    }
    User {
        string userId
        string handle
        string photo
        string handle
        string contact
        string bio
    }
    Following {
        string followUserId
    }
    Badge {
        string badgeId
        string badgeName
        string badgeInfo
    }
    Course {
        string courseId
    }
    Collection {
        string collectionId
        string name
        string description
    }
    Activity {
        string activityId
        string userId
        string courseId
        string action
    }
    Review {
        string reviewId
        string userId
        string courseId
        string content
         ratingQuality
        int ratingEasyAs
        int ratingFreedom
        int ratingWorkload
    }
    Favorite {
        string favoriteId
        string userId
        string courseId
    }

> 個人資料方面：
> - [ ] Photo
> - [ ] Handle
> - [ ] Contact
> - [ ] Bio
>
> 系統互動方面
> - [ ] Following users
> - [ ] Badge (成就系統)
>
> 課程互動方面
>
> - [ ] 已收藏的課程列表
> - [ ] Recent Activity (List, like, review, ...)
> - [ ] 評論的課程列表
> - [ ] 最喜歡的課程（可以選五個左右的課程放在個人首頁上）
>
> Metadata 展示
> - [ ] 總體數據包含 評論星等分佈、總收藏課程數量、總修習學分數量、總評論數量等等
>
> overall
> - [ ] 個資/首頁展示內容設定頁面