Database Schemas

This section provides detailed documentation for each schema component in the Open Data Repository database.

Schema Components:

• Authentication Schema
  • Users
  • Sessions & Accounts
  • Verification
• Content Schema
  • Core Content
  • Content Metadata
  • Content Organization
  • Content Status Tracking
• Annotation Schema
  • Annotation Sources
  • Core Annotations
  • Annotation Metadata
  • Annotation Embeddings
  • Source Linking
• Embedding Schema
  • Embedding Engines
  • Content Embeddings
• Team Schema
  • Teams
  • Team Membership

Schema Overview

The database schema is organized into several logical components:

Authentication Schema

Handles user accounts, sessions, and authentication providers. See Authentication Schema for details.

Content Schema

Manages digital assets and their metadata. See Content Schema for details.

Annotation Schema

Controls content annotations and their metadata. See Annotation Schema for details.

Embedding Schema

Manages vector embeddings for search and similarity. See Embedding Schema for details.

Team Schema

Handles team organization and membership. See Team Schema for details.

Relationships

The schemas are interconnected through foreign key relationships:

• Users can belong to multiple teams through userTeams

• Content can be owned by users and teams

• Annotations can reference content and have associated embeddings

• Content can be organized into sets and collections

For detailed information about specific schemas, click the relevant links above.