Skip to main content

Entity Relationship Diagrams

This document contains Entity Relationship Diagrams for different domains of the Scoriet database. Each diagram focuses on a specific functional area to provide clarity and easy comprehension.

Database Designer Visual Database Designer showing the schema tables and their relationships

Core Domain - Users, Projects, Teams​

The core domain manages user accounts, project organization, and team structures.

Schema Domain - Database Schema Modeling​

The schema domain manages database schema definitions, versioning, and structure modeling.

Template Domain - Code Templates​

The template domain manages code templates, templates files, and template content.

Generation Domain - Code Generation​

The generation domain tracks code generation records, logs, and code adjustments.

Form Domain - Form Designer​

The form domain manages form sets, windows, elements, and field placements.

Report Domain - Report Designer​

The report domain manages report patterns, forms, elements, and layouts.

Kanban Domain - Project Management​

The kanban domain manages kanban boards, columns, cards, and activities.

Messaging Domain - User Communication​

The messaging domain manages user-to-user and broadcast messaging.

Diagram Symbols Reference​

  • ||--o{: One-to-Many relationship (one on the left, many on the right)
  • }o--||: Many-to-One relationship (many on the left, one on the right)
  • ||--||: One-to-One relationship (exactly one on each side)
  • FK: Foreign Key
  • PK: Primary Key
  • UK: Unique Key constraint

Each diagram can be viewed independently to understand relationships within a specific domain, or together as a comprehensive view of the entire database architecture.