Table bety.public.sites |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | serial | 10 | χ | √ | nextval('sites_id_seq'::regclass) | ||
city | varchar | 255 | √ | χ | null | Nearest city to site. | |
state | varchar | 255 | √ | χ | null | If in the United States, state in which study is conducted. | |
country | varchar | 255 | √ | χ | null | ||
lat | numeric | 9,6 | √ | χ | null | Latitude, in decimal degrees | |
lon | numeric | 9,6 | √ | χ | null | Longitude, in decimal degrees. | |
mat | int4 | 10 | √ | χ | null | Mean Annual Temperature (C) | |
map | int4 | 10 | √ | χ | null | Mean Annual Precipitation (mm) | |
masl | int4 | 10 | √ | χ | null | Elevation (m above sea level) | |
soil | varchar | 255 | √ | χ | null | Soil type, as described in documentation. | |
som | numeric | 4,2 | √ | χ | null | Depreciated | |
notes | text | 2147483647 | √ | χ | null | ||
soilnotes | text | 2147483647 | √ | χ | null | ||
created_at | timestamp | 29,6 | √ | χ | null | ||
updated_at | timestamp | 29,6 | √ | χ | null | ||
sitename | varchar | 255 | √ | χ | null | ||
greenhouse | bool | 1 | √ | χ | null | Boolean: indicates if study was conducted in a field (0) or greenhouse, pot, or growth chamber (1) | |
user_id | int4 | 10 | √ | χ | null | ||
local_time | int4 | 10 | √ | χ | null | ||
sand_pct | numeric | 9,5 | √ | χ | null | ||
clay_pct | numeric | 9,5 | √ | χ | null | ||
espg | varchar | 255 | √ | χ | null |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | sites_pkey |
user_id | Performance | Asc | index_sites_on_user_id |