Legend:
Primary key columns
Indexed columns
| Column |
Type |
Size |
Nulls |
Auto |
Default |
References |
| id |
serial |
10 |
χ |
√ |
nextval('location_yields_id_seq'::regclass) |
|
| yield |
numeric |
20,15 |
√ |
χ |
null |
|
| species |
varchar |
255 |
√ |
χ |
null |
|
| created_at |
timestamp |
29,6 |
√ |
χ |
null |
|
| updated_at |
timestamp |
29,6 |
√ |
χ |
null |
|
| county_id |
int4 |
10 |
√ |
χ |
null |
|
Indexes:
| Column(s) |
Type |
Sort |
Constraint Name |
| id |
Primary key |
Asc |
location_yields_pkey |
| county_id |
Performance |
Asc |
index_location_yields_on_county_id |
| species |
Performance |
Asc |
index_location_yields_on_location_and_species |
| species + county_id |
Performance |
Asc/Asc |
index_location_yields_on_species_and_county_id |
| yield |
Performance |
Asc |
index_location_yields_on_yield |
