# cwt85/se_personal_midtern_project architecture

> Architecture diagram of the GitHub repository cwt85/se_personal_midtern_project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/cwt85/se_personal_midtern_project
- Repository: https://github.com/cwt85/se_personal_midtern_project

## Overview

這是以 FastAPI 與 PostgreSQL 建置的雙角色投稿審查 Demo。作者登入後可建立、編輯、刪除草稿並送審；編輯查看待審稿件、通過或退回並留下意見，作者可修改後重新送審。主要路由集中在 main.py，並透過簽章 Cookie 驗證角色、讀寫投稿資料。README 說明資料庫初始化與審查歷程；未抽樣的路由實作及模板間連結不作推測。

Main entry points: [`db.py`](https://github.com/cwt85/se_personal_midtern_project/blob/master/db.py) (連線與初始化), [`main.py`](https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py) (稿件管理), [`auth.py`](https://github.com/cwt85/se_personal_midtern_project/blob/master/auth.py) (簽章 Cookie), [`templates/author_submissions.html`](https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/author_submissions.html) (作者稿件清單)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_access["登入與身分"]
  node_login["登入與工作區<br/>[main.py]"]
  node_session_auth["簽章 Cookie<br/>[auth.py]"]
end

subgraph group_author["作者投稿"]
  node_author_submissions["稿件管理<br/>[main.py]"]
  node_submission_list["作者稿件清單"]
  node_submission_form["稿件表單"]
end

subgraph group_editor["編輯審查"]
  node_editor_queue["待審與已處理清單<br/>[main.py]"]
  node_review_detail["審查與歷程<br/>[main.py]"]
  node_editor_reviews_view["審查清單畫面"]
  node_editor_detail_view["審查詳情畫面<br/>[editor_detail.html]"]
end

subgraph group_persistence["資料持久化"]
  node_database_access["連線與初始化<br/>[db.py]"]
  node_schema[("投稿資料表<br/>[project.sql]")]
end

node_author_actor(("作者"))
node_editor_actor(("編輯"))
node_postgres[("PostgreSQL")]

node_author_actor -->|"登入"| node_login
node_editor_actor -->|"登入"| node_login
node_login -->|"驗證 Cookie"| node_session_auth
node_author_actor -->|"管理稿件"| node_author_submissions
node_author_submissions -.->|"呈現清單"| node_submission_list
node_author_submissions -->|"呈現表單"| node_submission_form
node_editor_actor -->|"查看待審"| node_editor_queue
node_editor_queue -.->|"呈現清單"| node_editor_reviews_view
node_editor_actor -->|"審查稿件"| node_review_detail
node_review_detail -.->|"呈現詳情"| node_editor_detail_view
node_login -.->|"查詢帳號"| node_database_access
node_author_submissions -->|"讀寫稿件"| node_database_access
node_editor_queue -->|"查詢稿件"| node_database_access
node_review_detail -->|"更新審查"| node_database_access
node_database_access -->|"雜湊 Demo 密碼"| node_session_auth
node_database_access -->|"執行初始化 SQL"| node_schema
node_database_access -->|"連線與執行 SQL"| node_postgres

click node_login "https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py"
click node_session_auth "https://github.com/cwt85/se_personal_midtern_project/blob/master/auth.py"
click node_author_submissions "https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py"
click node_submission_list "https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/author_submissions.html"
click node_submission_form "https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/submission_form.html"
click node_editor_queue "https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py"
click node_review_detail "https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py"
click node_editor_reviews_view "https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/editor_reviews.html"
click node_editor_detail_view "https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/editor_detail.html"
click node_database_access "https://github.com/cwt85/se_personal_midtern_project/blob/master/db.py"
click node_schema "https://github.com/cwt85/se_personal_midtern_project/blob/master/project.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_login,node_session_auth toneBlue
class node_author_submissions,node_submission_list,node_submission_form,node_postgres toneAmber
class node_editor_queue,node_review_detail,node_editor_reviews_view,node_editor_detail_view toneMint
class node_database_access,node_schema toneRose
class node_author_actor,node_editor_actor toneIndigo
```

## Components

### 登入與身分

- [登入與工作區](https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py): `main.py`
- [簽章 Cookie](https://github.com/cwt85/se_personal_midtern_project/blob/master/auth.py): `auth.py`

### 作者投稿

- [稿件管理](https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py): `main.py`
- [作者稿件清單](https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/author_submissions.html): `templates/author_submissions.html`
- [稿件表單](https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/submission_form.html): `templates/submission_form.html`

### 編輯審查

- [待審與已處理清單](https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py): `main.py`
- [審查與歷程](https://github.com/cwt85/se_personal_midtern_project/blob/master/main.py): `main.py`
- [審查清單畫面](https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/editor_reviews.html): `templates/editor_reviews.html`
- [審查詳情畫面](https://github.com/cwt85/se_personal_midtern_project/blob/master/templates/editor_detail.html): `templates/editor_detail.html`

### 資料持久化

- [連線與初始化](https://github.com/cwt85/se_personal_midtern_project/blob/master/db.py): `db.py`
- [投稿資料表](https://github.com/cwt85/se_personal_midtern_project/blob/master/project.sql): `project.sql`

### Other components

- **作者**
- **編輯**
- **PostgreSQL**

## Connections

- 作者 → 登入與工作區: 登入 (evidence: `README.md`)
- 編輯 → 登入與工作區: 登入 (evidence: `README.md`)
- 登入與工作區 → 簽章 Cookie: 驗證 Cookie (evidence: `main.py`)
- 作者 → 稿件管理: 管理稿件 (evidence: `README.md`)
- 稿件管理 → 作者稿件清單: 呈現清單
- 稿件管理 → 稿件表單: 呈現表單 (evidence: `main.py`)
- 編輯 → 待審與已處理清單: 查看待審 (evidence: `README.md`)
- 待審與已處理清單 → 審查清單畫面: 呈現清單
- 編輯 → 審查與歷程: 審查稿件 (evidence: `README.md`)
- 審查與歷程 → 審查詳情畫面: 呈現詳情
- 登入與工作區 → 連線與初始化: 查詢帳號 (evidence: `main.py`)
- 稿件管理 → 連線與初始化: 讀寫稿件 (evidence: `main.py`)
- 待審與已處理清單 → 連線與初始化: 查詢稿件 (evidence: `main.py`)
- 審查與歷程 → 連線與初始化: 更新審查 (evidence: `main.py`)
- 連線與初始化 → 簽章 Cookie: 雜湊 Demo 密碼 (evidence: `db.py`)
- 連線與初始化 → 投稿資料表: 執行初始化 SQL (evidence: `README.md`)
- 連線與初始化 → PostgreSQL: 連線與執行 SQL (evidence: `db.py`)
