Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| delivery_id | uuid | 2147483647 | null |
|
|
Доставка (FK на deliveries) |
|||||
| voter_id | uuid | 2147483647 | null |
|
|
Голосующий (FK на users) |
|||||
| vote_type | text | 2147483647 | null |
|
|
Тип голоса (like/dislike) |
|||||
| voted_at | timestamptz | 35,6 | null |
|
|
Дата голосования |
|||||
| id | uuid | 2147483647 | null |
|
|
Уникальный идентификатор голоса (UUID) |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
Дата создания записи |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
Дата последнего обновления |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| votes_pkey | Primary key | Asc | id |
| ix_votes_delivery_id | Performance | Asc | delivery_id |
| ix_votes_vote_type | Performance | Asc | vote_type |
| ix_votes_voter_id | Performance | Asc | voter_id |
| uq_votes_delivery_voter | Must be unique | Asc/Asc | delivery_id + voter_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| chk_votes_type | (vote_type = ANY (ARRAY['like'::text, 'super'::text, 'favorite'::text])) |
Relationships
Close relationships within degrees of separation
