Birth & Death Data Model
Last updated
Last updated
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
| Attribute Name | Data Type | Definition | Mandatory |
|---|---|---|---|
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
| Attribute Name | Data Type | Description | Mandatory (Y/N) |
|---|---|---|---|
| Attribute Name | Data Type | Description | Mandatory (Y/N) |
|---|---|---|---|
| Attribute Name | Data Type | Description | Mandatory (Y/N) |
|---|---|---|---|
| Attribute Name | Data Type | Description | Mandatory (Y/N) |
|---|---|---|---|
id (PK)
character varying(64)
Y
hospitalname
character varying(500)
Y
tenantid
character varying(50)
Y
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)
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
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
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
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
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
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