Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
iaa_edition_catalog_to_text_fragment_id | INT UNSIGNED | 10 | 0 |
|
|
|||||
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_id of the person who has confirmed or rejected the match. If NULL, the match has neither been confirmed nor rejected. |
|||
MAX(`time`) | DATETIME | 19 | √ | current_timestamp() |
|
|