Tables which belong to manual merge process are stored in the deduplication DB.
manual_merge_candidates
column | value | description |
|---|---|---|
| id | UUID | record unique ID |
| pair_id | UUID | mpi.merge_candidates.id |
| person_id | UUID | the person which will be merged |
| master_person_id | UUID | the person who will stay active |
| status | string | NEW, PROCESSED |
| assignee_id | UUID | user, who currently reviews request, for new request it's null |
| final_decision | string | null, SPLIT, MERGE, POSTPONE |
| inserted_at | DATETIME | |
| updated_at | DATETIME | |
| inserted_by | ||
| updated_by |
manual_merge_process
column | value | description |
|---|---|---|
| id | UUID | record unique ID |
| pair_id | UUID | mpi.merge_candidates.id |
| status | string | NEW, PROCESSED |
| assignee_id | UUID | user, who currently reviews request |
| inserted_at | DATETIME | |
| updated_at | DATETIME | |
| decisions | string | NEW, SPLIT, MERGE, TRASH, POSTPONE |
| comment | string |
audit_log
column | value | description |
|---|---|---|
| id | UUID | record unique ID |
| actor_id | UUID | user_id |
| resource | string | manual_merge_process |
| resource_id | UUID | manual_merge_process.id |
| changeset | jsonb | |
| inserted_at | DATETIME |