Overview

The Property Insurance Valuation Platform application uses a relational database to store an organization's data (clients/accounts, business units, projects, locations, and buildings). A relational database has pre-defined relationships that connect data. The data is stored in Tables, which using relationships to connect. A User can access the data within tables using a key (e.g., unique ID).

Data Tables

The following is a list of the Data Tables within the application:

• Group: The Group table is a primary table in the data model containing information about the organization, including the organization’s name, website, logo, and address.
• Region: The Region table is the secondary table in the data model containing information about the business units, including the business unit name, website, logo, and address.
• Account: The Account table is another essential table in the data model containing information about the clients/accounts, including account name, website, address, and contact information. The client/account's External Ref ID links the author to the Group table. Each Account can include multiple projects.
• Project: The Project table includes information about each project processed in an application, including the project name, date started, date ended, etc. The customer's External Ref ID links the customer to the Account table. Each project can include multiple locations.
• Locations: The Locations table includes information about each location (group of buildings) processed in an application, including location name, date started, date ended, etc. The location's External Ref ID links the customer to the Project table.
• Buildings: The Buildings table is a primary table in the data model containing information about buildings in a profile, including building name, address, occupancy, gross floor area, client-declared value, local currency, replacement cost, etc. The building's External Ref ID links the building to other database tables.
• Valuations: The Valuation tab includes valuation information for each organization, including valuation date, replacement cost, valuation type, etc. The valuation External Ref ID links the order to the Buildings table.

Object Types and Relationship Flow Chart

Flow Chart