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

• eg_fsm_application_auditlog

• eg_fsm_pit_detail

• eg_fsm_pit_detail_auditlog

• eg_fsm_address

• eg_fsm_address_auditlog

• eg_fsm_geolocation

• eg_fsm_geolocation_auditlog

eg_fsm_application

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_application_auditlog

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_pit_detail

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_pit_detail_auditlog

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_address

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_address_auditlog

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
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

Mapping Details

eg_fsm_geolocation

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory
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 Details

eg_fsm_geolocation_auditlog

Description

Attribute Details

Attribute Name	Data Type	Desciption	Mandatory
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 Details

Mapping Constructs