Schema: robos:DatabaseColumn

Formal W3C SHACL constraint shape and OSLC JSON-LD specification for robos:DatabaseColumn in the core-platform package store.

Table of contents

  1. Specification Metadata
  2. Upstream Schema Basis (Refers From) & Global Standards Provenance
  3. Entity Relationship & Schema Context
  4. Property Constraints & SHACL Rules
  5. Canonical OSLC JSON-LD Example
  6. Programmatic SHACL Validation

Specification Metadata


Upstream Schema Basis (Refers From) & Global Standards Provenance

This RobOS schema is modeled after and directly aligns with two levels of global standards:

  • Universal Schema.org Class: https://schema.org/Property (100% interoperability with search engines, web indexers, and general AI reasoning)
  • Specialized Domain Standard: https://www.iso.org/standard/63555.html (de facto standard for domain-specific ALM, BDD, or infrastructure operations)
  • Canonical Reference: https://schema.org/Property
  • Agent Guidelines: When autonomous agents generate, expand, or validate instances of robos:DatabaseColumn, they MUST adhere to and base their output on this referred schema object and universal Schema.org parent class, extending it with RobOS SDLC properties.

Entity Relationship & Schema Context

Database Column robos:DatabaseColumn

Governed by W3C SHACL shape urn:robos:shape:DatabaseColumnShape within the Core Platform (robos.core) (robos.platform) package store.

dcterms:title robos:columnName robos:dataType robos:table

Property Constraints & SHACL Rules

Property Path Name Multiplicity Data Type Constraint Rule / Validation Message
dcterms:title Title / Display Name 1..* xsd:string Database Column must have a title.
robos:columnName Column Name 1..* xsd:string Database Column must specify column name.
robos:dataType Column Data Type 1..* xsd:string Database Column must declare data type.
robos:table Parent Table 1..* URI (robos:DatabaseTable) Database Column must link to parent table.

Canonical OSLC JSON-LD Example

{
  "@id": "urn:robos:core-platform:database-column-sample",
  "@type": [
    "robos:DatabaseColumn",
    "schema:Property",
    "oslc:Resource"
  ],
  "dcterms:title": "Sample Database Column",
  "dcterms:description": "Canonical reference instance for robos:DatabaseColumn.",
  "robos:package": "core-platform",
  "robos:namespace": "robos.platform",
  "robos:columnName": "sample_column",
  "robos:dataType": "varchar(255)",
  "robos:table": "urn:robos:db-table:sample-table",
  "robos:schemaOrgType": "https://schema.org/Property",
  "robos:domainStandard": "https://www.iso.org/standard/63555.html",
  "robos:refersFrom": "https://schema.org/Property"
}

Programmatic SHACL Validation

const { SHACLValidator } = require('/usr/local/share/robos/robos-graph/lib/shacl-validator');
const { OSLCGraphParser, OSLC_CONTEXT } = require('/usr/local/share/robos/robos-graph/lib/oslc-parser');

const validator = new SHACLValidator();
const result = validator.validateGraph(new OSLCGraphParser({
  "@context": OSLC_CONTEXT,
  "robos:nodes": [
    {
        "@id": "urn:robos:core-platform:database-column-sample",
        "@type": [
            "robos:DatabaseColumn",
            "schema:Property",
            "oslc:Resource"
        ],
        "dcterms:title": "Sample Database Column",
        "dcterms:description": "Canonical reference instance for robos:DatabaseColumn.",
        "robos:package": "core-platform",
        "robos:namespace": "robos.platform",
        "robos:columnName": "sample_column",
        "robos:dataType": "varchar(255)",
        "robos:table": "urn:robos:db-table:sample-table",
        "robos:schemaOrgType": "https://schema.org/Property",
        "robos:domainStandard": "https://www.iso.org/standard/63555.html",
        "robos:refersFrom": "https://schema.org/Property"
    }
  ],
}));

console.log("Conforms:", result.conforms); // Expected: true