Internal tools database schemas
Trackers, admin panels and workflow tools — the systems a team runs on. Human-readable keys, orderable boards and worklogs show up again and again. Every one opens in the free drawDB editor in a click, and is public domain.
6 schemas here, from 10 to 13 tables (75 tables and 753 columns in total), written for PostgreSQL, SQL Server, MySQL. Each one ships an ER diagram you can open and edit, a column-by-column reference, design notes explaining the trade-offs, and SQL for all six dialects. Recurring themes across the set: hr.
Applicant tracking & recruiting database schema
An ATS modelled end to end: jobs with openings and hiring teams, candidates separate from applications, per-job pipeline stages, interviews with panels, structured scorecards, offers with approval chains and a talent pool of near misses.
IT asset management database schema
How an IT estate is tracked end to end: models versus serialised assets, custody history, software licences and seat allocation with compliance counts, warranties and support contracts, maintenance, depreciation, audits and disposal.
Sales CRM & pipeline database schema
A sales CRM modelled end to end: accounts and contacts, leads converted into an account, contact and deal, deals moving through stages with full stage history, activities, quotes, forecasts, territories and custom fields.
HR and payroll database schema
How an HR system models data that must never be overwritten: employees, positions and reporting lines as dated rows, compensation history, payroll runs and itemised payslips, tax withholding, time off as a ledger, and benefits enrolment.
IT helpdesk and service desk database schema
An internal service desk modelled properly: a service catalogue, incidents and requests, ordered approval chains, change requests with risk and rollback plans, linked assets, versioned knowledge base articles, SLA clocks that pause, and satisfaction ratings.
Project management & issue tracker database schema
A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.