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
land-services
noc-services
Data Constructs
eg_bpa_buildingplan
Stores primary information like application number, EDCR number, date etc.. for the plot/site building permit and occupancy certificate applications.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 |
edcrnumber | character varying (64) | Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied | Y |
status | character varying (64) | To know status of the application | Y |
landid | character varying (256) | Unique identifier for land details | 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 |
lastmodifiedtime | bigint | epoch of the time object is modified last | |
createdtime | bigint | epoch of the time object is created | Y |
approvalno | character varying (64) | Unique identifier for the application approved | Y |
approvaldate | bigint | epoch of the time object of application approved | Y |
applicationdate | bigint | epoch of the time object of application created | Y |
businessservice | character varying (64) | name of the business service | Y |
accountid | character varying (256) | uuid of the user who created the application | Y |
| 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 |
eg_bpa_auditdetails
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id | 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 |
edcrnumber | character varying (64) | Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied | Y |
status | character varying (64) | To know status of the application | Y |
landid | character varying (256) | Unique identifier for land details | 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 | |
lastmodifiedtime | bigint | epoch of the time object is created | Y |
approvalno | character varying (64) | Unique identifier for the application approved | Y |
approvaldate | bigint | epoch of the time object of application approved | Y |
applicationdate | bigint | epoch of the time object of application created | Y |
businessservice | character varying (64) | name of the business service | Y |
accountid | character varying (256) | uuid of the user who created the application | Y |
| 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 |
eg_bpa_document
Stores BPA application uploaded document details
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 filestore UUID | Y |
documentuid | character varying (64) | Unique identifier of document | N |
buildingplanid (FK) | character varying (64) | The ID of building plan | 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 |
| 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 |
eg_land_landInfo
Stores land details information.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
landUid | character varying(64) | The system generated unique id(UUID) | Y |
landUniqueRegNo | character varying(64) | The unique registration number to identify the land record | Y |
tenantId | character varying(256) | TenantID to identify application submitted for the which city | Y |
status | character varying(64) | Status of application | N |
ownershipCategory | character varying(64) | The land ownership category | Y |
source | character varying(64) | The source of land record | Y |
channel | character varying(64) | From which channel the application is submitted | 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 |
| 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 |
eg_land_address
It stores land/plot/site address information.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
tenantId | character varying(256) | TenantID to identify application submitted for the which city | Y |
doorNo | character varying(64) | The door numbers of plot/land | N |
plotNo | character varying(64) | The plot number of plot | N |
landmark | character varying(64) | The nearest place to identify the plot | N |
city | character varying(64) | The city name where the plot is located | Y |
district | character varying(64) | The district name where land is located | N |
region | character varying(64) | The region name with respective of plot located | N |
state | character varying(64) | The state name where land/plot is located | Y |
country | character varying(64) | Name of the country where land is located | Y |
locality | character varying(64) | The locality name of the plot/land | Y |
pincode | character varying(64) | The pincode of land/plot | Y |
additionDetails | character varying(64) | Json object to capture any extra information which is not accommodated in the model | N |
buildingName | character varying(64) | Name of the building name | N |
street | character varying(64) | Street name of the plot where located | N |
landInfoId (FK) | character varying(64) | The landinfo id is foreign key reference to the landinfo | 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 |
| 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 |
eg_land_geolocation
Stores land geo-location information.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
latitude | double precision | The latitude value of the plot/land | Y |
longitude | double precision | The longtitude value of the land/plot | Y |
addressId (FK) | character varying(64) | The addressid is the foreignkey reference, it contain ID value of the land address | 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 |
| 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 |
eg_land_ownerInfo
Stores landowner details.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id | character varying(64) | The system generated unique id(UUID) | Y |
uuid | character varying(64) | The UUID is the unique key of user. It contains user UUID to identify which user | Y |
isprimaryowner | boolean | Whether the owner is primary owner who own land | Y |
ownershippercentage | double precision | If land have multiple owners, then each own how much percentage. | Y |
institutionId | character varying(64) | N | |
additionalDetails | JSONB | Json object to capture any extra information which is not accommodated in the model | N |
landInfoId | character varying(64) | The landinfo id is foreign key reference to the landinfo | Y |
relationship | character varying(64) | The relationship with primary owner | 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 |
| 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 |
eg_land_institution
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
tenantId | character varying(256) | TenantID to identify application submitted for the which city | Y |
type | character varying(64) | type | N |
designation | character varying(256) | Designation name | N |
nameOfAuthorizedPerson | character varying(256) | Name of the authorized person from institute | N |
additionalDetails | JSONB | Json object to capture any extra information which is not accommodated in the model | N |
landInfoId (FK) | character varying(64) | The landinfo id is foreign key reference to the landinfo | 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 |
| 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 |
eg_land_document
Stores land-related attached documents.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
documentType | character varying(256) | Name of the document type | Y |
fileStoreId | character varying(256) | The filestoreId of document | Y |
documentUid | character varying(256) | The system generated unique id(UUID) | Y |
additionalDetails | JSONB | Json object to capture any extra information which is not accommodated in the model | N |
landInfoId (FK) | 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 |
| 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 |
eg_land_unit
Stores building information in the land/plot.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 (FK) | 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 |
| 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 |
eg_land_auditdetails
Stores land information audit details.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(256) | The system generated unique id(UUID) | Y |
landUid | character varying(64) | The system generated unique id(UUID) | Y |
landUniqueRegNo | character varying(256) | The unique registration number to identify the land record | Y |
tenantId | character varying(64) | TenantID to identify application submitted for the which city | Y |
status | character varying(64) | Status of application | N |
ownershipcategory | character varying(64) | The land ownership category | Y |
source | character varying(64) | The source of land record | Y |
channel | character varying(64) | From which channel the application is submitted | 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 |
| 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 |
eg_land_owner_auditdetails
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
uuid | character varying(64) | The UUID is the unique key of user. It contains user UUID to identify which user | Y |
isprimaryowner | boolean | Whether the owner is primary owner who own land | Y |
ownershippercentage | double precision | If land have multiple owners, then each own how much percentage. | Y |
institutionId | character varying(64) | N | |
additionalDetails | JSONB | Json object to capture any extra information which is not accommodated in the model | N |
landInfoId | character varying(64) | The landinfo id is foreign key reference to the landinfo | Y |
relationship | character varying(64) | The relationship with primary owner | 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 |
| 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 |
eg_land_institution_auditdetails
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
tenantId | character varying(256) | TenantID to identify application submitted for the which city | Y |
type | character varying(64) | type | N |
designation | character varying(256) | Designation name | N |
nameOfAuthorizedPerson | character varying(256) | Name of the authorized person from institute | N |
additionalDetails | JSONB | Json object to capture any extra information which is not accommodated in the model | N |
landInfoId | character varying(64) | The landinfo id is foreign key reference to the landinfo | 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 |
| 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 |
eg_land_unit_auditdetails
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 |
| 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 |
eg_land_address_auditdetails
It stores audit details of land/plot/site address information
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
tenantId | character varying(256) | TenantID to identify application submitted for the which city | Y |
doorNo | character varying(64) | The door numbers of plot/land | N |
plotNo | character varying(64) | The plot number of plot | N |
landmark | character varying(64) | The nearest place to identify the plot | N |
city | character varying(64) | The city name where the plot is located | Y |
district | character varying(64) | The district name of the city located | N |
region | character varying(64) | The region name with respective of plot located | N |
state | character varying(64) | The state name of city located | Y |
country | character varying(64) | Name of the country | Y |
locality | character varying(64) | The locality name of the plot/land | Y |
pincode | character varying(64) | The pincode of land/plot | Y |
additionDetails | character varying(64) | Json object to capture any extra information which is not accommodated in the model | N |
buildingName | character varying(64) | Name of the building name | N |
street | character varying(64) | Street name of the plot where located | N |
landInfoId (FK) | character varying(64) | The landinfo id is foreign key reference to the landinfo | 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 |
| 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 |
eg_land_geolocation_auditdetails
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | character varying(64) | The system generated unique id(UUID) | Y |
latitude | double precision | The latitude value of the plot/land | Y |
longitude | double precision | The longtitude value of the land/plot | Y |
addressId (FK) | character varying(64) | The addressid is the foreignkey reference, it contain ID value of the land address | 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 |
| 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 |
eg_noc
Stores NOC applications information
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 |
| 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 |
eg_noc_auditdetails
Stores NOC applications audit information
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 |
| 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 |
eg_noc_document
Stores NOC attached documents information
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
id (PK) | 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 |
| 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 |
Mapping Constructs
Last updated
