f3-data-models 1.0.5

The data schema and models for F3 Nation applications.

Overview

This repository defines the F3 data structure, used by the F3 Slack Bot, Maps, etc. The projected uses SQLAlchemy to define the tables / models.

Running Locally

To load the data structure in your database:

1. Set up a local db, update .env.example and save as .env
2. Clone the repo, use Poetry to install dependencies:

poetry env use 3.12
poetry install

3. Run the alembic migration:

source .env && poetry run alembic upgrade head

Contributing

If you would like to make a change, you will need to:

1. Make the change in models.py
2. Make a alembic revision:

source .env && alembic revision --autogenerate -m "Your Message Here"

3. Make any edits to the migration script in alembic/versions
4. Run the upgrade on your local db:

source .env && alembic upgrade head

5. Bump the version on pyproject.toml:

poetry version patch[minor][major]

6. Tag your final commit and make sure to push those tags to trigger the pypi package build:

git tag <new_version> -a -m "Your message here"
git push origin --tags

[!NOTE] The github pages documentation will be updated when you push to main, but if you would like to preview locally, run:

poetry run sphinx-build -b html docs docs/_build/html
cd docs
poetry run python -m http.server --directory _build/html

[!TIP]
Adding new fields as nullable (ie Optional[]) has the best chance of reducing breaking changes to the apps.

Entity Overview

---
config:
    look: handDrawn
    theme: dark
---

erDiagram
    USERS ||--|{ ATTENDANCE : have
    ATTENDANCE }|--|| EVENT_INSTANCES: at
    ATTENDANCE }|..|{ ATTENDANCE_TYPES : "are of type(s)"
    EVENT_INSTANCES }|..|| EVENTS : "part of series"
    EVENT_INSTANCES }|..|{ EVENT_TYPES : "with type(s)"
    EVENTS }|..|{ EVENT_TYPES : "with type(s)"
    EVENT_INSTANCES }|--|| ORGS : "belong to"
    EVENT_INSTANCES }|..|| LOCATIONS : "at"
    EVENTS }|--|| ORGS : "belong to"
    EVENTS }|..|| LOCATIONS : "at"
    SLACK_SPACES ||..|| ORGS : "are connected to"
    USERS ||..|{ SLACK_USERS : "have one or more"
    SLACK_USERS }|--|| SLACK_SPACES : "belong to"
    USERS }|..|{ ACHIEVEMENTS : "earn"
    USERS }|..|{ ROLES : "have"
    ROLES ||..|{ PERMISSIONS : "have"
    ROLES }|..|{ ORGS : "in"
    USERS }|..|{ POSITIONS : "hold"
    POSITIONS }|..|{ ORGS : "in"