Family table (tblFamilies)
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 |
|
|
FamilyUUID | uniqueidentifier | YES | New UUID |
|
Did you encounter a problem or do you have a suggestion?
Please contact our Service Desk
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/