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

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

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

eg_fsm_application_auditlog

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

Attribute Name

Data Type

Description

Mandatory (Y/N)

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

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

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

eg_fsm_pit_detail_auditlog

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

Attribute Name

Data Type

Description

Mandatory (Y/N)

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

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

Attribute Name

Data Type

Description

Mandatory (Y/N)

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

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

Attribute Name

Data Type

Description

Mandatory (Y/N)

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

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

Attribute Name

Data Type

Description

Mandatory

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

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

Attribute Name

Data Type

Desciption

Mandatory

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

PreviousFaecal Sludge Management Service NextFaecal Sludge Management Service API

Last updated 1 year ago