ODMX [ODMX_DBWrench_Schema.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| DatasourceID | Integer |
| ||||
| DatasourceTimezone | VarChar(100) | will come from CV | |||||
| SamplingFeatureID | Integer | SamolingfeatureID that the datasource is associated with |
|
||||
| DatasourcePath | VarChar() |
| The Filename of the file which will be ingested for this datasource. Different files may have different rules. | ||||
| FeederDatabase | VarChar() | Feeder database that original data is stored in | |||||
| FeederSchema | VarChar() | Schema for original data datasource | |||||
| DatasourceCharacterization | VarChar() |
| |||||
| DatatableName | VarChar() | Name of datatable. This is the same in datasource and Foreign Data Wrapper Databases | |||||
| OdmxDatabase | VarChar() | Foreign Data Wrapper Database name Typically ODMX project db | |||||
| MaterializedViewSchema | VarChar() | Foreign data wrapper schema |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DatasourceDescription_SamplingFeatures | ODMXCore.SamplingFeatures | ODMXSSI.DatasourceDescription | SamplingFeatureID | SamplingFeatureID |
(none)
| Diagram Name |
| ODMXSSI |