# Fire NOC Data Model

The Fire NOC module is used to provide NOC application services for approval from respective departments. NOC registry stores and serves the NOC related information using rest APIs.

## NOC Service Entity Details

* [eg\_fn\_buildingdocuments](#eg_fn_buildingdocuments)
* [eg\_fn\_institution](#eg_fn_institution)
* [eg\_fn\_owner](#eg_fn_owner)
* [eg\_fn\_firenocdetail](#eg_fn_firenocdetail)
* [eg\_fn\_firenoc](#eg_fn_firenoc)
* [eg\_fn\_address](#eg_fn_address)
* [eg\_fn\_buidlings](#eg_fn_buidlings)

## Data Constructs

### eg\_fn\_buildingdocuments

{% tabs %}
{% tab title="Description" %}
This table contains the document details submitted by users for the fire NOC application.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="168">Data Type</th><th width="269">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>Y</td></tr><tr><td>documenttype</td><td>varchar</td><td>type of document</td><td>Y</td></tr><tr><td>filestoreid</td><td>varchar</td><td>document filestore id</td><td>Y</td></tr><tr><td>active</td><td>boolean</td><td>boolean atribute to mark the details active/inactive</td><td>Y</td></tr><tr><td>documentuid</td><td>varchar</td><td>Document number</td><td></td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td><mark style="background-color:green;">buildinguuid (FK)</mark></td><td>varchar</td><td>Unique identifier of the building details</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                                                              |
| ----------------- | ---------------------------------------------------------------------------- |
| uuid (PK)         | FireNOCs.\*.fireNOCDetails.buildings.\*.applicationDocuments.\*.id           |
| tenantid          | FireNOCs.\*.tenantId                                                         |
| documenttype      | FireNOCs.\*.fireNOCDetails.buildings.\*.applicationDocuments.\*.documentType |
| filestoreid       | FireNOCs.\*.fireNOCDetails.buildings.\*.applicationDocuments.\*.fileStoreId  |
| active            | FireNOCs.\*.fireNOCDetails.buildings.\*.applicationDocuments.\*.active       |
| documentuid       | FireNOCs.\*.fireNOCDetails.buildings.\*.applicationDocuments.\*.documentUid  |
| createdby         | FireNOCs.\*.auditDetails.createdBy                                           |
| createdtime       | FireNOCs.\*.auditDetails.lastModifiedBy                                      |
| lastmodifiedby    | FireNOCs.\*.auditDetails.createdTime                                         |
| lastmodifiedtime  | FireNOCs.\*.auditDetails.lastModifiedTime                                    |
| buildinguuid (FK) | FireNOCs.\*.fireNOCDetails.buildings.\*.id                                   |
| {% endtab %}      |                                                                              |
| {% endtabs %}     |                                                                              |

### eg\_fn\_institution

{% tabs %}
{% tab title="Description" %}
This entity captures the institution detail from which the applicant seeks NOC.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="168">Data Type</th><th width="265">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>N</td></tr><tr><td><mark style="background-color:green;">firenocdetailsuuid (FK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC Details (UUID)</td><td>Y</td></tr><tr><td>name</td><td>varchar</td><td>name of institute</td><td>N</td></tr><tr><td>type</td><td>varchar</td><td>type of insititute</td><td>N</td></tr><tr><td>designation</td><td>varchar</td><td>designation in institute</td><td>N</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>active</td><td>boolean</td><td></td><td></td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name          | Mapping Details                                                          |
| ----------------------- | ------------------------------------------------------------------------ |
| uuid (PK)               | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.id          |
| tenantid                | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.tenantId    |
| firenocdetailsuuid (FK) | FireNOCs.\*.fireNOCDetails.id                                            |
| name                    | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.name        |
| type                    | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.type        |
| designation             | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.designation |
| createdby               | FireNOCs.\*.auditDetails.createdBy                                       |
| createdtime             | FireNOCs.\*.auditDetails.lastModifiedBy                                  |
| lastmodifiedby          | FireNOCs.\*.auditDetails.createdTime                                     |
| lastmodifiedtime        | FireNOCs.\*.auditDetails.lastModifiedTime                                |
| active                  |                                                                          |
| {% endtab %}            |                                                                          |
| {% endtabs %}           |                                                                          |

### eg\_fn\_owner

{% tabs %}
{% tab title="Description" %}
This table contains the details of the building owner for which the fire NOC application is submitted.&#x20;
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="169">Data Type</th><th width="255">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>Y</td></tr><tr><td><mark style="background-color:green;">firenocdetailsuuid (FK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC Details (UUID)</td><td>Y</td></tr><tr><td>isactive</td><td>boolean</td><td>boolean atribute to mark the details active/inactive</td><td>Y</td></tr><tr><td>isprimaryowner</td><td>boolean</td><td>The owner is primary or not</td><td>Y</td></tr><tr><td>ownertype</td><td>varchar</td><td>Type of owner, based on this option exemptions are applied. This is master data defined in mdms.</td><td>Y</td></tr><tr><td>ownershippercentage</td><td>varchar</td><td>Percentage of ownership of defined property</td><td>Y</td></tr><tr><td>relationship</td><td>varchar</td><td>Relationship of guardian with the owner</td><td>Y</td></tr><tr><td>active</td><td>boolean</td><td></td><td>Y</td></tr><tr><td>institutionid</td><td>varchar</td><td>Unique Identifier of the institute details</td><td>Y</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>useruuid</td><td>varchar</td><td>user uuid</td><td>Y</td></tr><tr><td>applicantcategory</td><td>varchar</td><td>owner category</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name                                                       | Mapping Details                                                           |
| -------------------------------------------------------------------- | ------------------------------------------------------------------------- |
| <mark style="background-color:red;">uuid (PK)</mark>                 | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.ownerUUID           |
| tenantid                                                             | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.tenantId            |
| <mark style="background-color:green;">firenocdetailsuuid (FK)</mark> | FireNOCs\*.fireNOCDetails.id                                              |
| isactive                                                             | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.isActive            |
| isprimaryowner                                                       | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.isPrimaryOwner      |
| ownertype                                                            | FireNOCs\*.fireNOCDetails.applicantDetails.ownerShipType                  |
| ownershippercentage                                                  | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.ownerShipPercentage |
| relationship                                                         | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.relationship        |
| active                                                               | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.active              |
| institutionid                                                        | FireNOCs.\*.fireNOCDetails.applicantDetails.additionalDetail.id           |
| createdby                                                            | FireNOCs.\*.auditDetails.createdBy                                        |
| createdtime                                                          | FireNOCs.\*.auditDetails.lastModifiedBy                                   |
| lastmodifiedby                                                       | FireNOCs.\*.auditDetails.createdTime                                      |
| lastmodifiedtime                                                     | FireNOCs.\*.auditDetails.lastModifiedTime                                 |
| useruuid                                                             | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.uuid                |
| applicantcategory                                                    | FireNOCs.\*.fireNOCDetails.applicantDetails.owners.\*.ownerType           |
| {% endtab %}                                                         |                                                                           |
| {% endtabs %}                                                        |                                                                           |

### eg\_fn\_firenocdetail

{% tabs %}
{% tab title="Description" %}
This entity captures the fire NOC certificate details issued to the applicant.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th width="211">Attribute Name</th><th width="164">Data Type</th><th width="281">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC Details (UUID)</td><td>Y</td></tr><tr><td><mark style="background-color:green;">firenocuuid (FK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC</td><td>Y</td></tr><tr><td>applicationnumber</td><td>varchar</td><td>Unique Application FireNOC Number of the Fire FireNOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.</td><td>Y</td></tr><tr><td>firenoctype</td><td>varchar</td><td>type of fire NOC from mdms</td><td>Y</td></tr><tr><td>firestationid</td><td>varchar</td><td>Fire station id where we are applying fire fireNOC.</td><td>Y</td></tr><tr><td>applicationdate</td><td>int</td><td>date on which applicaiton has been generated for new Fire NOC.</td><td>Y</td></tr><tr><td>financialyear</td><td>varchar</td><td>Fire NOC applicable for financial year.</td><td>Y</td></tr><tr><td>issueddate</td><td>int</td><td>License issued Date of the Fire NOC as epoch. 2. Application approval date.</td><td>v</td></tr><tr><td>validfrom</td><td>int</td><td>Date from when Fire NOC is valid as epoch</td><td>Y</td></tr><tr><td>validto</td><td>int</td><td>Expiry Date of the Fire NOC as epoch</td><td>Y</td></tr><tr><td>action</td><td>varchar</td><td>Workflow action on the application in certain</td><td>Y</td></tr><tr><td>channel</td><td>varchar</td><td>channel name</td><td>Y</td></tr><tr><td>noofbuildings</td><td>varchar</td><td>the attributestore value as string like single or multiple to denotes the number of buiding</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>Y</td></tr><tr><td>additionaldetail</td><td>jsonb</td><td>Json object to capture any extra information which is not accommodated in the model</td><td>N</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>propertyid</td><td>varchar</td><td>property id of building</td><td>N</td></tr><tr><td>status</td><td>varchar</td><td>firenoc application status</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                                       |
| ----------------- | ----------------------------------------------------- |
| uuid (PK)         | FireNOCs.\*.fireNOCDetails.id                         |
| firenocuuid (FK)  | FireNOCs.\*.id                                        |
| applicationnumber | FireNOCs.\*.fireNOCDetails.applicationNumber          |
| firenoctype       | FireNOCs.\*.fireNOCDetails.fireNOCType                |
| firestationid     | FireNOCs.\*.fireNOCDetails.firestationId              |
| applicationdate   | FireNOCs.\*.fireNOCDetails.applicationDate            |
| financialyear     | FireNOCs.\*.fireNOCDetails.financialYear              |
| issueddate        | FireNOCs.\*.fireNOCDetails.issuedDate                 |
| validfrom         | FireNOCs.\*.fireNOCDetails.validFrom                  |
| validto           | FireNOCs.\*.fireNOCDetails.validTo                    |
| action            | FireNOCs.\*.fireNOCDetails.action                     |
| channel           | FireNOCs.\*.fireNOCDetails.channel                    |
| noofbuildings     | FireNOCs.\*.fireNOCDetails.noOfBuildings              |
| tenantid          | FireNOCs.\*.fireNOCDetails.tenantId                   |
| additionaldetail  | FireNOCs.\*.fireNOCDetails.additionalDetail           |
| createdby         | FireNOCs.\*.auditDetails.createdBy                    |
| lastmodifiedby    | FireNOCs.\*.auditDetails.lastModifiedBy               |
| createdtime       | FireNOCs.\*.auditDetails.createdTime                  |
| lastmodifiedtime  | FireNOCs.\*.auditDetails.lastModifiedTime             |
| propertyid        | FireNOCs.\*.fireNOCDetails.propertyDetails.propertyid |
| status            | FireNOCs.\*.fireNOCDetails.status                     |
| {% endtab %}      |                                                       |
| {% endtabs %}     |                                                       |

### eg\_fn\_firenoc

{% tabs %}
{% tab title="Description" %}
This entity captures the fire NOC details.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="169">Data Type</th><th width="295">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>Y</td></tr><tr><td>firenocnumber</td><td>varchar</td><td>Unique Fire NOC Number of the Fire NOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.</td><td>Y</td></tr><tr><td>provisionfirenocnumber</td><td>varchar</td><td>Unique Fire NOC Number of the Provision Fire NOC number that will be used for linking provision fire NOC number with new fire NOC number. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.</td><td>N</td></tr><tr><td>oldfirenocnumber</td><td>varchar</td><td>Unique Old License Number of the Fire NOC. This is unique in system for a tenant. This is mandatory for legacy license(DataEntry).</td><td>N</td></tr><tr><td>dateofapplied</td><td>varchar</td><td>Applied Date of the fire NOC as epoch</td><td>Y</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name         | Mapping Details                           |
| ---------------------- | ----------------------------------------- |
| uuid (PK)              | FireNOCs.\*.id                            |
| tenantidT              | FireNOCs.\*.tenantId                      |
| firenocnumber          | FireNOCs.\*.firenocnumber                 |
| provisionfirenocnumber | FireNOCs.\*.provisionfirenocnumber        |
| oldfirenocnumber       | FireNOCs.\*.oldfirenocnumber              |
| dateofapplied          | FireNOCs.\*.dateofapplied                 |
| createdby              | FireNOCs.\*.auditDetails.createdBy        |
| lastmodifiedby         | FireNOCs.\*.auditDetails.lastModifiedBy   |
| createdtime            | FireNOCs.\*.auditDetails.createdTime      |
| lastmodifiedtime       | FireNOCs.\*.auditDetails.lastModifiedTime |
| {% endtab %}           |                                           |
| {% endtabs %}          |                                           |

### eg\_fn\_address

{% tabs %}
{% tab title="Description" %}
This entity captures the address details of the Fire NOC applicant.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="174">Data Type</th><th width="264">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique Identifier of the tenant to which user primarily belongs</td><td>Y</td></tr><tr><td>doorno</td><td>varchar</td><td>House number or door number of the building of user</td><td>Y</td></tr><tr><td>latitude</td><td>int</td><td>The latitude location details of the user address</td><td>N</td></tr><tr><td>longitude</td><td>int</td><td>The longitude location details of the user address</td><td>N</td></tr><tr><td>buildingname</td><td>varchar</td><td>Name of the building</td><td>Y</td></tr><tr><td>addressid</td><td>varchar</td><td>System generated id for the address</td><td>Y</td></tr><tr><td>addressnumber</td><td>varchar</td><td>House, Door, Building number in the address</td><td>Y</td></tr><tr><td>type</td><td>varchar</td><td>address type</td><td>Y</td></tr><tr><td>addressline1</td><td>varchar</td><td>Apartment, Block, Street of the address</td><td>N</td></tr><tr><td>addressline2</td><td>varchar</td><td>Locality, Area, Zone, Ward of the address</td><td>N</td></tr><tr><td>landmark</td><td>varchar</td><td>Additional location detail to help find the address of user</td><td>N</td></tr><tr><td>street</td><td>varchar</td><td>Street name</td><td>Y</td></tr><tr><td>city</td><td>varchar</td><td>City of the address. It can be representated by the tenantid</td><td>N</td></tr><tr><td>locality</td><td>varchar</td><td>Locality of bulding</td><td>Y</td></tr><tr><td>pincode</td><td>varchar</td><td>PIN code of the address. Indian pincodes will usually be all numbers.</td><td>N</td></tr><tr><td>detail</td><td>varchar</td><td>more address detail as may be needed</td><td>N</td></tr><tr><td><mark style="background-color:green;">firenocdetailsuuid (FK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC Details (UUID)</td><td>Y</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name          | Mapping Details                                                  |
| ----------------------- | ---------------------------------------------------------------- |
| uuid (PK)T              | FireNOCs.\*.fireNOCDetails.propertyDetails.address.id            |
| tenantid                | FireNOCs.\*.fireNOCDetails.propertyDetails.address.tenantId      |
| doorno                  | FireNOCs.\*.fireNOCDetails.propertyDetails.address.doorNo        |
| latitude                | FireNOCs.\*.fireNOCDetails.propertyDetails.address.latitude      |
| longitude               | FireNOCs.\*.fireNOCDetails.propertyDetails.address.longitude     |
| buildingname            | FireNOCs.\*.fireNOCDetails.propertyDetails.address.buildingName  |
| addressid               | FireNOCs.\*.fireNOCDetails.propertyDetails.address.addressId     |
| addressnumber           | FireNOCs.\*.fireNOCDetails.propertyDetails.address.addressNumber |
| type                    | FireNOCs.\*.fireNOCDetails.propertyDetails.address.type          |
| addressline1            | FireNOCs.\*.fireNOCDetails.propertyDetails.address.addressline1  |
| addressline2            | FireNOCs.\*.fireNOCDetails.propertyDetails.address.addressline1  |
| landmark                | FireNOCs.\*.fireNOCDetails.propertyDetails.address.landmark      |
| street                  | FireNOCs.\*.fireNOCDetails.propertyDetails.address.street        |
| city                    | FireNOCs.\*.fireNOCDetails.propertyDetails.address.city          |
| locality                | FireNOCs.\*.fireNOCDetails.propertyDetails.address.locality.code |
| pincode                 | FireNOCs.\*.fireNOCDetails.propertyDetails.address.pincode       |
| detail                  | FireNOCs.\*.fireNOCDetails.propertyDetails.address.detail        |
| firenocdetailsuuid (FK) | FireNOCs.\*.fireNOCDetails.id                                    |
| createdby               | FireNOCs.\*.auditDetails.createdBy                               |
| lastmodifiedby          | FireNOCs.\*.auditDetails.lastModifiedBy                          |
| createdtime             | FireNOCs.\*.auditDetails.createdTime                             |
| lastmodifiedtime        | FireNOCs.\*.auditDetails.lastModifiedTime                        |
| {% endtab %}            |                                                                  |
| {% endtabs %}           |                                                                  |

### eg\_fn\_buidlings

{% tabs %}
{% tab title="Description" %}
This entity captures the various attribute details of the building for which the NOC is applied.&#x20;
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th width="167">Data Type</th><th width="259">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">uuid (PK)</mark></td><td>varchar</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td><mark style="background-color:green;">firenocdetailsuuid (FK)</mark></td><td>varchar</td><td>Unique Identifier of the Fire FireNOC Details (UUID)</td><td>Y</td></tr><tr><td>tenantid</td><td>varchar</td><td>Unique identifier for a tenant to which user primarily belongs</td><td>Y</td></tr><tr><td>name</td><td>varchar</td><td>name of building</td><td>Y</td></tr><tr><td>usagetype</td><td>varchar</td><td>building usage type</td><td>Y</td></tr><tr><td>createdby</td><td>varchar</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>varchar</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>int</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>int</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>active</td><td>boolean</td><td>boolean atribute to mark the details active/inactive</td><td></td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name          | Mapping Details                                                                             |
| ----------------------- | ------------------------------------------------------------------------------------------- |
| uuid (PK)               | FireNOCs.\*.fireNOCDetails.buildings.\*.id                                                  |
| firenocdetailsuuid (FK) | FireNOCs\[\*]\[?({id} in @.fireNOCDetails.buildings\[\*].id)].fireNOCDetails.id             |
| tenantid                | FireNOCs.\*.fireNOCDetails.buildings.\*.tenantId                                            |
| name                    | FireNOCs.\*.fireNOCDetails.buildings.\*.name                                                |
| usagetype               | FireNOCs.\*.fireNOCDetails.buildings.\*.usageType                                           |
| createdby               | FireNOCs\[\*]\[?({id} in @.fireNOCDetails.buildings\[\*].id)].auditDetails.createdBy        |
| lastmodifiedby          | FireNOCs\[\*]\[?({id} in @.fireNOCDetails.buildings\[\*].id)].auditDetails.lastModifiedBy   |
| createdtime             | FireNOCs\[\*]\[?({id} in @.fireNOCDetails.buildings\[\*].id)].auditDetails.createdTime      |
| lastmodifiedtime        | FireNOCs\[\*]\[?({id} in @.fireNOCDetails.buildings\[\*].id)].auditDetails.lastModifiedTime |
| active                  |                                                                                             |
| {% endtab %}            |                                                                                             |
| {% endtabs %}           |                                                                                             |

## Mapping Constructs

![](/files/4Ch7LJVbcMk5utEOKnTi)

[![Creative Commons License](https://i.creativecommons.org/l/by/4.0/80x15.png)](http://creativecommons.org/licenses/by/4.0/)All content on this page by [eGov Foundation ](https://egov.org.in/)is licensed under a [Creative Commons Attribution 4.0 International License](http://creativecommons.org/licenses/by/4.0/).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://specs.digit.org/archived-docs/digit-urban-service-specs/fire-noc-service/fire-noc-data-model.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.