Legend:
Primary key columns
Indexed columns
Column |
Type |
Size |
Nulls |
Auto |
Default |
References |
id |
bigserial |
19 |
χ |
√ |
nextval('attributes_id_seq'::regclass) |
|
container_type |
varchar |
2147483647 |
χ |
χ |
|
|
container_id |
int8 |
19 |
χ |
χ |
|
|
value |
jsonb |
2147483647 |
χ |
χ |
'"{}"'::jsonb |
|
created_at |
timestamp |
29,6 |
χ |
χ |
utc_now() |
|
updated_at |
timestamp |
29,6 |
χ |
χ |
utc_now() |
|
Indexes:
Column(s) |
Type |
Sort |
Constraint Name |
id |
Primary key |
Asc |
attributes_pkey |
container_type + container_id |
Must be unique |
Asc/Asc |
container_type_id |
container_id |
Performance |
Asc |
index_attributes_on_container_id |
value |
Performance |
Asc |
index_attributes_on_value |