Birth & Death Data Model
Birth & Death Service Entity Details
Data Constructs
eg_birth_death_hospitals
Attribute Name | Data Type | Definition | Mandatory (Y/N) |
---|---|---|---|
id (PK) | character varying(64) | Y | |
hospitalname | character varying(500) | Y | |
tenantid | character varying(50) | Y |
eg_birth_dtls
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) |
eg_birth_father_info
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 |
eg_birth_mother_info
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 |
eg_birth_permaddr
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 |
eg_birth_presentaddr
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 |
eg_birth_cert_request
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 |
eg_birth_cert_request_audit
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 |
Last updated