box_participants

-1 rows


Description

Участники обменов

Columns

Column Type Size Nulls Auto Default Children Parents Comments
box_id uuid 2147483647 null
boxes.id box_participants_box_id_fkey C

Обмен (FK на boxes)
user_id uuid 2147483647 null
users.id box_participants_user_id_fkey C

Пользователь (FK на users)
joined_at timestamptz 35,6 null

Дата вступления в обмен
is_active bool 1 null

Флаг активности участника
id uuid 2147483647 null
chat_rooms.participant1_id chat_rooms_participant1_id_fkey C
chat_rooms.participant2_id chat_rooms_participant2_id_fkey C
deliveries.giver_participant_id deliveries_giver_participant_id_fkey C
deliveries.receiver_participant_id deliveries_receiver_participant_id_fkey C
draw_pairs.giver_participant_id draw_pairs_giver_participant_id_fkey C
draw_pairs.receiver_participant_id draw_pairs_receiver_participant_id_fkey C
participant_exclusions.from_participant_id participant_exclusions_from_participant_id_fkey C
participant_exclusions.to_participant_id participant_exclusions_to_participant_id_fkey C
wishlists.participant_id wishlists_participant_id_fkey C

Уникальный идентификатор участника (UUID)
created_at timestamptz 35,6 now()

Дата создания записи
updated_at timestamptz 35,6 now()

Дата последнего обновления

Indexes

Constraint Name Type Sort Column(s)
box_participants_pkey Primary key Asc id
ix_box_participants_box_id Performance Asc box_id
ix_box_participants_is_active Performance Asc is_active
ix_box_participants_user_id Performance Asc user_id
uq_box_participants_box_user Must be unique Asc/Asc box_id + user_id

Relationships

Close relationships within degrees of separation