PAThs database schema documentation
This section of the PAThs documentation repository provides a complete documentation of PAThs database schema, currently implemented at db.bradypus.net.
If you are looking for the user & reader guide please follow this link.
The current database engine used by PAThs is Sqlite, «a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world» (https://www.sqlite.org). The DDL describing each table is standard SQL and will work—with minor changes—with other database engines, like MySQL, PostgreSQL, etc.
Table of contents
- The database managing system
- Table list
- Auxiliary tables
- System tables