Database JSON schemas
Find the core JSON schemas in src/schemas. These are the source of truth for data modeling in Casimir. When we deploy our Glue and Postgres databases, we use the schemas to generate Glue columns or Postgres tables from each JSON object's properties. See the reference table below for the database, table, file, and description of each schema.
| Database | Table | Schema | Description |
|---|---|---|---|
| Analytics (Glue) | events |
event.schema.json | All events |
| Analytics (Glue) | staking_actions |
staking_action.schema.json | Staking action event transforms |
| Analytics (Glue) | wallets |
wallets.schema.json | Wallet event transforms |
| Users (Postgres) | accounts |
account.schema.json | User accounts |
| Users (Postgres) | nonces |
nonce.schema.json | User auth nonces |
| Users (Postgres) | users |
user.schema.json | User profiles |
| Users (Postgres) | user_accounts |
user_account.schema.json | User account relations |