AdjustmentRequest
{
    id: Primary Key of Adjustment table.
    request_id: Client-provided request ID
    eventIds: List
    eventType: enum (ORDER_ID/ SHIPMENT_ID)
    business: The business unit.
    countryCode: The country code.
    type: UNDO or RETRY.
    state: The overall state of the adjustment (PENDING, PROCESSING, COMPLETED, FAILED).
    createdBy: User/system initiating the adjustment.
    updatedBy: Last user/system to modify the record.
    createdAt: Timestamp of creation.
    updatedAt: Timestamp of last update
}

ProcessingEvent
{  
    id: Primary key of AdjustmentItem table.
    request_id: Client-provided request ID (FK to Request table)
    type: UNDO or REPROCESS.
    eventId: The business event ID.
    financeEventId: The financial event ID.
    state: The state of this specific item (PENDING, PROCESSING, COMPLETED, FAILED)
    parent_processing_event_id: Self referential FK (NULL for UNDO, points to corresponding UNDO event for REPROCESS)
    createdBy: User/system initiating the adjustment.
    updatedBy: Last user/system to modify the record.
    createdAt: Timestamp of creation.
    updatedAt: Timestamp of last update.
}

sample SQL example:

CREATE TABLE `db_name`.`table_name` (
`tableNameId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'table pk',
`columnName1` char(20) COMMENT 'column name 1',
`columnName2` char(20) COMMENT 'column name 2',
`createdAt` datetime(6) NOT NULL COMMENT 'created date',
`updatedAt` datetime(6) NOT NULL COMMENT 'updated date',
PRIMARY KEY (`tableNameId`),
UNIQUE KEY `table_name_uk01` (`columnName1`),
KEY `table_name_idx01` (`updatedAt`),
KEY `table_name_idx02` (`createdAt`)
) AUTO_INCREMENT=1 COMMENT='What is for this table';