| Table: trait_covariate_associations |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| trait_variable_id | int8 | 19 | χ | χ | variables.id | ||
| covariate_variable_id | int8 | 19 | χ | χ | variables.id | ||
| required | bool | 1 | χ | χ | |||
| id | bigserial | 19 | χ | √ | nextval('trait_covariate_associations_id_seq'::regclass) |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| trait_variable_id + covariate_variable_id | Must be unique | Asc/Asc | trait_covariate_associations_uniqueness |
|
