Table: covariates |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | bigserial | 19 | χ | √ | nextval('covariates_id_seq'::regclass) | ||
trait_id | int8 | 19 | √ | χ | null | traits.id | |
variable_id | int8 | 19 | √ | χ | null | variables.id | |
level | float8 | 17,17 | √ | χ | null | Value of covariate, units are determined in variables table by the variable_id foreign key. | |
created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
n | int4 | 10 | √ | χ | null | ||
statname | statnames | 2147483647 | χ | χ | ''::text | ||
stat | float8 | 17,17 | √ | χ | null |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | covariates_pkey |
trait_id + variable_id | Performance | Asc/Asc | index_covariates_on_trait_id_and_variable_id |
![]() ![]() |