Accounting Performance - Remove GUID
- Jeff Duke
Analytics
Target release | 6.0.0 |
|---|---|
Epic |
|
Document status | DRAFT |
Document owner | @ mention owner |
Designer | @ designer |
Tech lead | @ lead |
Technical writers | @ writers |
QA |
|
Objective
Remove the GUID column form the Charge Admin table. This column has a unique constraint, causing additional queries and validation on update and save actions. The original intent and usage was never implemented and column currently is only used for child parent relationship. parent relationship can be changed to use the Charge Admin primary key. This change will save on time creating the GUID value and the time to validate its uniqueness.
Success metrics
Goal | Metric |
|---|---|
|
|
Assumptions
Milestones
Requirements
Requirement | User Story | Importance | Jira Issue | Notes |
|---|---|---|---|---|
Change parent column constraint to the charge_admin_id | HIGH |
|
| |
update script to map the parent GUID to the parent record’s ID. |
| HIGH |
|
|
Remove GUID from all command and service calls and set parent relationship in the service calls. |
| HIGH
|
|
|
Remove GUID from Charge Admin table. |
| HIGH |
|
|
User interaction and design
Open Questions
Question | Answer | Date Answered |
|---|---|---|