Pure.RelationalSchema.Self.Schema
0.1.0-preview.6.2.0
dotnet add package Pure.RelationalSchema.Self.Schema --version 0.1.0-preview.6.2.0
NuGet\Install-Package Pure.RelationalSchema.Self.Schema -Version 0.1.0-preview.6.2.0
<PackageReference Include="Pure.RelationalSchema.Self.Schema" Version="0.1.0-preview.6.2.0" />
<PackageVersion Include="Pure.RelationalSchema.Self.Schema" Version="0.1.0-preview.6.2.0" />
<PackageReference Include="Pure.RelationalSchema.Self.Schema" />
paket add Pure.RelationalSchema.Self.Schema --version 0.1.0-preview.6.2.0
#r "nuget: Pure.RelationalSchema.Self.Schema, 0.1.0-preview.6.2.0"
#:package Pure.RelationalSchema.Self.Schema@0.1.0-preview.6.2.0
#addin nuget:?package=Pure.RelationalSchema.Self.Schema&version=0.1.0-preview.6.2.0&prerelease
#tool nuget:?package=Pure.RelationalSchema.Self.Schema&version=0.1.0-preview.6.2.0&prerelease
Pure.RelationalSchema.Self.Schema
A concrete ISchema implementation that describes the relational schema metadata model itself — schemas, tables, columns, indexes, and foreign keys represented as a first-class database schema.
Overview
Pure.RelationalSchema.Self.Schema provides RelationalSchemaSchema — a sealed record that implements ISchema and models the database structure used to store relational schema metadata. The schema name is "schemas" and it contains 13 tables and 17 foreign keys representing the entities and relationships of a schema registry (schemas, tables, columns, column types, indexes, and foreign keys) along with all their join tables.
This package is the canonical self-description of the Pure relational schema storage model. It can be passed directly to a storage adapter (e.g. Pure.RelationalSchema.Storage.PostgreSQL.Creation) to create or migrate the metadata database.
Public API
RelationalSchemaSchema
namespace Pure.RelationalSchema.Self.Schema
public sealed record RelationalSchemaSchema : ISchema
| Member | Value |
|---|---|
Name |
"schemas" |
Tables |
13 tables (see below) |
ForeignKeys |
17 foreign keys (see below) |
Tables
| Class | SQL name | Columns |
|---|---|---|
ColumnTypesTable |
column_types |
uuid, name |
ColumnsTable |
columns |
uuid, name, reference_to_column_type |
IndexesTable |
indexes |
uuid, is_unique |
TablesTable |
tables |
uuid, name |
ForeignKeysTable |
foreign_keys |
uuid, referencing_table, referenced_table |
SchemasTable |
schemas |
uuid, name |
TablesToColumnsTable |
tables_to_columns |
reference_to_table, reference_to_column |
TablesToIndexesTable |
tables_to_indexes |
reference_to_table, reference_to_index |
IndexesToColumnsTable |
indexes_to_columns |
reference_to_index, reference_to_column |
ForeignKeysToReferencingColumnsTable |
foreign_keys_to_referencing_columns |
reference_to_foreign_key, reference_to_column |
ForeignKeysToReferencedColumnsTable |
foreign_keys_to_referenced_columns |
reference_to_foreign_key, reference_to_column |
SchemasToTablesTable |
schemas_to_tables |
reference_to_schema, reference_to_table |
SchemasToForeignKeysTable |
schemas_to_foreign_keys |
reference_to_schema, reference_to_foreign_key |
All entity tables (column_types, columns, indexes, tables, foreign_keys, schemas) carry a uuid unique index.
Foreign Keys
| Class | Referencing table → column | Referenced table → column |
|---|---|---|
ColumnsColumnTypesForeignKey |
columns.reference_to_column_type |
column_types.uuid |
TablesToColumnsTableForeignKey |
tables_to_columns.reference_to_table |
tables.uuid |
TablesToColumnsColumnForeignKey |
tables_to_columns.reference_to_column |
columns.uuid |
TablesToIndexesTableForeignKey |
tables_to_indexes.reference_to_table |
tables.uuid |
TablesToIndexesIndexesForeignKey |
tables_to_indexes.reference_to_index |
indexes.uuid |
IndexesToColumnsIndexForeignKey |
indexes_to_columns.reference_to_index |
indexes.uuid |
IndexesToColumnsColumnForeignKey |
indexes_to_columns.reference_to_column |
columns.uuid |
ForeignKeysReferencingTableForeignKey |
foreign_keys.referencing_table |
tables.uuid |
ForeignKeysReferencedTableForeignKey |
foreign_keys.referenced_table |
tables.uuid |
ForeignKeysToReferencingColumnsTableForeignKeyForeignKey |
foreign_keys_to_referencing_columns.reference_to_foreign_key |
foreign_keys.uuid |
ForeignKeysToReferencingColumnsTableColumnForeignKey |
foreign_keys_to_referencing_columns.reference_to_column |
columns.uuid |
ForeignKeysToReferencedColumnsTableForeignKeyForeignKey |
foreign_keys_to_referenced_columns.reference_to_foreign_key |
foreign_keys.uuid |
ForeignKeysToReferencedColumnsTableColumnForeignKey |
foreign_keys_to_referenced_columns.reference_to_column |
columns.uuid |
SchemasToTablesSchemaForeignKey |
schemas_to_tables.reference_to_schema |
schemas.uuid |
SchemasToTablesTableForeignKey |
schemas_to_tables.reference_to_table |
tables.uuid |
SchemasToForeignKeysSchemaForeignKey |
schemas_to_foreign_keys.reference_to_schema |
schemas.uuid |
SchemasToForeignKeysForeignKeyForeignKey |
schemas_to_foreign_keys.reference_to_foreign_key |
foreign_keys.uuid |
Dependencies
Pure.RelationalSchema— concrete column type implementations (StringColumnType,UuidColumnType, etc.) and base record types used by all table, column, index, and foreign key implementations
Target Frameworks
- .NET 7
- .NET 8
- .NET 9
- .NET 10
- .NET 11
Installation
dotnet add package Pure.RelationalSchema.Self.Schema
Usage
using Pure.RelationalSchema.Abstractions.Schema;
using Pure.RelationalSchema.Self.Schema;
using Pure.RelationalSchema.Storage.PostgreSQL.Creation;
ISchema schema = new RelationalSchemaSchema();
// schema.Name.TextValue == "schemas"
// schema.Tables.Count() == 13
// schema.ForeignKeys.Count() == 17
// Pass to a storage adapter to create/migrate the metadata database
PostgreSqlCreatedSchema created = new PostgreSqlCreatedSchema(schema, connection);
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. net11.0 is compatible. |
-
net10.0
- Pure.RelationalSchema (>= 2.2.0)
-
net11.0
- Pure.RelationalSchema (>= 2.2.0)
-
net7.0
- Pure.RelationalSchema (>= 2.2.0)
-
net8.0
- Pure.RelationalSchema (>= 2.2.0)
-
net9.0
- Pure.RelationalSchema (>= 2.2.0)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on Pure.RelationalSchema.Self.Schema:
| Package | Downloads |
|---|---|
|
Pure.RelationalSchema.Self.Storage.Projection
Package Description |
|
|
Pure.RelationalSchema.Self.Storage.Introjection
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 0.1.0-preview.6.2.0 | 106 | 11/11/2026 |
| 0.1.0-preview.6.1.0 | 491 | 10/22/2026 |
| 0.1.0-preview.6.0.2 | 770 | 8/4/2026 |
| 0.1.0-preview.6.0.1 | 1,007 | 5/28/2026 |
| 0.1.0-preview.6.0.0 | 1,050 | 3/14/2026 |
| 0.1.0-preview.5.1.0 | 525 | 12/8/2025 |
| 0.1.0-preview.5.0.0 | 723 | 11/12/2025 |
| 0.1.0-preview.4.0.0 | 608 | 11/3/2025 |
| 0.1.0-preview.3.3.1 | 212 | 11/3/2025 |
| 0.1.0-preview.3.3.0 | 234 | 10/29/2025 |
| 0.1.0-preview.3.2.0 | 208 | 10/28/2025 |
| 0.1.0-preview.3.1.0 | 212 | 10/28/2025 |
| 0.1.0-preview.3.0.0 | 130 | 10/25/2025 |
| 0.1.0-preview.2.0.0 | 279 | 10/7/2025 |
| 0.1.0-preview.1.0.0 | 192 | 10/6/2025 |
| 0.1.0-preview.0.1.0 | 168 | 10/3/2025 |