Database Schema
Database documentation template with table cards, column types, relationship diagrams, and index listings. Dark terminal-inspired design.
Available Variables
Use these variables with Handlebars syntax {{variableName}} in your content.
{{dbType}}PostgreSQL 16
{{table2Fk}}author_id
{{table3Fk1}}user_id
{{table3Fk2}}template_id
{{index1Name}}idx_users_email
{{index1Type}}UNIQUE
{{index2Name}}idx_templates_category
{{index2Type}}BTREE
{{index3Name}}idx_logs_created
{{index3Type}}BTREE
{{table1Col1}}{{table1Col2}}username
{{table1Name}}users
{{table1Rows}}50K
{{table2Col1}}name
{{table2Name}}templates
{{table2Rows}}15K
{{table3Col1}}created_at
{{table3Name}}likes
{{table3Rows}}200K
{{table4Col1}}action
{{table4Col2}}metadata
{{table4Name}}audit_logs
{{table4Rows}}1M
{{tableCount}}8
{{index1Table}}users
{{index2Table}}templates
{{index3Table}}audit_logs
{{lastUpdated}}January 2025
{{databaseName}}versekit_db
{{table1IdType}}UUID
{{table2IdType}}UUID
{{table3IdType}}SERIAL
{{index1Columns}}{{index2Columns}}category
{{index3Columns}}created_at DESC
{{relation1Desc}}User creates templates
{{relation1Type}}1:N
{{relation2Desc}}User likes templates
{{relation2Type}}N:N
{{relation3Desc}}User generates logs
{{relation3Type}}1:N
{{relationCount}}12
{{table1Col1Type}}VARCHAR(255)
{{table1Col2Type}}VARCHAR(50)
{{table2Col1Type}}VARCHAR(100)
{{table3Col1Type}}TIMESTAMP
{{table4Col1Type}}VARCHAR(50)
{{table4Col2Type}}JSONB
More technical Templates
Architecture Diagram
System architecture documentation with layered diagrams, tech stack overview, data flow visualization, and requirement cards. Perfect for technical specs.
System Design Doc
Comprehensive system design document with goals, constraints, capacity estimation, API design, and trade-offs. Interview-ready format.
Deployment Runbook
DevOps deployment runbook with prerequisites checklist, step-by-step commands, rollback procedures, and emergency contacts. Terminal-style design.