← GalerieBeispiel
E-commerce Postgres data model — 10 entities, exportable as Postgres SQL or DBML
Datenmodell · 10 Blöcke · Lesemodus
Fakten im Überblick
B2B e-commerce backend with dialect-correct types, GDPR PII tags, multi-tenant RLS and auto-grouped audit columns. Export to Postgres SQL / DBML.
Zielgruppe: Backend developers, tech leads reviewing AI-generated migrations, data engineers
- Native Postgres types (uuid, jsonb, timestamptz, enum{...}, numeric)
- Red PII markers on GDPR-sensitive columns (email, phone, address)
- RLS chip on multi-tenant tables + "auth." vs "public." namespaces
- Audit columns (created_at, updated_at, deleted_at) grouped in a muted footer