MultiAttributeSeriesValues - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: MultiAttributeSeriesValues

This table stores the data values for each column in the array along with a value order as an incremental integer (1, 2, 3…) that corresponds to the original order of data values in the paired array.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

MultiAttributeSeriesValueIDInteger

Primary key identifier
MultiAttributeSeriesIDInteger Foreign key identifier

DataValueVarChar(255) a text or numeirc value of the column. e.g., 100 or January
ValueOrderInteger An integer as an ascending order that coresponds to the Values of the column. The order of the value preserves the pairing of data values across columns of the same MultiColumn array

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_MultiAttributeSeriesValues_MultiAttributeSeriesDataValues.MultiAttributeSeriesDataValues.MultiAttributeSeriesValuesMultiAttributeSeriesIDMultiAttributeSeriesID

Triggers

(none)


Used in Diagrams

Diagram Name
01_WaMDaM
02_WaMDaM_WCVs