Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|
| mcr_summary_data_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
||||
| cog_mid_tmax | int2 | 5 | √ |
|
|
Midpoint of the maximum temperature range for the center of gravity of the species. |
||||
| cog_mid_trange | int2 | 5 | √ |
|
|
Midpoint of the temperature range for the center of gravity of the species. |
||||
| date_updated | timestamptz | 35,6 | √ |
|
|
|||||
| taxon_id | int4 | 10 |
|
|
Specifies the taxonomic unit related to this record. |
|||||
| tmax_hi | int2 | 5 | √ |
|
|
Highest observed maximum temperature tolerance for the species. |
||||
| tmax_lo | int2 | 5 | √ |
|
|
Lowest observed maximum temperature tolerance for the species. |
||||
| tmin_hi | int2 | 5 | √ |
|
|
Highest observed minimum temperature tolerance for the species. |
||||
| tmin_lo | int2 | 5 | √ |
|
|
Lowest observed minimum temperature tolerance for the species. |
||||
| trange_hi | int2 | 5 | √ |
|
|
Upper bound of the temperature range the species can tolerate. |
||||
| trange_lo | int2 | 5 | √ |
|
|
Lower bound of the temperature range the species can tolerate. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_mcr_summary_data_pkey | Primary key | Asc | mcr_summary_data_id |
Relationships
Close relationships within degrees of separation
