Pure.RelationalSchema.Self.Schema 0.1.0-preview.6.2.0

This is a prerelease version of Pure.RelationalSchema.Self.Schema.
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
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Pure.RelationalSchema.Self.Schema" Version="0.1.0-preview.6.2.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Pure.RelationalSchema.Self.Schema" Version="0.1.0-preview.6.2.0" />
                    
Directory.Packages.props
<PackageReference Include="Pure.RelationalSchema.Self.Schema" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
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"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Pure.RelationalSchema.Self.Schema@0.1.0-preview.6.2.0
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Pure.RelationalSchema.Self.Schema&version=0.1.0-preview.6.2.0&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=Pure.RelationalSchema.Self.Schema&version=0.1.0-preview.6.2.0&prerelease
                    
Install as a Cake Tool

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.

.NET build & test Build and Deploy NuGet License: MIT

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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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