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