KDF Data Model Internal Database
From KallestadWiki
Contents |
Purpose
The Internal Database model concerns how KDF will keep track of database level objects internally.
Data Model
Tables
- kdf_datasets - KDF Datasets are typically tables but may be other similar entities
- kdf_field_info - The KDF Field Info table contains basic information about columns stored internally within the KDF environment.
- kdf_enumerated_values - This table tracks enumeration values for enumerated KDF dataset columns stored internally within the KDF database.
- kdf_id_manager - The KDF ID Manager table is used internally by KDF to create unique identifiers for records within the system
- kdf_base_model - This table is used in the data modeling environment as a basis for tables within the system supporting and maintaining default KDF functionality.
Relationships
KDF Datasets have a one to zero or one relationship with KDF ID Manager objects. If a particular data set has it's unique identifiers managed by the internal KDF management utility, then a relationship will exist.
KDF datasets have a one to zero, one, or many relationship with Field Info objects. For each defined dataset, the fields within that data set are defined in KDF Field info.
KDF datasets have a one to zero,one, or many relationship with enumerated values. Every enumerated value belongs to a particular dataset and within that dataset a particular id. Datasets are not required to have enumerated values.
KDF enumerated values have a one or many to one relationship with field info. Any enumerated fields have their enumerated values defined within KDF enumerated values.
KDF Data Model Topics
- Overview
- Functionality Categories
- Internal Database
- Users and People
- Configuration
