Source¶
Sources are data stores that can either be the source of data to be processed or targets for processes to write data to.
Dataset Type¶
This table tracks dataset types (i.e. Customer, Sales, Employee, etc.).
| Column 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 |
Source¶
This is the core table tracking sources/targets.
| Column 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. |
Source Dataset Type¶
This table tracks the relationship between sources and dataset types.
| Column Name | Column Type | Column Description |
|---|---|---|
| source_id | Integer | Foreign key to the Source table |
| dataset_type_id | Integer | Foreign key to the Dataset Type table |
Source Object¶
This is the core table tracking source/target objects.
Source Object Dataset Type¶
This table tracks the relationship between source/target objects and dataset types.
| Column Name | Column Type | Column Description |
|---|---|---|
| source_object_id | Integer | Foreign key to the Source Object table |
| dataset_type_id | Integer | Foreign key to the Dataset Type table |