DynamoDB best practice design for deleting a user account

The question, I'm doing an ERD for DynamoDB and have a customer table, order table and a few other tables with data/content all related to the customer.

When the user chooses to delete their account, I want to delete all records related to their account, this would also include any assets I have stored on S3 and CloudFront.

My question is if I have a CustomerID, should I persist that as a Foreign Key across all tables to be able to find all records associated with a particular customer in order to be able to run my delete methods or is there a better-preferred pattern?

Any advice appreciated.

thanks,

Matt

https://stackoverflow.com/questions/65431737/dynamodb-best-practice-design-for-deleting-a-user-account December 24, 2020 at 06:33AM