PhenocamCalculatedChannel - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: PhenocamCalculatedChannel

A table which holds detail on calculated phenocamchannels

Columns

PKNameData TypeNULLAutoDefaultCommentFK

PhenocamCalculatedChannelIDInteger

PhenocamLocationIDBigInt
PhenocamCubeIDBigInt
DatastreamIDInteger The ID of the datastream that is calculated

CalculationareaXcoordTopLeftInteger
CalculationareaYcoordTopLeftInteger
CalculationareaXcoordTopRightInteger
CalculationareaYcoordTopRightInteger
CalculationareaXcoordBottomRightInteger
CalculationareaYcoordBottomRightInteger
CalculationareaXcoordBottomLeftInteger
CalculationareaYcoordBottomLeftInteger
PhenocamChannelVarChar(100)

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_PhenocamCalculatedChannel_samplingfeatures_timeseriesdatastreamsODMXSSI.SamplingFeatureTimeseriesDatastreamsODMXSSI.PhenocamCalculatedChannelDatastreamIDDatastreamID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXSSI