iaa_edition_catalog_to_text_fragment_confirmation

15403 rows


Description

This table is part of the temporary and preliminary catalog info matching system. There are three possibilities here: 1. confirmed = 0 and user_id IS NULL (the match has neither been confirmed nor rejected); 2. confirmed = 0 and user_id IS NOT NULL (the user with user_id has rejected the match); 3. confirmed = 1 and user_id IS NOT NULL (the user with user_id has confirmed the match as valid). The pairing confirmed = 1 and user_id IS NOT NULL is an invalid combination.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
iaa_edition_catalog_to_text_fragment_id INT UNSIGNED 10 0
iaa_edition_catalog_to_text_fragment.iaa_edition_catalog_to_text_fragment_id fk_aecttfc_to_iaa_edition_catalog_to_text_fragmentR
confirmed BIT 3 0

Boolean for whether the match has been confirmed (1) or rejected (0). If this is set to 0 and the user_id is NULL, then the match has neither been confirmed nor rejected (thus it should be queued for review).
user_id INT UNSIGNED 10 √ NULL
user.user_id fk_iaa_edition_catalog_to_text_fragment_confirmation_to_userR

user_id of the person who has confirmed or rejected the match. If NULL, the match has neither been confirmed nor rejected.
time DATETIME 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
fk_iaa_edition_catalog_to_text_fragment_confirmation_to_user Performance Asc user_id
unique_edition_catalog_to_text_fragment_confirmation Must be unique Asc/Asc/Asc/Asc iaa_edition_catalog_to_text_fragment_id + confirmed + user_id + time

Relationships

Close relationships within degrees of separation