Faecal Sludge Management Data Model
Faecal sludge management (FSM) is a system that enables citizens to raise a request for septic tank cleaning with the ULBs directly or reach out to the ULB counter. A citizen can track the application, pay the charges and rate the service.
FSM Service Entity Details
eg_fsm_application
id (PK)
character varying(256)
applicationno
character varying(128)
tenantid
character varying(64)
additionaldetails
jsonb
accountid
character varying(64)
description
character varying(256)
applicationStatus
character varying(64)
source
character varying(64)
sanitationtype
character varying(64)
propertyUsage
character varying(64)
noOfTrips
int
status
character varying(64)
vehicle_id
character varying(64)
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
eg_fsm_application_auditlog
id
character varying(64)
applicationno
character varying(64)
tenantid
character varying(64)
additionaldetails
jsonb
accountid
character varying(64)
description
character varying(256)
applicationStatus
character varying(64)
source
character varying(64)
sanitationtype
character varying(64)
propertyUsage
character varying(64)
noOfTrips
int
status
character varying(64)
vehicle_id
character varying(64)
pit_id
character varying(4)
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
eg_fsm_pit_detail
id (PK)
character varying(64)
tenantid
character varying(64)
height
double precision
length
double precision
width
double precision
distanceFromRoad
double precision
additionalDetails
JSONB
fms_id (FK)
character varying
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
eg_fsm_pit_detail_auditlog
id
character varying(64)
tenantid
character varying(64)
height
double precision
length
double precision
width
double precision
distanceFromRoad
double precision
additionalDetails
JSONB
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
eg_fsm_address
id
character varying(64)
tenantId
character varying(64)
doorNo
character varying(64)
plotNo
character varying(64)
landmark
character varying(64)
city
character varying(64)
district
character varying(64)
region
character varying(64)
state
character varying(64)
country
character varying(64)
locality
character varying(64)
pincode
character varying(64)
additionaldetails
jsonb
buildingName
character varying(64)
street
character varying(64)
fsm_id
character varying(64)
createdBy
character varying(64)
lastModifiedBy
character varying(64)
createdTime
bigint
lastModifiedTime
bigint
eg_fsm_address_auditlog
id
character varying(64)
tenantId
character varying(64)
doorNo
character varying(64)
plotNo
character varying(64)
landmark
character varying(64)
city
character varying(64)
district
character varying(64)
region
character varying(64)
state
character varying(64)
country
character varying(64)
locality
character varying(64)
pincode
character varying(64)
additionaldetails
jsonb
buildingName
character varying(64)
street
character varying(64)
fsm_id
character varying(64)
createdBy
character varying(64)
lastModifiedBy
character varying(64)
createdTime
bigint
lastModifiedTime
bigint
eg_fsm_geolocation
id
character varying(64)
tenantid
character varying(64)
latitude
double precision
longitude
double precision
address_id
character varying(64)
additionalDetails
JSONB
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
eg_fsm_geolocation_auditlog
id
character varying(64)
tenantid
character varying(64)
latitude
double precision
longitude
double precision
address_id
character varying(64)
additionalDetails
JSONB
createdby
character varying(64)
lastmodifiedby
character varying(64)
createdtime
bigint
lastmodifiedtime
bigint
Mapping Constructs
Last updated
Was this helpful?