Archetypes Postgres #

This directory mirrors archetypes_ddb/, but translates the archetypes into a Postgres-native realization style:

• tables instead of DDB items
• primary keys and secondary indexes instead of PK/SK + GSI
• INSERT, UPDATE ... WHERE ..., ON CONFLICT, BEGIN/COMMIT
• CDC / outbox / WAL instead of DDB Streams
• partitioning and composite indexes instead of DDB bucketed GSIs

The archetype is not the store. These files are meant to help translate DDB-shaped thinking into generic SQL/Postgres system design language.