logo
ExamplesEditorPricingDocs
37.1kSign in

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.

Asset Management ER diagram

IT asset management database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 vendors idBIGINT vendor_codeNVARCHAR nameNVARCHAR vendor_kindNVARCHAR support_emailNVARCHAR support_phoneNVARCHAR account_numberNVARCHAR is_activeBIT created_atDATETIME2 employees idBIGINT employee_numberNVARCHAR display_nameNVARCHAR work_emailNVARCHAR department_codeNVARCHAR office_locationNVARCHAR employment_statusNVARCHAR offboarded_onDATE asset_models idBIGINT model_codeNVARCHAR manufacturerNVARCHAR model_nameNVARCHAR categoryNVARCHAR specificationJSON default_useful_li…SMALLINT standard_cost_min…BIGINT currency_codeCHAR is_activeBIT assets idBIGINT asset_tagNVARCHAR model_idBIGINT vendor_idBIGINT serial_numberNVARCHAR statusNVARCHAR condition_gradeNVARCHAR purchase_orderNVARCHAR purchase_dateDATE purchase_cost_min…BIGINT currency_codeCHAR ownershipNVARCHAR current_locationNVARCHAR last_seen_atDATETIME2 created_atDATETIME2 asset_assignments idBIGINT asset_idBIGINT employee_idBIGINT assigned_locationNVARCHAR assignment_kindNVARCHAR assigned_onDATE due_back_onDATE returned_onDATE return_conditionNVARCHAR acknowledged_atDATETIME2 notesNVARCHAR software_licences idBIGINT licence_key_refer…NVARCHAR product_nameNVARCHAR editionNVARCHAR vendor_idBIGINT licence_modelNVARCHAR seats_entitledINTEGER seats_allocatedINTEGER unit_cost_minorBIGINT currency_codeCHAR term_startDATE term_endDATE auto_renewBIT is_activeBIT licence_allocations idBIGINT licence_idBIGINT employee_idBIGINT asset_idBIGINT allocated_onDATE released_onDATE install_detected_…DATETIME2 notesNVARCHAR support_contracts idBIGINT contract_referenceNVARCHAR vendor_idBIGINT asset_idBIGINT model_idBIGINT coverage_kindNVARCHAR service_levelNVARCHAR starts_onDATE ends_onDATE cost_minorBIGINT currency_codeCHAR auto_renewBIT maintenance_events idBIGINT asset_idBIGINT vendor_idBIGINT support_contract_…BIGINT event_kindNVARCHAR reported_atDATETIME2 started_atDATETIME2 completed_atDATETIME2 downtime_hoursDECIMAL cost_minorBIGINT currency_codeCHAR resolutionNVARCHAR depreciation_schedu… idBIGINT asset_idBIGINT period_startDATE period_endDATE methodNVARCHAR opening_value_min…BIGINT depreciation_minorBIGINT closing_value_min…BIGINT currency_codeCHAR is_postedBIT audits idBIGINT audit_referenceNVARCHAR scope_locationNVARCHAR scope_categoryNVARCHAR statusNVARCHAR started_onDATE completed_onDATE expected_countINTEGER sighted_countINTEGER conducted_by_empl…BIGINT audit_findings idBIGINT audit_idBIGINT asset_idBIGINT finding_kindNVARCHAR expected_valueNVARCHAR observed_valueNVARCHAR severityNVARCHAR statusNVARCHAR resolved_onDATE resolution_notesNVARCHAR disposals idBIGINT asset_idBIGINT disposal_methodNVARCHAR disposed_onDATE vendor_idBIGINT proceeds_minorBIGINT currency_codeCHAR book_value_at_dis…BIGINT data_wiped_atDATETIME2 wipe_certificate_…NVARCHAR approved_by_emplo…BIGINT

Related database schemas

PostgreSQL
Internal tools

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.

PostgreSQL
Internal tools

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.

SQL Server
Internal tools

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.

MySQL
Internal tools

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.