Table: pfts_species This table tells which species are members of which pfts. For each row, the species with id "specie_id" is a member of the pft with id "pft_id".
|
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
pft_id | int8 | 19 | χ | χ | pfts.id | ||
specie_id | int8 | 19 | χ | χ | species.id | ||
created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
id | bigserial | 19 | χ | √ | nextval('pfts_species_id_seq'::regclass) |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
pft_id + specie_id | Must be unique | Asc/Asc | index_pfts_species_on_pft_id_and_specie_id |
![]() ![]() |