LOC Credit Lines

Storage

environment

table_name

location

test

test-loc-service

us-west-2

prod

prod-loc-service

us-east-2

Keys

  • PK - USER#<user_id>

  • SK - CREDITLINE#<line_id>

Query Patterns

Query Index Conditions

Get credit line by user_id and line_id

Primary

PK = USER#user_id, SK = CREDITLINE#line_id

Get any credit line by user_id

Primary

PK = USER#user_id, SK begins with CREDITLINE#