database_schema.md

Database Schema

pg_timetable is a database driven application. During the first start the necessary schema is created if absent.

Main tables and objects

--8<-- "internal/pgengine/sql/ddl.sql"

Jobs related functions

--8<-- "internal/pgengine/sql/job_functions.sql"

Сron related functions

--8<-- "internal/pgengine/sql/cron.sql"

ER-Diagram

ER-Diagram showing the database structure