Codegen Add SQL Schema

When you need to add SQL tables, triggers, indexes, or reference data to the ORE Studio database for a new entity. This is the second layer in the entity lifecycle — the domain type must already exist (see domain-type-creator). For the full layer ordering see Entity lifecycle.

Codegen is mandatory. Hand-crafting SQL is only permitted when the entity pattern cannot be expressed in any existing template; in that case, extend the template first, then generate.

1. Create a JSON model in projects/ores.codegen/models/{component}/. Use *_domain_entity.json for UUID-PK tables, *_junction.json for composite-text-PK association tables.
2. Generate the SQL schema (output goes to projects/ores.sql/): cd projects/ores.codegen && ./run_generator.sh models/{component}/{entity}_domain_entity.json --profile sql
3. Register the generated file in the component orchestration script.
4. Validate: ./projects/ores.sql/utility/validate_schemas.sh
5. Raise PR with title [sql] Add {entity} schema. Use feature-branch-manager to transition between phases and pr-manager to open each PR.

• How do I create a new entity SQL schema? — step-by-step walkthrough.

• SQL entity schema patterns — naming conventions, suffix catalogue, idempotency patterns.
• ORE Studio Codegen — model schema and --profile sql details.
• ORE Studio SQL Schema — full schema mental model and PostgreSQL setup.
• Entity lifecycle — layer ordering overview.

Runs via --profile sql. Read the template directly for the authoritative implementation — do not reproduce it here.