db/README.md

dutylog.app DB Schema

This repository will house any initialization scripts, constant data, design notes, and really anything else related to the database.

Design Notes

All activities will be stored in our own database for simplicity and so that data can be formatted in a usable setup. Activity names will not be stored in the DB and instead will live in a [type].[lang].json file in their game translated forms.

The current plan is to host this database on Cloudflare D1, which is based on SQLite.

Translations

Current translation file list:

• language.[lang].json
• servers.[lang].json
• expansions.[lang].json
• instance_types.[lang].json
• instances.[lang].json
• jobs.[lang].json

These files will be generated by the DB initialization script and will need to be moved to the www repo for build/deployment.

Schema

The schema was designed using Dia.