Database & ER models templates
Entity relationship diagrams from Mermaid, SQL DDL or DBML. Every one opens as a real, editable diagram — restyle it, extend it and export it as your own. See also the database schema diagram tool.
All 39 database & er models templates
Procure-to-Pay (P2P) data model
Suppliers, requisitions, purchase orders, goods receipts, supplier invoices and payments, with the three-way match (PO, receipt, invoice) visible in the keys. Modelled on how ERPs such as SAP MM/FI and Oracle Purchasing structure it.
SQL DDLOrder-to-Cash (O2C) data model
Customers, credit limits, quotes, sales orders, deliveries, billing documents, receivables and cash application — the SD/AR side of an ERP, from quote to reconciled cash.
SQL DDLPlan-to-Produce data model
Demand forecasts, master production schedule, MRP planned orders, bills of materials, routings, production orders, confirmations and quality results — the PP/MES side of manufacturing.
SQL DDLRecord-to-Report (R2R) data model
Company codes, chart of accounts, ledgers, fiscal periods, journal entries, intercompany, reconciliations, consolidation and financial statement mapping — the general-ledger and close model behind SAP FI/CO or Oracle GL.
SQL DDLProduct Lifecycle Management (PLM) data model
Products, parts, revisions, engineering BOMs, CAD documents, change requests and change orders, suppliers, compliance and lifecycle states — the model behind Teamcenter, Windchill or Arena-style PLM.
SQL DDLSupply Chain Planning (SCP) data model
Locations, transport lanes, sourcing rules, demand plans, inventory policies, supply plans, capacity constraints and scenarios — the model behind IBP, Kinaxis or o9-style planning tools.
SQL DDLOrder schema (ER diagram)
Crow's-foot relationships and typed columns.
MermaidOrders schema from CREATE TABLE
Paste DDL you already have — keys and crow’s feet come across.
SQL DDLSnowflake star schema
A fact table and its dimensions, in Snowflake types.
SQL DDLSaaS project schema (DBML)
If your schema lives in DBML already, it comes straight across.
DBMLBlog / CMS schema
Posts, authors, categories and tags with a many-to-many join table.
SQL DDLInventory & warehouse schema
Products, warehouses and stock levels per location.
DBMLSocial app schema (users, posts, follows)
A self-referencing follows table alongside posts and likes.
SQL DDLSaaS subscription billing schema
Accounts, plans, prices, subscriptions, invoices, line items and payments — the core of any subscription billing system.
SQL DDLHotel reservation schema
Hotels, room types, rooms, rates, guests, reservations and stays — the data model behind a property management system.
SQL DDLLearning management system schema
Courses, modules, lessons, enrolments, quizzes and progress tracking for an e-learning platform.
DBMLHR information system schema
Employees, departments, positions, managers, compensation history, time off and reviews.
SQL DDLCore banking schema
Customers, accounts, double-entry transactions, cards, loans and statements for a retail bank or fintech.
SQL DDLTwo-sided marketplace ER diagram
Buyers, sellers, listings, orders, reviews, payouts and disputes in Mermaid ER form.
MermaidCRM schema
Companies, contacts, leads, deals, pipeline stages, activities and owners — a Salesforce/HubSpot-style data model.
DBMLProject management tool schema
Workspaces, projects, tasks with subtasks, assignees, labels, comments and time tracking — a Jira/Asana-style model.
SQL DDLFood delivery app schema
Restaurants, menus, customers, orders, couriers and delivery tracking for a DoorDash-style app.
SQL DDLInsurance policy & claims schema
Policyholders, policies, coverages, premiums, claims, claim payments and adjusters.
SQL DDLIoT device management schema
Organisations, sites, devices, firmware, telemetry rollups, alerts and commands.
DBMLEvent ticketing schema
Venues, seating, events, ticket types, orders, tickets and check-ins for a Ticketmaster-style platform.
SQL DDLLibrary management ER diagram
Books, authors, copies, members, loans, holds and fines as a Mermaid ER diagram.
MermaidManufacturing execution (MES) schema
Products, bills of materials, work centres, work orders, operations, lots and quality inspections.
SQL DDLMulti-tenant RBAC permissions schema
Tenants, users, roles, permissions, groups, resource grants and audit log for fine-grained access control.
DBMLClinic scheduling & billing schema
Practitioners, availability, appointments, services, invoices and insurance claims for a clinic.
SQL DDLData Vault 2.0 model
Hubs, links and satellites for customers, orders and products — the modelling pattern for auditable enterprise warehouses.
SQL DDLReal estate listings schema
Agencies, agents, properties, listings, photos, viewings, offers and saved searches.
DBMLAudit trail & soft-delete pattern
A reusable pattern: versioned rows, change history, soft deletes and an append-only audit log around core entities.
SQL DDLRide-hailing platform ER diagram
Riders, drivers, vehicles, trips, fares, payments, ratings and surge zones in Mermaid ER form.
MermaidE-commerce store with reviews & coupons schema
Customers, products, categories, orders, order items, product reviews, coupons and coupon redemptions for an online store.
SQL DDLAirline reservation schema
Airports, aircraft, flights, fares, passengers, bookings, tickets and seat assignments behind an airline reservation system.
SQL DDLRestaurant POS & reservations schema
Tables, reservations, menu items, modifiers, checks, check items and payments for a full-service restaurant point-of-sale system.
SQL DDLVideo streaming subscriptions schema (DBML)
Accounts, profiles, plans, subscriptions, titles, episodes and watch history for a Netflix-style streaming service.
DBMLJob board & applicant tracking schema (DBML)
Companies, recruiters, job postings, candidates, applications, interviews and offers for a job board with a built-in applicant tracking system.
DBMLGym membership & classes schema (DBML)
Members, membership plans, memberships, trainers, class types, scheduled classes, bookings and check-ins for a fitness club.
DBML