ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ProfileResults

Information about Profile Results

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ResultID	BigInt
	XLocation	Float
	XLocationUnitsID	Integer
	YLocation	Float
	YLocationUnitsID	Integer
	SpatialReferenceID	Integer
	IntendedZSpacing	Float
	IntendedZSpacingUnitsID	Integer
	IntendedTimeSpacing	Float
	IntendedTimeSpacingUnitsID	Integer
	AggregationStatisticCV	VarChar(255)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ProfileResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.ProfileResults	Name	AggregationStatisticCV
fk_ProfileResults_DUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	IntendedZSpacingUnitsID
fk_ProfileResults_Results	ODM2Core.Results	ODM2Results.ProfileResults	ResultID	ResultID
fk_ProfileResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.ProfileResults	SpatialReferenceID	SpatialReferenceID
fk_ProfileResults_TUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	IntendedTimeSpacingUnitsID
fk_ProfileResults_XUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	XLocationUnitsID
fk_ProfileResults_YUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	YLocationUnitsID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ProfileResultValues_ProfileResults	ODM2Results.ProfileResults	ODM2Results.ProfileResultValues	ResultID	ResultID

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2Results