Birth & Death Data Model

Birth & Death Service Entity Details

• eg_birth_death_hospitals

• eg_birth_dtls

• eg_birth_father_info

• eg_birth_mother_info

• eg_birth_permaddr

• eg_birth_presentaddr

• eg_birth_cert_request

• eg_birth_cert_request_audit

Data Constructs

eg_birth_death_hospitals

Description

Attribute Details

Attribute Name	Data Type	Definition	Mandatory (Y/N)
id (PK)	character varying(64)		Y
hospitalname	character varying(500)		Y
tenantid	character varying(50)		Y

Mapping Details

eg_birth_dtls

Description

Attribute Details

Attribute Name	Data Type	Definition	Mandatory
id (PK)	character varying(64)		Y
registrationno	character varying(64)		Y
hospitalname	character varying(500)
dateofreport	timestamp without time zone
dateofbirth	timestamp without time zone		Y
firstname	character varying(200)
middlename	character varying(200)
lastname	character varying(200)
placeofbirth	character varying(1000)
informantsname	character varying(200)
informantsaddress	character varying(1000)
createdtime	bigint
createdby	character varying(64)
lastmodifiedtime	bigint
lastmodifiedby	character varying(64)
counter	smallint
tenantid	character varying(50)		Y
gender	smallint		Y
remarks	character varying(1000)
hospitalid (FK)	character varying(64)

Mapping Details

eg_birth_father_info

Description

Attribute Details

Attribute Name	Data Type	Definition	Mandatory (Y/N)
id (PK)	character varying(64)		Y
firstname	character varying(200)
middlename	character varying(200)
lastname	character varying(200)
aadharno	character varying(150)
emailid	character varying(300)
mobileno	character varying(150)
education	character varying(100)
proffession	character varying(100)
nationality	character varying(100)
religion	character varying(100)
createdtime	bigint
createdby	character varying(64)
lastmodifiedtime	bigint
lastmodifiedby	character varying(64)
birthdtlid (FK)	character varying(64)		Y

Mapping Details

eg_birth_mother_info

Description

Attribute Details

Attribute Name	Data Type	Definition	Mandatory (Y/N)
id (PK)	character varying(64)		Y
firstname	character varying(200)
middlename	character varying(200)
lastname	character varying(200)
aadharno	character varying(150)
emailid	character varying(300)
mobileno	character varying(150)
education	character varying(100)
proffession	character varying(100)
nationality	character varying(100)
religion	character varying(100)
createdtime	bigint
createdby	character varying(64)
lastmodifiedtime	bigint
lastmodifiedby	character varying(64)
birthdtlid (FK)	character varying(64)		Y

Mapping Details

eg_birth_permaddr

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
id (PK)	character varying(64)		Y
buildingno	character varying(1000)
houseno	character varying(1000)
streetname	character varying(1000)
locality	character varying(1000)
tehsil	character varying(1000)
district	character varying(100)
city	character varying(100)
state	character varying(100)
pinno	character varying(100)
country	character varying(100)
createdby	character varying(64)
createdtime	bigint
lastmodifiedby	character varying(64)
lastmodifiedtime	bigint
birthdtlid (FK)	character varying(64)		Y

Mapping Details

eg_birth_presentaddr

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
id (PK)	character varying(64)		Y
buildingno	character varying(1000)
houseno	character varying(1000)
streetname	character varying(1000)
locality	character varying(1000)
tehsil	character varying(1000)
district	character varying(100)
city	character varying(100)
state	character varying(100)
pinno	character varying(100)
country	character varying(100)
createdby	character varying(64)
createdtime	bigint
lastmodifiedby	character varying(64)
lastmodifiedtime	bigint
birthdtlid (FK)	character varying(64)		Y

Mapping Details

eg_birth_cert_request

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
id (PK)	character varying(64)		Y
birthcertificateno	character varying(25)
createdby	character varying(64)
createdtime	bigint
birthdtlid (FK)	character varying(64)
lastmodifiedtime	bigint
lastmodifiedby	character varying(64)
filestoreid	character varying(256)
status	character varying(25)
additionaldetail	jsonb
embeddedurl	character varying(64)
dateofissue	bigint

Mapping Details

eg_birth_cert_request_audit

Description

Attribute Details

Attribute Name	Data Type	Description	Mandatory (Y/N)
id	character varying(64)		Y
birthcertificateno	character varying(25)
createdby	character varying(64)
createdtime	bigint
birthdtlid	character varying(64)
lastmodifiedtime	bigint
lastmodifiedby	character varying(64)
filestoreid	character varying(256)
status	character varying(25)
additionaldetail	jsonb
embeddedurl	character varying(64)
dateofissue	bigint

Mapping Details