Create a New Database

Start with the template schema which is defined by the schema YAML file located at schema/schema.yaml.

This file needs to be modified to suit your use case. e.g., add or rename tables, columns, etc.

1. Modify the schema YAML file to suit your use case.

   • We highly recommend using an AI coding assistant (like GitHub Copilot) when modifying this file.

2. Generate a new entity relationship diagram (ERD) and documentation pages for your schema.

   • To make a new ERD, run scripts/build_schema_docs.py. This generates a PNG file in the docs/figures/ directory.

   • To make new documentation pages, run scripts/build_schema_docs.py. This generates a new set of Markdown files in the docs/schema/ directory.