logo
ExamplesEditorPricingDocs
37.1kSign in

Password manager & encrypted vault database schema

A local-first SQLite vault where the secrets are ciphertext the database cannot read: vaults as key boundaries, encrypted item fields, blind indexes for the few searches that must still work, TOTP seeds, password history, sharing and an audit log.

Password Manager ER diagram

Password manager & encrypted vault database schema n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idINTEGER account_uuidTEXT emailTEXT display_nameTEXT kdf_algorithmTEXT kdf_saltBLOB kdf_iterationsINTEGER master_key_verifi…BLOB encrypted_private…BLOB public_keyBLOB created_atTIMESTAMP vaults idINTEGER vault_uuidTEXT owner_idINTEGER nameTEXT is_personalBOOLEAN item_countINTEGER created_atTIMESTAMP updated_atTIMESTAMP vault_members vault_idINTEGER user_idINTEGER wrapped_vault_keyBLOB permissionTEXT accepted_atTIMESTAMP created_atTIMESTAMP folders idINTEGER vault_idINTEGER parent_idINTEGER name_ciphertextBLOB name_nonceBLOB positionINTEGER created_atTIMESTAMP items idINTEGER item_uuidTEXT vault_idINTEGER folder_idINTEGER item_typeTEXT name_ciphertextBLOB name_nonceBLOB name_blind_indexTEXT domain_blind_indexTEXT favoriteBOOLEAN repromptBOOLEAN deleted_atTIMESTAMP created_atTIMESTAMP updated_atTIMESTAMP item_fields idINTEGER item_idINTEGER field_kindTEXT label_ciphertextBLOB value_ciphertextBLOB nonceBLOB auth_tagBLOB positionINTEGER totp_secrets item_idINTEGER secret_ciphertextBLOB nonceBLOB algorithmTEXT digitsINTEGER period_secondsINTEGER created_atTIMESTAMP password_history idINTEGER item_idINTEGER value_ciphertextBLOB nonceBLOB strength_scoreINTEGER replaced_atTIMESTAMP tags idINTEGER vault_idINTEGER name_ciphertextBLOB name_nonceBLOB name_blind_indexTEXT colorTEXT item_tags item_idINTEGER tag_idINTEGER created_atTIMESTAMP share_invitations idINTEGER vault_idINTEGER inviter_idINTEGER invitee_emailTEXT invitee_user_idINTEGER wrapped_vault_keyBLOB token_hashTEXT permissionTEXT expires_atTIMESTAMP accepted_atTIMESTAMP created_atTIMESTAMP audit_events idINTEGER user_idINTEGER vault_idINTEGER item_idINTEGER actionTEXT device_labelTEXT ip_addressTEXT occurred_atTIMESTAMP

Related database schemas

SQLite
Productivity

Habit tracker app database schema

A small local-first SQLite schema for habit tracking: habits with date-versioned schedules, one row per completion, pauses that skip a streak instead of breaking it, reminders, and streaks derived from check-ins rather than stored as a counter.

SQLite
Productivity

Note-taking app database schema with backlinks

A local-first SQLite notes database: notebooks and notes, wiki-style backlinks parsed from note bodies into a link graph, tags, attachments, a full-text search index, revision history and last-writer-wins sync with a conflict record.

PostgreSQL
Productivity

Calendar and scheduling database schema

How a calendar app models its data: calendars and sharing, events with their own time zones, RRULE recurrence with exception dates and per-occurrence overrides, attendees and RSVP, reminders, working hours and a free-busy index.

PostgreSQL
Productivity

Dropbox-style file storage & sync database schema

How a cloud drive models its data: a folder tree, versioned files, content-addressed blocks that deduplicate identical uploads to a single copy, shares and expiring public links, per-device sync cursors, trash retention and quota accounting.