Legend:
Primary key columns
Indexed columns
| Column |
Type |
Size |
Nulls |
Auto |
Default |
References |
| id |
serial |
10 |
χ |
√ |
nextval('covariates_id_seq'::regclass) |
|
| trait_id |
int4 |
10 |
√ |
χ |
null |
|
| variable_id |
int4 |
10 |
√ |
χ |
null |
|
| level |
numeric |
16,4 |
√ |
χ |
null |
|
| created_at |
timestamp |
29,6 |
√ |
χ |
null |
|
| updated_at |
timestamp |
29,6 |
√ |
χ |
null |
|
| n |
int4 |
10 |
√ |
χ |
null |
|
| statname |
varchar |
255 |
√ |
χ |
null |
|
| stat |
numeric |
16,4 |
√ |
χ |
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 |
