Skip to main content

Table Design

Attributes

NameTypeExampleDescription
pkstringjohn.doe@example.comPartition Key: The borrower's email address
skstringBORROWING_CAPACITY_CALCULATION#2dd0ce10-4d28-4275-af31-b2e5edc7430a#TIMESTAMP#2024-03-15T00:00:00.000ZSort Key: The entity type ('BORROWING_CAPACITY_CALCULATION'), borrowingCapacityCalculationId and timestamp separated by '#'
estimatedBorrowingCapacitynumber100000The borrower's borrowing capacity. This is a number >= 0
grossAnnualIncomenumber40000The borrower's gross annual income. This is a number >= 0
employmentStatusstring'FULL_TIME'The borrower's employment status. One of 'FULL_TIME', 'PART_TIME', 'CASUAL', 'SELF_EMPLOYED'
borrowingCapacityCalculationIdstring'2dd0ce10-4d28-4275-af31-b2e5edc7430a'A randomly generated V4 UUID
timestampstring'2024-03-15T00:00:00.000Z`The time of calculation of the borrowing capacity. This is an ISO8061 date and time in UTC.

Borrower Profile - Table Design