← Galería

E-commerce Postgres data model — 10 entities, exportable as Postgres SQL or DBML

Modelo de datos · 10 bloques · solo lectura

Resumen factual

B2B e-commerce backend with dialect-correct types, GDPR PII tags, multi-tenant RLS and auto-grouped audit columns. Export to Postgres SQL / DBML.

Público: 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
Ejemplo