Turboveg 3
Table with additional species attribute data like sociability or phenology.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| id | Integer | |||||
| speciesobservationid | Integer |
|
|||||
| fieldid | Integer |
|
|||||
| lookupdataid | Integer |
| |||||
| valuestring | VarChar() |
| |||||
| valueinteger | Integer |
| |||||
| valuefloat | Real |
| |||||
| deleted | Boolean |
|
| Name | Table | Columns | Unique | Clustered |
| speciesobservationdata_index01 | speciesobservationdata | speciesobservationid | ||
| speciesobservationdata_index02 | speciesobservationdata | fieldid |
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| observationsspeciesdata_fkey01 | speciesobservations | speciesobservationdata | id | speciesobservationid |
| observationsspeciesdata_fkey02 | fields | speciesobservationdata | id | fieldid |
| Diagram Name |
| public |