Diagram
Fields
Name | Type | Mandatory | Default | Explanation |
|---|---|---|---|---|
FamilyID | int (PK) | YES | ||
InsureeID | int | NO | FK tblInsurees | |
LocationId | int | NO | FK tblLocations | |
Poverty | bit | NO | 0 | |
isOffline | bit | NO | 0 | |
FamilyType | nvarchar(2) | NO | FK tblFamilyTypes | |
FamilyAddress | nvarchar(200) | NO | ||
Ethnicity | nvarchar(1) | NO | ||
ConfirmationNo | nvarchar(12) | NO | ||
ConfirmationType | nvarchar(3) | NO | FK tblConfirmationTypes | |
ValidityFrom | datetime | YES | Current date | |
ValidityTo | datetime | NO | ||
LegacyID | int | NO | ||
AuditUserID | int | YES | ||
RowID | timestamp | NO |