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.
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
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
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
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
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
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.
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
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.
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
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.
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
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.
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
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
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
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.
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
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.
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
