EHI Export Schema
PersonFamilyHistory
Table detailing patients' family medical histories.
Column Name | Data Type | Constraint Type | Is Nullable |
---|---|---|---|
PersonFamilyHistoryId | int | PK | NO |
PersonId | int | FK | YES |
ConditionId | int | FK | YES |
ConditionFreeText | varchar(500) | YES | |
Comments | varchar(max) | YES | |
CommentsDate | datetime | YES | |
Created | datetime | YES | |
CreatedBy | varchar(100) | YES | |
Modified | datetime | YES | |
ModifiedBy | varchar(100) | YES | |
Deleted | datetime | YES | |
DeletedBy | varchar(100) | YES |