1. Real Estate Document Vault
  2. Data model
Reference

The tables behind Real Estate Document Vault

Real Estate Document Vault ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.

Tables
15
Features
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Property setup

Organizations, People and Properties identify the owning team, operator and parcel definition.

Packet work

Property packets holds the current revision, status, owner and sharing scope; title document versions holds dated observations under that packet.

Evidence and review

Evidence documents stores source files; review decisions records a person's decision on the exact packet revision; follow up actions assigns corrections.

Execution and history

Operation runs, operation steps and execution attempts describe attempted external work; state history records packet transitions.

Reference setup

Source mappings describes source field interpretation; Users stores account records; exchange rates stores effective currency rates.

Every table, by feature

Property packets

5 tablesAbout this feature
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Properties

    Real property definitions with parcel and policy references.

    Linked to Organizations
  • Organizations

    Title and escrow organizations that own property packets.

  • People

    Operators, reviewers and owners who work on property packets.

    Linked to Organizations
  • State history

    Immutable status transition history for property packets.

    Linked to Property packets, People

Title document versions

4 tablesAbout this feature
  • Title document versions

    Versioned title document observations belonging to a property packet.

    Linked to Property packets
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Evidence documents

    Source evidence documents supporting a property packet.

    Linked to Property packets, People
  • Review decisions

    Independent reviewer decisions recorded against an exact packet revision.

    Linked to Property packets, People

Evidence documents

4 tablesAbout this feature
  • Evidence documents

    Source evidence documents supporting a property packet.

    Linked to Property packets, People
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • People

    Operators, reviewers and owners who work on property packets.

    Linked to Organizations
  • Follow up actions

    Assigned follow-up work arising from review or execution.

    Linked to Property packets, People

Review decisions

5 tablesAbout this feature
  • Review decisions

    Independent reviewer decisions recorded against an exact packet revision.

    Linked to Property packets, People
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Title document versions

    Versioned title document observations belonging to a property packet.

    Linked to Property packets
  • Evidence documents

    Source evidence documents supporting a property packet.

    Linked to Property packets, People
  • Follow up actions

    Assigned follow-up work arising from review or execution.

    Linked to Property packets, People

Sharing and execution

6 tablesAbout this feature
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Review decisions

    Independent reviewer decisions recorded against an exact packet revision.

    Linked to Property packets, People
  • Operation runs

    Durable operation runs with frozen revision and input hash.

    Linked to Property packets
  • Operation steps

    Ordered steps within an operation run with input and output references.

    Linked to Operation runs
  • Execution attempts

    Individual attempts to execute an operation for a property packet.

    Linked to Property packets
  • State history

    Immutable status transition history for property packets.

    Linked to Property packets, People

Follow-up actions

5 tablesAbout this feature
  • Follow up actions

    Assigned follow-up work arising from review or execution.

    Linked to Property packets, People
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Review decisions

    Independent reviewer decisions recorded against an exact packet revision.

    Linked to Property packets, People
  • Evidence documents

    Source evidence documents supporting a property packet.

    Linked to Property packets, People
  • Execution attempts

    Individual attempts to execute an operation for a property packet.

    Linked to Property packets

History and mappings

7 tablesAbout this feature
  • State history

    Immutable status transition history for property packets.

    Linked to Property packets, People
  • Source mappings

    Reviewed field mappings from source documents to target fields.

    Linked to Properties
  • Properties

    Real property definitions with parcel and policy references.

    Linked to Organizations
  • Property packets

    Document packets assembled for a property, with status and sharing scope.

    Linked to Organizations, People, Properties
  • Operation runs

    Durable operation runs with frozen revision and input hash.

    Linked to Property packets
  • Operation steps

    Ordered steps within an operation run with input and output references.

    Linked to Operation runs
  • Execution attempts

    Individual attempts to execute an operation for a property packet.

    Linked to Property packets

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

The packet is the center of the working model. Its organization, owner and property definition point to setup records. Evidence, review decisions, follow-up actions, state history and execution attempts point back to the packet. Title versions use their parent packet. An operation run points to a packet, and steps point to the run. A reviewer or verifier points to People. These references let a reader trace a decision from source document through the packet revision to an external receipt.

Migration order

  1. Load Organizations, People and Properties with consistent codes and organization links.
  2. Review source mappings, Users and exchange rates where the operating setup uses them.
  3. Load property packets with owner, definition, date and current status.
  4. Attach evidence documents and title document versions with source references and dates.
  5. Add review decisions and follow up actions against the correct packet revisions.
  6. Preserve state history, operation runs, operation steps and execution attempts with their original references and receipt evidence.

Set up Real Estate Document Vault your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started