traitdata - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: traitdata

Table holding specie straits (e.g. ecological indiactor values)

Columns

PKNameData TypeNULLAutoDefaultCommentFK

idInteger
taxonidInteger

fieldidInteger

valueVarChar()

Indexes

NameTableColumnsUniqueClustered
traitdata_index01traitdatataxonid
traitdata_index02traitdatataxonid, fieldid


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
traitdata_fkey01taxatraitdataidtaxonid
traitdata_fkey02fieldstraitdataidfieldid

Used in Diagrams

Diagram Name
public