SamplingFeatureTimeseriesDatastreams - Table

ODMX [ODMX_DBWrench_Schema.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: SamplingFeatureTimeseriesDatastreams

This table contains timeseriesdata associated with different samplingfeatures

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	DatastreamID	Integer
	DatastreamUUID	VarChar()
	EquipmentID	Integer
	SamplingFeatureID	Integer
	DatastreamType	VarChar()
	VariableID	Integer
	UnitsID	Integer
	DatastreamDatabase	VarChar()				The database which holds the DatastreamTable
	DatastreamTablename	VarChar()
	FirstMeasurementDate	DateTime
	LastMeasurementDate	DateTime
	TotalMeasurementNumbers	BigInt
	DatastreamAttribute	VarChar()				An optional text string which can be used to provide clarification in labeling on the datastream
	DatastreamAccessLevel	VarChar()
	DatastreamSourceCategory	VarChar()
	DatastreamClassifier	VarChar()

Indexes

Name	Table	Columns	Unique	Clustered
SamplingFeatureTimeseriesDatastreams_DatastreamTablename_Idx	ODMXSSI.SamplingFeatureTimeseriesDatastreams	DatastreamTablename

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SamplingFeatureTimeseriesDatastreams_CV_DatastreamAccessLevel	ODMXCV.CV_DatastreamAccessLevel	ODMXSSI.SamplingFeatureTimeseriesDatastreams	Term	DatastreamAccessLevel
fk_SamplingFeatureTimeseriesDatastreams_CV_DatastreamClassifier	ODMXCV.CV_DatastreamClassifier	ODMXSSI.SamplingFeatureTimeseriesDatastreams	Term	DatastreamClassifier
fk_SamplingFeatureTimeseriesDatastreams_CV_DatastreamSourceCategory	ODMXCV.CV_DatastreamSourceCategory	ODMXSSI.SamplingFeatureTimeseriesDatastreams	Term	DatastreamSourceCategory
fk_SamplingFeatureTimeseriesDatastreams_CV_DatastreamType	ODMXCV.CV_DatastreamType	ODMXSSI.SamplingFeatureTimeseriesDatastreams	Term	DatastreamType
fk_SamplingFeatureTimeseriesDatastreams_CV_Units	ODMXCV.CV_Units	ODMXSSI.SamplingFeatureTimeseriesDatastreams	UnitsID	UnitsID
fk_SamplingFeatureTimeseriesDatastreams_Equipment	ODMXEquipment.Equipment	ODMXSSI.SamplingFeatureTimeseriesDatastreams	EquipmentID	EquipmentID
fk_SamplingFeatureTimeseriesDatastreams_SamplingFeatures	ODMXCore.SamplingFeatures	ODMXSSI.SamplingFeatureTimeseriesDatastreams	SamplingFeatureID	SamplingFeatureID
fk_SamplingFeatureTimeseriesDatastreams_Variables	ODMXCore.Variables	ODMXSSI.SamplingFeatureTimeseriesDatastreams	VariableID	VariableID

Triggers

(none)

Used in Diagrams