@foundrynorth/flux-schema
v1.11.0
Published
Canonical Drizzle ORM schema for Foundry Flux (broad-firefly database, flux_* tables)
Downloads
1,971
Readme
@foundrynorth/flux-schema
Canonical Drizzle ORM schema for the Foundry Flux database (broad-firefly-00588697). All tables use the flux_* prefix.
Install
npm install @foundrynorth/flux-schemaUsage
import { fluxProjects, fluxFulfillmentTickets, fluxActivityItems } from "@foundrynorth/flux-schema";Consumers
- fn-flux (Compass Ops) — migration authority
- fn-v2 (Trigger.dev tasks) — read + write
Shared Database Warning
The broad-firefly database is shared between fn-flux (flux_* tables) and fn-forge (unprefixed tables). Only fn-flux has drizzle-kit push authority. fn-forge uses a tablesFilter: ["!flux_*"] to avoid touching Flux tables.
Schema Change Workflow
- Edit schema in this repo
npm run build && npm version patch && npm publish- Update fn-flux:
npm install @foundrynorth/flux-schema@latest - Run
drizzle-kit pushfrom fn-flux only - Update fn-v2 to the new version
