Sources are data stores that can either be the source of data to be processed or targets for processes to write data to.
This table tracks dataset types (i.e. Customer, Sales, Employee, etc.).
dataset_type_lkupColumn Name | Column Type | Column Description |
---|---|---|
dataset_type_id | Auto incrementing integer sequence | System key for the dataset type |
dataset_type | String(250) | Unique name of the given dataset type |
This is the core table tracking sources/targets.
source_lkupColumn Name | Column Type | Column Description |
---|---|---|
source_id | Auto incrementing integer sequence | System key for the source |
source_name | String(250) | Unique name of the given source. |
This table tracks the relationship between sources and dataset types.
source_dataset_typeColumn Name | Column Type | Column Description |
---|---|---|
source_id | Integer | Foreign key to the :ref:`source_lkup` table |
dataset_type_id | Integer | Foreign key to the :ref:`dataset_type_lkup` table |
This is the core table tracking source/target objects.
This table tracks the relationship between source/target objects and dataset types.
source_object_dataset_typeColumn Name | Column Type | Column Description |
---|---|---|
source_object_id | Integer | Foreign key to the :ref:`source_object_lkup` table |
dataset_type_id | Integer | Foreign key to the :ref:`dataset_type_lkup` table |