---
# System prepended metadata

title: 後端工作清單

---

#  後端工作清單
- 負責人：張智聖、黃翊誠
- 候補工作人員：周芳妤
## 連結
- [程式組會議0415](/dErnqIKZRfac40uFzzjojw)
- [Laravel專案使用說明書](/W6HQDT4CRoONYaOJs1RjDQ)
- [架構](/@Futureway/Structure)
- [懶人包](/BgyPJ2fPT2uxqxLZsapIxQ)
- [神秘講義](https://reurl.cc/q58ynN)
- [講解連結](https://www.bilibili.com/video/BV1gE411j78F?spm_id_from=333.337.search-card.all.click)
- [github指令集](https://ithelp.ithome.com.tw/articles/10241407)
- [如果想要系辦電腦請參考](https://stackoverflow.com/questions/26208848/xampp-installation-on-win-8-1-with-uac-warning)
## 架構設計
* PHP版本：
* Laravel版本：
### 介紹
* id -> PK, A.I,bigIncrements
* level -> unsignedTinyInteger(0~255)
    - Integer(-128~128)
* (前置詞)name -> VARCHAR(255) NOT NULL
* content -> TEXT NULL
* creator -> Foriegn_Key(FK)
* Create timesteamp -> DEFAULT CURRENNT-TIME
* Update-TS-> 

### 架構
1. course:id,course name,info,CTS, UTS,
2. unit: id, unit name, creator, corse id -> FK, CTS, UTS
3. part: id, name, info, creator, unit id -> FK, content, video_id, video_platform, CTS, UTS
4. note: id, content, user id -> FK, part id -> FK, CTS, UTS

### 新版架構(整理中)
1. course：id,level,order,course name,parent id -> FK,video id,part content,visible,CTS, UTS
2. permission：id,course id -> FK,permission type,permission `f?` id -> FK
3. note：id,note content,user id -> FK,course id -> FK

---
### 課程/單元

| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值   |
| -------- | -------- | -------- | ---- | -------- |
| 課程ID   | coid     | integer  |      | PK, A_I  |
| 階層     | level    | integer  |      | 0         |
| 順序     | order    | integer  |      |          |
| 課程名稱  | coname   | string   | 255  |          |
| 上層ID   | pid      | integer  |      | NULL、FK |
| 文本內容  | content  | text     |      | NULL     |
| 課程介紹  | cointro  | text     |      | NULL     |
| 可見性   | visible  | string   | 255  | 1        |

* 子單元 影片時間
### 單元

| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值   |
| -------- | -------- | -------- | ---- | -------- |
| 單元ID   | unid     | integer  |      | PK, A_I  |
| 階層     | level    | integer  |      | 0        |
| 順序     | order    | integer  |      |          |
| 單元名稱  | unname   | string   | 255  |          |
| 上層ID   | pid      | integer  |      | NULL、FK |
| 影片ID   | vid      | string   | 255  | NULL     |
| 文本內容  | uncontent| text     |      | NULL     |
| 單元介紹  | unintro  | text     |      | NULL     |
| 可見性   | visible  | string   | 255  | 1        |

### 權限

| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | ------ |
| 權限ID    | prid   | integer    |      | PK, A_I      |
| 課程ID    | coid   | integer    |      | FK           |
| 權限類型   | prtype | string     | 1    | s:學生 c:班級 |
| 開放ID    | prfid  | string     | 255  | FK           |

* 開放ID：被開放權限的那個人或班級的

### 筆記

| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | ------ |
| 筆記ID    | noid     | integer  |      | PK     |
| 筆記內容   | nocontent| text     |      | NULL   |
| 使用者ID   | userid   | string   | 255  | FK     |
| 課程ID    | coid     | integer  |      | FK     |


### reply
---


## 功能筆記

## 練習
```
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <!-- CSS only -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-0evHe/X+R7YkIZDRvuzKMRqM+OrBnVFBL6DOitfPri4tjfHxaWutUpFmBp4vmVor" crossorigin="anonymous">
</head>

<body>
    <section>
        <div class="container">
            <div class="row">
                <nav class="navbar navbar-expand-lg bg-light d-flex ">
                    <div class="col-lg-4">
    
                    </div>
                    <div class="col-lg-8">
                        <div class="container-fluid justify-content-end">
                            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup"
                                aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
                                <span class="navbar-toggler-icon"></span>
                            </button>
                            <div class="collapse navbar-collapse justify-content-center" id="navbarNavAltMarkup">
                                <div class="navbar-nav fs-4 fw-bold">
                                    <a class="nav-link active" aria-current="page" href="#">首頁</a>
                                    <a class="nav-link" href="#">計畫全貌</a>
                                    <a class="nav-link" href="#">最新消息</a>
                                    <a class="nav-link" href="#">歷年成果</a>
                                    <a class="nav-link" href="#">關於我們</a>
                                    <a class="nav-link" href="#">常見問題</a>
                                    <a class="nav-link" href="#">相關連結</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </nav>
            </div>
        </div>
    </section>
</body>
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/js/bootstrap.bundle.min.js"
    integrity="sha384-pprn3073KE6tl6bjs2QrFaJGz5/SUsLqktiwsUTF55Jfv3qYSDhgCecCxMW52nD2"
    crossorigin="anonymous"></script>

</html>
```
[假圖](https://picsum.photos/)


```
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <!-- CSS only -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-0evHe/X+R7YkIZDRvuzKMRqM+OrBnVFBL6DOitfPri4tjfHxaWutUpFmBp4vmVor" crossorigin="anonymous">
</head>

<body>
    <!-- header section -->
    <section>
        <div class="container">
            <div class="row">
                <nav class="navbar navbar-expand-lg bg-light d-flex ">
                    <div class="col-lg-4">
    
                    </div>
                    <div class="col-lg-8">
                        <div class="container-fluid justify-content-end">
                            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup"
                                aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
                                <span class="navbar-toggler-icon"></span>
                            </button>
                            <div class="collapse navbar-collapse justify-content-center" id="navbarNavAltMarkup">
                                <div class="navbar-nav fs-4 fw-bold">
                                    <a class="nav-link active" aria-current="page" href="#">首頁</a>
                                    <a class="nav-link" href="#">計畫全貌</a>
                                    <a class="nav-link" href="#">最新消息</a>
                                    <a class="nav-link" href="#">歷年成果</a>
                                    <a class="nav-link" href="#">關於我們</a>
                                    <a class="nav-link" href="#">常見問題</a>
                                    <a class="nav-link" href="#">相關連結</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </nav>
            </div>
        </div>
    </section>

    <!-- content section -->
    <section>
        <div class="container">
            <div class="row">
                <div id="carouselExampleIndicators col-12" class="carousel slide" data-bs-ride="carousel">
                    <div class="carousel-indicators">
                        <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="0" class="active"
                            aria-current="true" aria-label="Slide 1"></button>
                        <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="1"
                            aria-label="Slide 2"></button>
                        <button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="2"
                            aria-label="Slide 3"></button>
                    </div>
                    <div class="carousel-inner">
                        <div class="carousel-item active">
                            <img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
                        </div>
                        <div class="carousel-item">
                            <img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
                        </div>
                        <div class="carousel-item">
                            <img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
                        </div>
                    </div>
                    <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleIndicators"
                        data-bs-slide="prev">
                        <span class="carousel-control-prev-icon" aria-hidden="true"></span>
                        <span class="visually-hidden">Previous</span>
                    </button>
                    <button class="carousel-control-next" type="button" data-bs-target="#carouselExampleIndicators"
                        data-bs-slide="next">
                        <span class="carousel-control-next-icon" aria-hidden="true"></span>
                        <span class="visually-hidden">Next</span>
                    </button>
                </div>
                <div class="pt-5 d-flex">
                    <div class="row">
                        <div class="col-md col-6">
                            <ul>
                                <li></li>
                                <ol></ol>
                                <ol></ol>
                                <ol></ol>
                            </ul>
                        </div>
                        <div class="col-md col-6">
                            <ul>
                                <li></li>
                                <ol></ol>
                                <ol></ol>
                                <ol></ol>
                            </ul>
                        </div>
                        <div class="col-md col-6">
                            <ul>
                                <li></li>
                                <ol></ol>
                                <ol></ol>
                                <ol></ol>
                            </ul>
                        </div>
                        <div class="col-md col-6">
                            <ul>
                                <li></li>
                                <ol></ol>
                                <ol></ol>
                                <ol></ol>
                            </ul>
                        </div>
                    </div>
                </div>

            
        </div>


    </section>
</body>
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/js/bootstrap.bundle.min.js"
    integrity="sha384-pprn3073KE6tl6bjs2QrFaJGz5/SUsLqktiwsUTF55Jfv3qYSDhgCecCxMW52nD2"
    crossorigin="anonymous"></script>

</html>
```



【10/04(二)-創新課程成果展活動行前通知】

活動時間:上午8:00-10:00
活動地點:五權國小3F視聽教室
集合時間:上午7:15(最晚7:30)
—————————
活動注意事項:
1. 請夥伴們穿著「藍色」團服
2. 因應疫情請各位自行攜帶口罩，如出隊當天有發燒症狀，請於早上7點前於群組回報!
3.具體的分工會在當天進行指派
—————————
須攜帶物品:
1.口罩
2.個人藥物

備註:
1.如有幫忙購買老師指定用品時，請報統編【76000424】
—————————
請各位夥伴看完出隊公告後回覆收到，如果有無法出席教學活動的夥伴請事前告知，謝謝