Schema reference

What PostgreSQL built, read back from its catalog. The build creates an empty database, bootstraps it through the same functions a deployment's bootstrap calls, provisions one project called example so that per-project partitions exist, reads the catalog, and drops the database. Nothing here is parsed from SQL text, so what it shows is the end state after every migration, including the ones that altered earlier ones.

Generated from PostgreSQL 18.6 with btree_gist 1.8, pg_stat_statements 1.12, plpgsql 1.0, vector 0.8.6.

• Control namespace: 2 tables. The credential registry: projects' credentials and operator credentials. The memory role holds no privilege here; the registry role reads it.
• Memory namespace: 61 tables. Every project's memory. memory is the default name; an instance may choose another with TAISCE_SCHEMA. Projects are rows and partitions inside it, not namespaces of their own.
• Roles and privileges: the database identities, what each may reach, and the grant matrix.

For why the schema has the shape it has, read the PostgreSQL pages under Architecture; for the order it was built in, read the migration catalogue.