Diagram
Fields
Name | Type | Mandatory | Default | Explanation |
---|---|---|---|---|
InsureeID | int (PK) | YES | ||
FamilyID | int | YES | FK tblFamilies | |
CHFID | nvarchar(12) | NO | Insuree number | |
LastName | nvarchar(100) | YES | ||
OtherNames | nvarchar(100) | YES | ||
DOB | date | YES | Date of Birth | |
Gender | char(1) | NO | FK tblGender | |
Marital | char(1) | NO | ||
IsHead | bit | YES | 0 | 1 if Insuree is head of the Family |
passport | nvarchar(25) | NO | ||
Phone | nvarchar(50) | NO | ||
PhotoID | int | NO | Insuree’s photo - FK tblPhotos | |
PhotoDate | date | NO | ||
CardIssued | bit | YES | 0 | Whether an insurance card was issued or not |
ValidityFrom | datetime | YES | Current date | |
ValidityTo | datetime | NO | ||
LegacyID | int | NO | ||
AuditUserID | int | YES | ||
RowID | timestamp | NO | ||
nvarchar(100) | NO | |||
isOffline | bit | NO | 0 | |
HFID | int | NO | FK tblHF |
Name | Type | Mandatory | Default | Explanation |
---|---|---|---|---|
Relationship | smallint | NO | FK tblRelations | |
Profession | smallint | NO | FK tblProfessions | |
Education | smallint | NO | FK tblEducations | |
TypeOfId | nvarchar(1) | NO | FK tblIdentificationTypes | |
CurrentAddress | nvarchar(200) | NO | ||
GeoLocation | nvarchar(250) | NO | GPS coordinates where the enrolment took place | |
CurrentVillage | int | NO | ||
InsureeUUID | uniqueidentifier | YES | New UUID |
Forms
The following forms/pages are displaying or edit Insuree related data: