DatastreamProvenanceFiles - Table

ODMX [ODMX_DBWrench_Schema.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: DatastreamProvenanceFiles

A link between files, datastreamids and instruments

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	DatastreamProvenanceFileID	Integer
	DatastreamID	Integer
	EquipmentID	Integer
	FileStorageName	VarChar()
	FileStoragePath	VarChar()

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_DatastreamProvenanceFiles_Equipment	ODMXEquipment.Equipment	ODMXSSI.DatastreamProvenanceFiles	EquipmentID	EquipmentID
fk_DatastreamProvenanceFiles_SamplingFeatureTimeseriesDatastreams	ODMXSSI.SamplingFeatureTimeseriesDatastreams	ODMXSSI.DatastreamProvenanceFiles	DatastreamID	DatastreamID

Triggers

(none)

Used in Diagrams