How it works Create a new property

Overview:

This page documents how we create new properties via the UNTE interface.

Things to Keep in mind:

All properties are NOT equal.

We have:

• Level 1 properties (a Building)
• Level 2 properties (a Flat or a sub-division of a Level 1 property like a store or a parking lot).
• Level 3 properties (a Room or a sub-division of a Level 2 property)

Mandatory attributes:

You MUST provide some mandatory attributes when you try to create a new property. These attributes are DIFFERENT for Level 1, 2, and 3 properties.

Some of the mandatory attributes are automatically provided if you use the UNTE interface. If you want to simulate things without using the UNTE interface, you need to make sure that you are providing the correct mandatory attributes or the property creation will likely fail.

All properties MUST be associated with a valid Unee-T Enterprise ID.

Scripts and routines:

We are using DIFFERENT scripts and DIFFERENT tables to manage and manipulate different types of properties (Level 1, 2, and 3). In other words, a building is NOT created the same way as a flat is and a room is NOT created the same way a flat is.

The UNTE database schema has built-in internal controls, constraints, and checks to make sure that we are not creating incorrect or incomplete records.

We are using Database Triggers, views, and procedures to simplify and automate property creation and make sure that all is done as it should be.

Creation in Unee-T is done ONLY if all tests are passed:

IF a property is:

1. Properly created in the UNTE interface AND
2. Identified as a property that needs to be created in Unee-T THEN a lambda call is made to the MEFE using the MEFE API to create a new unit in the Mongo and the BZ databases.

Level 1 property:

The UNTE screens:

Go to the

• "Manage Building" page: .../Manage_Buildings_list.php.
• Click on the "Add New" button.
• A modal window appears.
• Fill the required information.
• Click on Save.

Where do we store the raw data before validation:

Mandatory information:

Constraints and controls:

Tables involved:

Procedures involved:

Views involved:

Triggers involved:

Level 2 properties:

The UNTE screens

Where do we store the raw data before validation:

Mandatory information:

Constraints and controls:

Tables involved:

Procedures involved:

Views involved:

Triggers involved:

Level 3 properties:

The UNTE screens

Where do we store the raw data before validation:

Mandatory information:

Constraints and controls:

Tables involved:

Procedures involved:

Views involved:

Triggers involved: