Project Document Management System

03/2025 ~ 05/2025

Full-Stack Development
Jinja2
Handed Off

[ Commissioned by Taoyuan City Government Transportation Bureau ] A document tagging and management system to improve overall operational efficiency through a web-based interface

Project Document Management System

Tech Stack

PostgreSQL

Lightweight database (managed with alembic)

Fastapi + Jinja2

Full-stack web service / web template service

Bootstrap

Frontend CSS framework

Docker Compose

Deployment tool

DB

The database uses a dual-table architecture with a one-to-many relationship between Project and Document.

The Project table stores basic project information, including project name, contact phone number, and application address;

The Document table records detailed document data such as document name, issuing agency, file path, review status, and upload time.

The two tables are linked via the project_id foreign key, enabling hierarchical management of projects and documents while keeping the data structure clear and easy to track.

File Processing Workflow