Complexities

From KallestadWiki

Complex Data objects generally consist of data from multiple database tables.

The complexities table defines the relationships so that the KDF framework can manage the data objects intelligently.

Data relationships can be of many different types as follows:

• 0 one-to-zero-or-one-or-many
• 1 one-to-zero-or-one
• 2 one-to-one-or-many
• 3 one-to-many
• 4 one-to-one
• 5 one-to-defined
• 6 conditional

The integer value above is the associated value of the relationship field within the complexities table.

A one-to-zero-or-one-or-many relationship is the most relaxed relationship indicating that there are no boundaries in the relationship, aside from the fact that the child in the relationship defines a foreign key to a unique identifier of the parent element.

A many-to-many relationship would require a tertiary table consisting of two columns - each references to a unique identifier in parent tables.

A conditional relationship indicates that there may be a relational requirement, but that requirement would be based on data elements stored within the parent data set.

Kallestad Development Framework Topics

• KDF Home
• Project Overview
  • Peripheral Objectives
• Technical Information
  • Back End
    • Complex Objects
    • Abstract Elements
    • SQL API
  • Front End
  • Database Pool
• Licensing