...
Tables which belong to manual merge process are stored in the deduplication DB. dedup DB.
ERD
TABLES
- manual_merge_candidates
column | value | description | ||
|---|---|---|---|---|
| id | UUID | record unique ID | ||
| pairmerge_candidate_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 | stringvarchar(255) | NEW, PROCESSED | ||
| status_reason | text | automate job's comment | ||
| assignee_id | UUID | user_id, who currently reviews request, for new request it's null | ||
| final_decisionstring | varchar(255) | null, SPLIT, MERGE, POSTPONETRASH | ||
| inserted_at | DATETIME | |||
| updated_at | DATETIME | inserted_by | updated_by |
- manual_merge_
...
- requests
column | value | description | ||
|---|---|---|---|---|
| id | UUID | record unique ID | ||
| pairmanual_merge_candidate_id | UUID | mpidedup.manual_merge_candidates.id | status | string|
| NEW, PROCESSED | assignee_id | UUID | user_id, who currently reviews request | |
| inserted_at | DATETIME | |||
| updated_at | DATETIME | |||
| decisionsstatus | 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 |
...