# Online Building Plan Approval Data Model

The module is used to apply for Building Plan Approval, Building Plan Occupancy Certificate, DCR Plan Scrutiny and Permits.

## OBPS Services Entity Details

### bpa-services

* [eg\_bpa\_buildingplan](#eg_bpa_buildingplan)
* [eg\_bpa\_auditdetails](#eg_bpa_auditdetails)
* [eg\_bpa\_document](#eg_bpa_document)

### land-services

* [eg\_land\_landInfo](#eg_land_landinfo)
* [eg\_land\_Address](#eg_land_address)
* [eg\_land\_GeoLocation](#eg_land_geolocation)
* [eg\_land\_ownerInfo](#eg_land_ownerinfo)
* [eg\_land\_institution](#eg_land_institution)
* [eg\_land\_document](#eg_land_document)
* [eg\_land\_unit](#eg_land_unit)
* [eg\_land\_auditdetails](#eg_land_auditdetails)
* [eg\_land\_owner\_auditdetails](#eg_land_owner_auditdetails)
* [eg\_land\_institution\_auditdetails](#eg_land_institution_auditdetails)
* [eg\_land\_unit\_auditdetails](#eg_land_unit_auditdetails)
* [eg\_land\_address\_auditdetails](#eg_land_address_auditdetails)
* [eg\_land\_geolocation\_auditdetails](#eg_land_geolocation_auditdetails)

### noc-services

* [eg\_noc](#eg_noc)
* [eg\_noc\_auditdetails](#eg_noc_auditdetails)
* [eg\_noc\_document](#eg_noc_document)

## Data Constructs

### eg\_bpa\_buildingplan

{% tabs %}
{% tab title="Description" %}
Stores primary information like application number, EDCR number, date etc.. for the plot/site building permit and occupancy certificate applications.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="281">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying (256)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>applicationno</td><td>character varying (64)</td><td>Unique identifier to identify an application and shared with applicant</td><td>Y</td></tr><tr><td>tenantid</td><td>character varying (256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>edcrnumber</td><td>character varying (64)</td><td>Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied</td><td>Y</td></tr><tr><td>status</td><td>character varying (64)</td><td>To know status of the application</td><td>Y</td></tr><tr><td>landid</td><td>character varying (256)</td><td>Unique identifier for land details</td><td>Y</td></tr><tr><td>additionaldetails</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>character varying (64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying (64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td></td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>approvalno</td><td>character varying (64)</td><td>Unique identifier for the application approved</td><td>Y</td></tr><tr><td>approvaldate</td><td>bigint</td><td>epoch of the time object of application approved</td><td>Y</td></tr><tr><td>applicationdate</td><td>bigint</td><td>epoch of the time object of application created</td><td>Y</td></tr><tr><td>businessservice</td><td>character varying (64)</td><td>name of the business service</td><td>Y</td></tr><tr><td>accountid</td><td>character varying (256)</td><td>uuid of the user who created the application</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details       |
| ----------------- | --------------------- |
| id (PK)           | BPA.id                |
| applicationno     | BPA.applicationno     |
| tenantid          | BPA.tenantid          |
| edcrnumber        | BPA.edcrnumber        |
| status            | BPA.status            |
| landid            | BPA.landid            |
| additionaldetails | BPA.additionaldetails |
| createdby         | BPA.createdby         |
| lastmodifiedby    | BPA.lastmodifiedby    |
| lastmodifiedtime  | BPA.lastmodifiedtime  |
| createdtime       | BPA.createdtime       |
| approvalno        | BPA.approvalno        |
| approvaldate      | BPA.approvaldate      |
| applicationdate   | BPA.applicationdate   |
| businessservice   | BPA.businessservice   |
| accountid         | BPA.accountid         |
| {% endtab %}      |                       |
| {% endtabs %}     |                       |

### eg\_bpa\_auditdetails

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th width="178">Attribute Name</th><th>Data Type</th><th width="274">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td>id</td><td>character varying (256)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>applicationno</td><td>character varying (64)</td><td>Unique identifier to identify an application and shared with applicant</td><td>Y</td></tr><tr><td>tenantid</td><td>character varying (256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>edcrnumber</td><td>character varying (64)</td><td>Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied</td><td>Y</td></tr><tr><td>status</td><td>character varying (64)</td><td>To know status of the application</td><td>Y</td></tr><tr><td>landid</td><td>character varying (256)</td><td>Unique identifier for land details</td><td>Y</td></tr><tr><td>additionaldetails</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>character varying (64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying (64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td></td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr><tr><td>approvalno</td><td>character varying (64)</td><td>Unique identifier for the application approved</td><td>Y</td></tr><tr><td>approvaldate</td><td>bigint</td><td>epoch of the time object of application approved</td><td>Y</td></tr><tr><td>applicationdate</td><td>bigint</td><td>epoch of the time object of application created</td><td>Y</td></tr><tr><td>businessservice</td><td>character varying (64)</td><td>name of the business service</td><td>Y</td></tr><tr><td>accountid</td><td>character varying (256)</td><td>uuid of the user who created the application</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details       |
| ----------------- | --------------------- |
| id                | BPA.id                |
| applicationno     | BPA.applicationno     |
| tenantid          | BPA.tenantid          |
| edcrnumber        | BPA.edcrnumber        |
| status            | BPA.status            |
| landid            | BPA.landid            |
| additionaldetails | BPA.additionaldetails |
| createdby         | BPA.createdby         |
| lastmodifiedby    | BPA.lastmodifiedby    |
| createdtime       | BPA.createdtime       |
| lastmodifiedtime  | BPA.lastmodifiedtime  |
| approvalno        | BPA.approvalno        |
| approvaldate      | BPA.approvaldate      |
| applicationdate   | BPA.applicationdate   |
| businessservice   | BPA.businessservice   |
| accountid         | BPA.accountid         |
| {% endtab %}      |                       |
| {% endtabs %}     |                       |

### eg\_bpa\_document

{% tabs %}
{% tab title="Description" %}
Stores BPA application uploaded document details
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="268">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying (64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>documenttype</td><td>character varying (64)</td><td>Name of the document type</td><td>Y</td></tr><tr><td>filestoreid</td><td>character varying (64)</td><td>The filestore UUID</td><td>Y</td></tr><tr><td>documentuid</td><td>character varying (64)</td><td>Unique identifier of document</td><td>N</td></tr><tr><td>buildingplanid (FK)</td><td>character varying (64)</td><td>The ID of building plan</td><td>Y</td></tr><tr><td>additionaldetails</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>character varying (64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying (64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name      | Mapping Details                    |
| ------------------- | ---------------------------------- |
| id (PK)             | BPA.documents.\*.id                |
| documenttype        | BPA.documents.\*.documenttype      |
| filestoreid         | BPA.documents.\*.filestoreid       |
| documentuid         | BPA.documents.\*.documentuid       |
| buildingplanid (FK) | BPA.documents.\*.buildingplanid    |
| additionaldetails   | BPA.documents.\*.additionaldetails |
| createdby           | BPA.documents.\*.createdby         |
| lastmodifiedby      | BPA.documents.\*.lastmodifiedby    |
| createdtime         | BPA.documents.\*.createdtime       |
| lastmodifiedtime    | BPA.documents.\*.lastmodifiedtime  |
| {% endtab %}        |                                    |
| {% endtabs %}       |                                    |

### eg\_land\_landInfo

{% tabs %}
{% tab title="Description" %}
Stores land details information.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="277">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>landUid</td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>landUniqueRegNo</td><td>character varying(64)</td><td>The unique registration number to identify the land record</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>status</td><td>character varying(64)</td><td>Status of application</td><td>N</td></tr><tr><td>ownershipCategory</td><td>character varying(64)</td><td>The land ownership category</td><td>Y</td></tr><tr><td>source</td><td>character varying(64)</td><td>The source of land record</td><td>Y</td></tr><tr><td>channel</td><td>character varying(64)</td><td>From which channel the application is submitted</td><td>Y</td></tr><tr><td>additionalDetails</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>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details            |
| ----------------- | -------------------------- |
| id (PK)           | landInfo.id                |
| landUid           | landInfo.landUid           |
| landUniqueRegNo   | landInfo.landUniqueRegNo   |
| tenantId          | landInfo.tenantId          |
| status            | landInfo.status            |
| ownershipCategory | landInfo.ownershipCategory |
| source            | landInfo.source            |
| channel           | landInfo.channel           |
| additionalDetails | landInfo.additionalDetails |
| createdby         | landInfo.createdby         |
| lastmodifiedby    | landInfo.lastmodifiedby    |
| createdtime       | landInfo.createdtime       |
| lastmodifiedtime  | landInfo.lastmodifiedtime  |
| {% endtab %}      |                            |
| {% endtabs %}     |                            |

### eg\_land\_address

{% tabs %}
{% tab title="Description" %}
It stores land/plot/site address information.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="278">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>doorNo</td><td>character varying(64)</td><td>The door numbers of plot/land</td><td>N</td></tr><tr><td>plotNo</td><td>character varying(64)</td><td>The plot number of plot</td><td>N</td></tr><tr><td>landmark</td><td>character varying(64)</td><td>The nearest place to identify the plot</td><td>N</td></tr><tr><td>city</td><td>character varying(64)</td><td>The city name where the plot is located</td><td>Y</td></tr><tr><td>district</td><td>character varying(64)</td><td>The district name where land is located</td><td>N</td></tr><tr><td>region</td><td>character varying(64)</td><td>The region name with respective of plot located</td><td>N</td></tr><tr><td>state</td><td>character varying(64)</td><td>The state name where land/plot is located</td><td>Y</td></tr><tr><td>country</td><td>character varying(64)</td><td>Name of the country where land is located</td><td>Y</td></tr><tr><td>locality</td><td>character varying(64)</td><td>The locality name of the plot/land</td><td>Y</td></tr><tr><td>pincode</td><td>character varying(64)</td><td>The pincode of land/plot</td><td>Y</td></tr><tr><td>additionDetails</td><td>character varying(64)</td><td>Json object to capture any extra information which is not accommodated in the model</td><td>N</td></tr><tr><td>buildingName</td><td>character varying(64)</td><td>Name of the building name</td><td>N</td></tr><tr><td>street</td><td>character varying(64)</td><td>Street name of the plot where located</td><td>N</td></tr><tr><td>landInfoId (FK)</td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name   | Mapping Details                   |
| ---------------- | --------------------------------- |
| id (PK)          | landInfo.address.id               |
| tenantId         | landInfo.address.tenantId         |
| doorNo           | landInfo.address.doorNo           |
| plotNo           | landInfo.address.plotNo           |
| landmark         | landInfo.address.landmark         |
| city             | landInfo.address.city             |
| district         | landInfo.address.district         |
| region           | landInfo.address.region           |
| state            | landInfo.address.state            |
| country          | landInfo.address.country          |
| locality         | landInfo.address.locality         |
| pincode          | landInfo.address.pincode          |
| additionDetails  | landInfo.address.additionDetails  |
| buildingName     | landInfo.address.buildingName     |
| street           | landInfo.address.street           |
| landInfoId (FK)  | landInfo.address.landInfoId       |
| createdby        | landInfo.address.createdby        |
| lastmodifiedby   | landInfo.address.lastmodifiedby   |
| createdtime      | landInfo.address.createdtime      |
| lastmodifiedtime | landInfo.address.lastmodifiedtime |
| {% endtab %}     |                                   |
| {% endtabs %}    |                                   |

### eg\_land\_geolocation

{% tabs %}
{% tab title="Description" %}
Stores land geo-location information.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="255">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>latitude</td><td>double precision</td><td>The latitude value of the plot/land</td><td>Y</td></tr><tr><td>longitude</td><td>double precision</td><td>The longtitude value of the land/plot</td><td>Y</td></tr><tr><td>addressId (FK)</td><td>character varying(64)</td><td>The addressid is the foreignkey reference, it contain ID value of the land address</td><td>Y</td></tr><tr><td>additionalDetails</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>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                                |
| ----------------- | ---------------------------------------------- |
| id (PK)           | landInfo.address.geoLocation.id                |
| latitude          | landInfo.address.geoLocation.latitude          |
| longitude         | landInfo.address.geoLocation.longitude         |
| addressId (FK)    | landInfo.address.geoLocation.addressId         |
| additionalDetails | landInfo.address.geoLocation.additionalDetails |
| createdby         | landInfo.address.geoLocation.createdby         |
| lastmodifiedby    | landInfo.address.geoLocation.lastmodifiedby    |
| createdtime       | landInfo.address.geoLocation.createdtime       |
| lastmodifiedtime  | landInfo.address.geoLocation.lastmodifiedtime  |
| {% endtab %}      |                                                |
| {% endtabs %}     |                                                |

### eg\_land\_ownerInfo

{% tabs %}
{% tab title="Description" %}
Stores landowner details.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="260">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td>id</td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>uuid</td><td>character varying(64)</td><td>The UUID is the unique key of user. It contains user UUID to identify which user</td><td>Y</td></tr><tr><td>isprimaryowner</td><td>boolean</td><td>Whether the owner is primary owner who own land</td><td>Y</td></tr><tr><td>ownershippercentage</td><td>double precision</td><td>If land have multiple owners, then each own how much percentage.</td><td>Y</td></tr><tr><td>institutionId</td><td>character varying(64)</td><td></td><td>N</td></tr><tr><td>additionalDetails</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>landInfoId</td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>relationship</td><td>character varying(64)</td><td>The relationship with primary owner</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name      | Mapping Details                        |
| ------------------- | -------------------------------------- |
| id                  | landInfo.owners.\*.id                  |
| uuid                | landInfo.owners.\*.uuid                |
| isprimaryowner      | landInfo.owners.\*.isprimaryowner      |
| ownershippercentage | landInfo.owners.\*.ownershippercentage |
| institutionId       | landInfo.owners.\*.institutionId       |
| additionalDetails   | landInfo.owners.\*.additionalDetails   |
| landInfoId          | landInfo.owners.\*.landInfoId          |
| relationship        | landInfo.owners.\*.relationship        |
| createdby           | landInfo.owners.\*.createdby           |
| lastmodifiedby      | landInfo.owners.\*.lastmodifiedby      |
| createdtime         | landInfo.owners.\*.createdtime         |
| lastmodifiedtime    | landInfo.owners.\*.lastmodifiedtime    |
| {% endtab %}        |                                        |
| {% endtabs %}       |                                        |

### eg\_land\_institution

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="269">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>type</td><td>character varying(64)</td><td>type</td><td>N</td></tr><tr><td>designation</td><td>character varying(256)</td><td>Designation name</td><td>N</td></tr><tr><td>nameOfAuthorizedPerson</td><td>character varying(256)</td><td>Name of the authorized person from institute</td><td>N</td></tr><tr><td>additionalDetails</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>landInfoId (FK)</td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name         | Mapping Details                             |
| ---------------------- | ------------------------------------------- |
| id (PK)                | landInfo.institution.id                     |
| tenantId               | landInfo.institution.tenantId               |
| type                   | landInfo.institution.type                   |
| designation            | landInfo.institution.designation            |
| nameOfAuthorizedPerson | landInfo.institution.nameOfAuthorizedPerson |
| additionalDetails      | landInfo.institution.additionalDetails      |
| landInfoId (FK)        | landInfo.institution.landInfoId             |
| createdby              | landInfo.institution.createdby              |
| lastmodifiedby         | landInfo.institution.lastmodifiedby         |
| createdtime            | landInfo.institution.createdtime            |
| lastmodifiedtime       | landInfo.institution.lastmodifiedtime       |
| {% endtab %}           |                                             |
| {% endtabs %}          |                                             |

### eg\_land\_document

{% tabs %}
{% tab title="Description" %}
Stores land-related attached documents.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="243">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>documentType</td><td>character varying(256)</td><td>Name of the document type</td><td>Y</td></tr><tr><td>fileStoreId</td><td>character varying(256)</td><td>The filestoreId of document</td><td>Y</td></tr><tr><td>documentUid</td><td>character varying(256)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>additionalDetails</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><mark style="background-color:green;">landInfoId (FK)</mark></td><td>character varying(64)</td><td>REFERENCES eg_land_landInfo (id)</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                         |
| ----------------- | --------------------------------------- |
| id (PK)           | landInfo.documents.\*.id                |
| documentType      | landInfo.documents.\*.documentType      |
| fileStoreId       | landInfo.documents.\*.fileStoreId       |
| documentUid       | landInfo.documents.\*.documentUid       |
| additionalDetails | landInfo.documents.\*.additionalDetails |
| landInfoId (FK)   | landInfo.documents.\*.landInfoId        |
| createdby         | landInfo.documents.\*.createdby         |
| lastmodifiedby    | landInfo.documents.\*.lastmodifiedby    |
| createdtime       | landInfo.documents.\*.createdtime       |
| lastmodifiedtime  | landInfo.documents.\*.lastmodifiedtime  |
| {% endtab %}      |                                         |
| {% endtabs %}     |                                         |

### eg\_land\_unit

{% tabs %}
{% tab title="Description" %}
Stores building information in the land/plot.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th width="202">Attribute Name</th><th>Data Type</th><th width="256">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>floorNo</td><td>character varying(64)</td><td>The floor no value</td><td>Y</td></tr><tr><td>unitType</td><td>character varying(256)</td><td>The unit type</td><td>Y</td></tr><tr><td>usageCategory</td><td>character varying(64)</td><td>Name of the usage</td><td>N</td></tr><tr><td>occupancyType</td><td>character varying(64)</td><td>Name of the occupancy building occupied</td><td>Y</td></tr><tr><td>occupancyDate</td><td>bigint</td><td>As on date which occupancy, the building having</td><td>N</td></tr><tr><td>additionalDetails</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><mark style="background-color:green;">landInfoId (FK)</mark></td><td>character varying(64)</td><td>REFERENCES eg_land_landInfo (id)</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                    |
| ----------------- | ---------------------------------- |
| id (PK)           | landInfo.unit.\*.id                |
| tenantId          | landInfo.unit.\*.tenantId          |
| floorNo           | landInfo.unit.\*.floorNo           |
| unitType          | landInfo.unit.\*.unitType          |
| usageCategory     | landInfo.unit.\*.usageCategory     |
| occupancyType     | landInfo.unit.\*.occupancyType     |
| occupancyDate     | landInfo.unit.\*.occupancyDate     |
| additionalDetails | landInfo.unit.\*.additionalDetails |
| landInfoId (FK)   | landInfo.unit.\*.landInfoId        |
| createdby         | landInfo.unit.\*.createdby         |
| lastmodifiedby    | landInfo.unit.\*.lastmodifiedby    |
| createdtime       | landInfo.unit.\*.createdtime       |
| lastmodifiedtime  | landInfo.unit.\*.lastmodifiedtime  |
| {% endtab %}      |                                    |
| {% endtabs %}     |                                    |

### eg\_land\_auditdetails

{% tabs %}
{% tab title="Description" %}
Stores land information audit details.
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="242">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(256)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>landUid</td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>landUniqueRegNo</td><td>character varying(256)</td><td>The unique registration number to identify the land record</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(64)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>status</td><td>character varying(64)</td><td>Status of application</td><td>N</td></tr><tr><td>ownershipcategory</td><td>character varying(64)</td><td>The land ownership category</td><td>Y</td></tr><tr><td>source</td><td>character varying(64)</td><td>The source of land record</td><td>Y</td></tr><tr><td>channel</td><td>character varying(64)</td><td>From which channel the application is submitted</td><td>Y</td></tr><tr><td>additionaldetails</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>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details            |
| ----------------- | -------------------------- |
| id (PK)           | landInfo.id                |
| landUid           | landInfo.landUid           |
| landUniqueRegNo   | landInfo.landUniqueRegNo   |
| tenantId          | landInfo.tenantId          |
| status            | landInfo.status            |
| ownershipcategory | landInfo.ownershipcategory |
| source            | landInfo.source            |
| channel           | landInfo.channel           |
| additionaldetails | landInfo.additionaldetails |
| createdby         | landInfo.createdby         |
| lastmodifiedby    | landInfo.lastmodifiedby    |
| createdtime       | landInfo.createdtime       |
| lastmodifiedtime  | landInfo.lastmodifiedtime  |
| {% endtab %}      |                            |
| {% endtabs %}     |                            |

### eg\_land\_owner\_auditdetails

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th width="201">Attribute Name</th><th>Data Type</th><th width="254">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>uuid</td><td>character varying(64)</td><td>The UUID is the unique key of user. It contains user UUID to identify which user</td><td>Y</td></tr><tr><td>isprimaryowner</td><td>boolean</td><td>Whether the owner is primary owner who own land</td><td>Y</td></tr><tr><td>ownershippercentage</td><td>double precision</td><td>If land have multiple owners, then each own how much percentage.</td><td>Y</td></tr><tr><td>institutionId</td><td>character varying(64)</td><td></td><td>N</td></tr><tr><td>additionalDetails</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>landInfoId</td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>relationship</td><td>character varying(64)</td><td>The relationship with primary owner</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name      | Mapping Details                        |
| ------------------- | -------------------------------------- |
| id (PK)             | landInfo.owners.\*.id                  |
| uuid                | landInfo.owners.\*.uuid                |
| isprimaryowner      | landInfo.owners.\*.isprimaryowner      |
| ownershippercentage | landInfo.owners.\*.ownershippercentage |
| institutionId       | landInfo.owners.\*.institutionId       |
| additionalDetails   | landInfo.owners.\*.additionalDetails   |
| landInfoId          | landInfo.owners.\*.landInfoId          |
| relationship        | landInfo.owners.\*.relationship        |
| createdby           | landInfo.owners.\*.createdby           |
| lastmodifiedby      | landInfo.owners.\*.lastmodifiedby      |
| createdtime         | landInfo.owners.\*.createdtime         |
| lastmodifiedtime    | landInfo.owners.\*.lastmodifiedtime    |
| {% endtab %}        |                                        |
| {% endtabs %}       |                                        |

### eg\_land\_institution\_auditdetails

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="244">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>type</td><td>character varying(64)</td><td>type</td><td>N</td></tr><tr><td>designation</td><td>character varying(256)</td><td>Designation name</td><td>N</td></tr><tr><td>nameOfAuthorizedPerson</td><td>character varying(256)</td><td>Name of the authorized person from institute</td><td>N</td></tr><tr><td>additionalDetails</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>landInfoId</td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name         | Mapping Details                             |
| ---------------------- | ------------------------------------------- |
| id (PK)                | landInfo.institution.id                     |
| tenantId               | landInfo.institution.tenantId               |
| type                   | landInfo.institution.type                   |
| designation            | landInfo.institution.designation            |
| nameOfAuthorizedPerson | landInfo.institution.nameOfAuthorizedPerson |
| additionalDetails      | landInfo.institution.additionalDetails      |
| landInfoId             | landInfo.institution.landInfoId             |
| createdby              | landInfo.institution.createdby              |
| lastmodifiedby         | landInfo.institution.lastmodifiedby         |
| createdtime            | landInfo.institution.createdtime            |
| lastmodifiedtime       | landInfo.institution.lastmodifiedtime       |
| {% endtab %}           |                                             |
| {% endtabs %}          |                                             |

### eg\_land\_unit\_auditdetails

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

| Attribute Name                                     | Data Type              | Definition                                                                          | Mandatory (Y/N) |
| -------------------------------------------------- | ---------------------- | ----------------------------------------------------------------------------------- | --------------- |
| <mark style="background-color:red;">id (PK)</mark> | character varying(64)  | The system generated unique id(UUID)                                                | Y               |
| tenantId                                           | character varying(256) | TenantID to identify application submitted for the which city                       | Y               |
| floorNo                                            | character varying(64)  | The floor no value                                                                  | Y               |
| unitType                                           | character varying(256) | The unit type                                                                       | Y               |
| usageCategory                                      | character varying(64)  | Name of the usage                                                                   | N               |
| occupancyType                                      | character varying(64)  | Name of the occupancy building occupied                                             | Y               |
| occupancyDate                                      | bigint                 | As on date which occupancy, the building having                                     | N               |
| additionalDetails                                  | JSONB                  | Json object to capture any extra information which is not accommodated in the model | N               |
| landInfoId                                         | character varying(64)  | REFERENCES eg\_land\_landInfo (id)                                                  | Y               |
| createdby                                          | character varying(64)  | username (preferred) or userid of the user that created the object                  | Y               |
| lastmodifiedby                                     | character varying(64)  | username (preferred) or userid of the user that last modified the object            | Y               |
| createdtime                                        | bigint                 | epoch of the time object is modified last                                           | Y               |
| lastmodifiedtime                                   | bigint                 | epoch of the time object is created                                                 | Y               |
| {% endtab %}                                       |                        |                                                                                     |                 |

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                    |
| ----------------- | ---------------------------------- |
| id (PK)           | landInfo.unit.\*.id                |
| tenantId          | landInfo.unit.\*.tenantId          |
| floorNo           | landInfo.unit.\*.floorNo           |
| unitType          | landInfo.unit.\*.unitType          |
| usageCategory     | landInfo.unit.\*.usageCategory     |
| occupancyType     | landInfo.unit.\*.occupancyType     |
| occupancyDate     | landInfo.unit.\*.occupancyDate     |
| additionalDetails | landInfo.unit.\*.additionalDetails |
| landInfoId        | landInfo.unit.\*.landInfoId        |
| createdby         | landInfo.unit.\*.createdby         |
| lastmodifiedby    | landInfo.unit.\*.lastmodifiedby    |
| createdtime       | landInfo.unit.\*.createdtime       |
| lastmodifiedtime  | landInfo.unit.\*.lastmodifiedtime  |
| {% endtab %}      |                                    |
| {% endtabs %}     |                                    |

### eg\_land\_address\_auditdetails

{% tabs %}
{% tab title="Description" %}
It stores audit details of land/plot/site address information
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="248">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>tenantId</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>doorNo</td><td>character varying(64)</td><td>The door numbers of plot/land</td><td>N</td></tr><tr><td>plotNo</td><td>character varying(64)</td><td>The plot number of plot</td><td>N</td></tr><tr><td>landmark</td><td>character varying(64)</td><td>The nearest place to identify the plot</td><td>N</td></tr><tr><td>city</td><td>character varying(64)</td><td>The city name where the plot is located</td><td>Y</td></tr><tr><td>district</td><td>character varying(64)</td><td>The district name of the city located</td><td>N</td></tr><tr><td>region</td><td>character varying(64)</td><td>The region name with respective of plot located</td><td>N</td></tr><tr><td>state</td><td>character varying(64)</td><td>The state name of city located</td><td>Y</td></tr><tr><td>country</td><td>character varying(64)</td><td>Name of the country</td><td>Y</td></tr><tr><td>locality</td><td>character varying(64)</td><td>The locality name of the plot/land</td><td>Y</td></tr><tr><td>pincode</td><td>character varying(64)</td><td>The pincode of land/plot</td><td>Y</td></tr><tr><td>additionDetails</td><td>character varying(64)</td><td>Json object to capture any extra information which is not accommodated in the model</td><td>N</td></tr><tr><td>buildingName</td><td>character varying(64)</td><td>Name of the building name</td><td>N</td></tr><tr><td>street</td><td>character varying(64)</td><td>Street name of the plot where located</td><td>N</td></tr><tr><td><mark style="background-color:green;">landInfoId (FK)</mark></td><td>character varying(64)</td><td>The landinfo id is foreign key reference to the landinfo</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name   | Mapping Details                   |
| ---------------- | --------------------------------- |
| id (PK)          | landInfo.address.id               |
| tenantId         | landInfo.address.tenantId         |
| doorNo           | landInfo.address.doorNo           |
| plotNo           | landInfo.address.plotNo           |
| landmark         | landInfo.address.landmark         |
| city             | landInfo.address.city             |
| district         | landInfo.address.district         |
| region           | landInfo.address.region           |
| state            | landInfo.address.state            |
| country          | landInfo.address.country          |
| locality         | landInfo.address.locality         |
| pincode          | landInfo.address.pincode          |
| additionDetails  | landInfo.address.additionDetails  |
| buildingName     | landInfo.address.buildingName     |
| street           | landInfo.address.street           |
| landInfoId (FK)  | landInfo.address.landInfoId       |
| createdby        | landInfo.address.createdby        |
| lastmodifiedby   | landInfo.address.lastmodifiedby   |
| createdtime      | landInfo.address.createdtime      |
| lastmodifiedtime | landInfo.address.lastmodifiedtime |
| {% endtab %}     |                                   |
| {% endtabs %}    |                                   |

### eg\_land\_geolocation\_auditdetails

{% tabs %}
{% tab title="Description" %}

{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="233">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(64)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>latitude</td><td>double precision</td><td>The latitude value of the plot/land</td><td>Y</td></tr><tr><td>longitude</td><td>double precision</td><td>The longtitude value of the land/plot</td><td>Y</td></tr><tr><td><mark style="background-color:green;">addressId (FK)</mark></td><td>character varying(64)</td><td>The addressid is the foreignkey reference, it contain ID value of the land address</td><td>Y</td></tr><tr><td>additionalDetails</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>character varying(64)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(64)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                                |
| ----------------- | ---------------------------------------------- |
| id (PK)           | landInfo.address.geoLocation.id                |
| latitude          | landInfo.address.geoLocation.latitude          |
| longitude         | landInfo.address.geoLocation.longitude         |
| addressId (FK)    | landInfo.address.geoLocation.addressId         |
| additionalDetails | landInfo.address.geoLocation.additionalDetails |
| createdby         | landInfo.address.geoLocation.createdby         |
| lastmodifiedby    | landInfo.address.geoLocation.lastmodifiedby    |
| createdtime       | landInfo.address.geoLocation.createdtime       |
| lastmodifiedtime  | landInfo.address.geoLocation.lastmodifiedtime  |
| {% endtab %}      |                                                |
| {% endtabs %}     |                                                |

### eg\_noc

{% tabs %}
{% tab title="Description" %}
Stores NOC applications information
{% endtab %}

{% tab title="Attributes" %}

| Attribute Name                                     | Data Type              | Definition                                                                          | Mandatory (Y/N) |
| -------------------------------------------------- | ---------------------- | ----------------------------------------------------------------------------------- | --------------- |
| <mark style="background-color:red;">id (PK)</mark> | character varying(256) | The system generated unique id(UUID)                                                | Y               |
| applicationno                                      | character varying(64)  | Unique identifier to identify an application and shared with applicant              | Y               |
| tenantid                                           | character varying(256) | TenantID to identify application submitted for the which city                       | Y               |
| status                                             |                        | To know status of the application                                                   | N               |
| landid                                             | character varying(256) | Unique identifier for land details                                                  | N               |
| additionaldetails                                  | jsonb                  | Json object to capture any extra information which is not accommodated in the model | N               |
| nocNo                                              | character varying(64)  | Unique identifier to identify an application after approval                         | Y               |
| applicationType                                    | character varying(64)  | The application type                                                                | Y               |
| nocType                                            | character varying(64)  | Type of NOC                                                                         | Y               |
| accountid                                          | character varying(256) | The UUID of user who created the application                                        | N               |
| source                                             | character varying(64)  | From which channel application is submitted                                         | Y               |
| sourcerefid                                        | character varying(256) | The application number of source application which initiated the NOC request        | Y               |
| applicationstatus                                  | character varying(64)  | To know status of the application                                                   | Y               |
| createdby                                          | character varying(256) | username (preferred) or userid of the user that created the object                  | Y               |
| lastmodifiedby                                     | character varying(256) | username (preferred) or userid of the user that last modified the object            | Y               |
| createdtime                                        | bigint                 | epoch of the time object is modified last                                           | Y               |
| lastmodifiedtime                                   | bigint                 | epoch of the time object is created                                                 | Y               |
| {% endtab %}                                       |                        |                                                                                     |                 |

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details       |
| ----------------- | --------------------- |
| id (PK)           | Noc.id                |
| applicationno     | Noc.applicationno     |
| tenantid          | Noc.tenantid          |
| status            | Noc.status            |
| landid            | Noc.landid            |
| additionaldetails | Noc.additionaldetails |
| nocNo             | Noc.nocNo             |
| applicationType   | Noc.applicationType   |
| nocType           | Noc.nocType           |
| accountid         | Noc.accountid         |
| source            | Noc.source            |
| sourcerefid       | Noc.sourcerefid       |
| applicationstatus | Noc.applicationstatus |
| createdby         | Noc.createdby         |
| lastmodifiedby    | Noc.lastmodifiedby    |
| createdtime       | Noc.createdtime       |
| lastmodifiedtime  | Noc.lastmodifiedtime  |
| {% endtab %}      |                       |
| {% endtabs %}     |                       |

### eg\_noc\_auditdetails

{% tabs %}
{% tab title="Description" %}
Stores NOC applications audit information
{% endtab %}

{% tab title="Attributes" %}

<table><thead><tr><th>Attribute Name</th><th>Data Type</th><th width="259">Definition</th><th>Mandatory (Y/N)</th></tr></thead><tbody><tr><td><mark style="background-color:red;">id (PK)</mark></td><td>character varying(256)</td><td>The system generated unique id(UUID)</td><td>Y</td></tr><tr><td>applicationno</td><td>character varying(64)</td><td>Unique identifier to identify an application and shared with applicant</td><td>Y</td></tr><tr><td>tenantid</td><td>character varying(256)</td><td>TenantID to identify application submitted for the which city</td><td>Y</td></tr><tr><td>status</td><td></td><td>To know status of the application</td><td>N</td></tr><tr><td>landid</td><td>character varying(256)</td><td>Unique identifier for land details</td><td>N</td></tr><tr><td>additionaldetails</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>nocNo</td><td>character varying(64)</td><td>Unique identifier to identify an application after approval</td><td>Y</td></tr><tr><td>applicationType</td><td>character varying(64)</td><td>The application type</td><td>Y</td></tr><tr><td>nocType</td><td>character varying(64)</td><td>Type of NOC</td><td>Y</td></tr><tr><td>accountid</td><td>character varying(256)</td><td>The UUID of user who created the application</td><td>N</td></tr><tr><td>source</td><td>character varying(64)</td><td>From which channel application is submitted</td><td>Y</td></tr><tr><td>sourcerefid</td><td>character varying(256)</td><td>The application number of source application which initiated the NOC request</td><td>Y</td></tr><tr><td>applicationstatus</td><td>character varying(64)</td><td>To know status of the application</td><td>Y</td></tr><tr><td>createdby</td><td>character varying(256)</td><td>username (preferred) or userid of the user that created the object</td><td>Y</td></tr><tr><td>lastmodifiedby</td><td>character varying(256)</td><td>username (preferred) or userid of the user that last modified the object</td><td>Y</td></tr><tr><td>createdtime</td><td>bigint</td><td>epoch of the time object is modified last</td><td>Y</td></tr><tr><td>lastmodifiedtime</td><td>bigint</td><td>epoch of the time object is created</td><td>Y</td></tr></tbody></table>
{% endtab %}

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details       |
| ----------------- | --------------------- |
| id (PK)           | Noc.id                |
| applicationno     | Noc.applicationno     |
| tenantid          | Noc.tenantid          |
| status            | Noc.status            |
| landid            | Noc.landid            |
| additionaldetails | Noc.additionaldetails |
| nocNo             | Noc.nocNo             |
| applicationType   | Noc.applicationType   |
| nocType           | Noc.nocType           |
| accountid         | Noc.accountid         |
| source            | Noc.source            |
| sourcerefid       | Noc.sourcerefid       |
| applicationstatus | Noc.applicationstatus |
| createdby         | Noc.createdby         |
| lastmodifiedby    | Noc.lastmodifiedby    |
| createdtime       | Noc.createdtime       |
| lastmodifiedtime  | Noc.lastmodifiedtime  |
| {% endtab %}      |                       |
| {% endtabs %}     |                       |

### eg\_noc\_document

{% tabs %}
{% tab title="Description" %}
Stores NOC attached documents information
{% endtab %}

{% tab title="Attributes" %}

| Attribute Name                                     | Data Type             | Definition                                                                          | Mandatory (Y/N) |
| -------------------------------------------------- | --------------------- | ----------------------------------------------------------------------------------- | --------------- |
| <mark style="background-color:red;">id (PK)</mark> | character varying(64) | The system generated unique id(UUID)                                                | Y               |
| documenttype                                       | character varying(64) | Name of the document type                                                           | Y               |
| filestoreid                                        | character varying(64) | The filestoreID of uploaded document                                                | Y               |
| documentuid                                        | character varying(64) | The system generated unique uuid                                                    | N               |
| nocid (FK)                                         | character varying(64) | The noc id is foreign key reference to the noc                                      | Y               |
| additionaldetails                                  | jsonb                 | Json object to capture any extra information which is not accommodated in the model | N               |
| createdby                                          | character varying(64) | username (preferred) or userid of the user that created the object                  | Y               |
| lastmodifiedby                                     | character varying(64) | username (preferred) or userid of the user that last modified the object            | Y               |
| createdtime                                        | bigint                | epoch of the time object is modified last                                           | Y               |
| lastmodifiedtime                                   | bigint                | epoch of the time object is created                                                 | Y               |
| {% endtab %}                                       |                       |                                                                                     |                 |

{% tab title="Mapping" %}

| Attribute Name    | Mapping Details                    |
| ----------------- | ---------------------------------- |
| id (PK)           | Noc.documents.\*.id                |
| documenttype      | Noc.documents.\*.documenttype      |
| filestoreid       | Noc.documents.\*.filestoreid       |
| documentuid       | Noc.documents.\*.documentuid       |
| nocid (FK)        | Noc.documents.\*.nocid             |
| additionaldetails | Noc.documents.\*.additionaldetails |
| createdby         | Noc.documents.\*.createdby         |
| lastmodifiedby    | Noc.documents.\*.lastmodifiedby    |
| createdtime       | Noc.documents.\*.createdtime       |
| lastmodifiedtime  | Noc.documents.\*.lastmodifiedtime  |
| {% endtab %}      |                                    |
| {% endtabs %}     |                                    |

## Mapping Constructs

![](/files/NBOvZ33opNbZ7CHYA36X)

[![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/online-building-plan-approval-service/online-building-plan-approval-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.