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 |
