| 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 |
|
