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

Email

nvarchar(100)

NO

isOffline

bit

NO

0

HFID

int

NO

FK tblHF

Relationship

smallint

NO

FK tblRelations
1: Brother/Sister
2: Father/Mother
3: Uncle/Aunt
4: Son/Daughter
5: Grand parents
6: Employee
7: Others
8: Spouse

Profession

smallint

NO

FK tblProfessions
1: Housewife
2: Employee
3: Self Employee
4: Others

Education

smallint

NO

FK tblEducations
1: Nursery
2: Primary school
3: Secondary school
4: University
5: Postgraduate studies
6: PHD
7: Other

TypeOfId

nvarchar(1)

NO

FK tblIdentificationTypes
D: Driver's License
N: National ID
P: Passport
V: Voter Card

CurrentAddress

nvarchar(200)

NO

GeoLocation

nvarchar(250)

NO

GPS coordinates where the enrolment took place

CurrentVillage

int

NO

InsureeUUID

uniqueidentifier

YES

New UUID