## 考古題 Hub 資料庫第一組:于子緯、紀軒宇、連庭萱、高子翔 --- ## 系統介紹 [連結](http://examhub.uier.tw:3000) --- ## 發展工具 ---- ## 開發語言 <!-- ![nodejs](https://i.imgur.com/kIuZEeB.png =x50) ![mysql](https://i.imgur.com/BUjkLI5.png =x50) ![vuejs](https://i.imgur.com/GTrKqtt.png =x50) --> ![](https://i.imgur.com/ml9hmRB.png =x100) ---- ## MVC Pattern ``` examhub/ ├── client/ │ ├── views/ │ └── api.ts └── server/ ├── routes/ └── models/ ``` [swagger API](http://examhub.uier.tw:3000/api/docs/) ---- ## Front-end (View) ``` examhub/ ├── client/ │ ├── views/ │ | ├── Home.vue │ | ├── Browse.vue │ | ├── Manage.vue │ | └── User.vue │ └── api.ts └── server/ ├── routes/ └── models/ ``` ---- ## Back-end (Controller) ``` examhub/ ├── client/ │ ├── views/ │ └── api.ts └── server/ ├── routes/ | ├── auth.ts | ├── announcement.ts | ├── comment.ts | ├── course.ts | ├── exam.ts | ├── ranking.ts | └── user.ts └── models/ ``` ---- ## Back-end (Model) ``` examhub/ ├── client/ │ ├── views/ │ └── api.ts └── server/ ├── routes/ └── models/ ├── announcement.ts ├── comment-area.ts ├── comment.ts ├── course.ts ├── exam.ts ├── ranking.ts ├── user.ts └── vote.ts ``` --- ## SQL 展示 ---- ## auth / user 于子緯 ---- ## course / ranking / announcement 紀軒宇 ---- ## exam / comment area ## / comment / vote 高子翔、連庭萱 --- ## 特色功能展示 ---- ## Trigger 連庭萱、高子翔 ---- ## 利用 Trigger 實作貢獻值 ![](https://i.imgur.com/hugEsuw.png) ---- ## Google OAuth 套用 Google OAuth 功能 無需另外註冊帳號,使用方便 --- ## END 謝謝聆聽 <!-- END -->
{"metaMigratedAt":"2023-06-16T03:06:50.923Z","metaMigratedFrom":"YAML","title":"Demo 報告","breaks":true,"slideOptions":"{\"transition\":\"fade\"}","contributors":"[{\"id\":\"6a855942-fc41-4e15-8dc1-65083b494df4\",\"add\":1957,\"del\":15},{\"id\":\"825db5c4-8eb9-4944-8772-d130a3d519a1\",\"add\":240,\"del\":83},{\"id\":\"343b33b3-34ea-4048-8e2f-129ef7e61e88\",\"add\":114,\"del\":32},{\"id\":\"749ab3c8-ecf2-49e4-bf0a-35326d4aa4e7\",\"add\":131,\"del\":30}]"}
    356 views
   owned this note