Gained lots from this video. I have been watching RU-vid videos for DynamoDB. Your method of 'Show and Why' went that little bit further of 'Show and Do This Way'. Your explanations help me understand why things are done as best practices.
This is all very cool. But seems like a lot of contortions and conventions to make up for the absence of things that something like mongo does out of the box with indexes, $lookup, ...
I have a controversy about this design. There is too much duplication. It forces the use of a unique name. It doesn't allow to use of non-uniq names I prefer to use ulid. It keeps unique and ordered. ulid ID has date in ID, ulid keeps an ordering