Skip to main content

caredb_core_patient

Columns

NameTypeNot nullDescription
account_typecharacter varying(10)True
activebooleanTrue
addresscharacter varying(65535)True
birth_datedateFalse
communicationcharacter varying(65535)True
contactcharacter varying(65535)True
created_timetimestamp without time zoneTrue
email_verifiedbooleanTrue
extensioncharacter varying(2048)True
first_namecharacter varying(255)True
gendercharacter varying(7)True
idcharacter varying(32)True
identifiercharacter varying(65535)True
last_modified_attimestamp without time zoneTrue
last_namecharacter varying(255)True
last_signup_email_sent_timetimestamp without time zoneFalse
managing_organizationcharacter varying(255)True
marital_statuscharacter varying(1)True
namecharacter varying(65535)True
owner_idcharacter varying(32)True
phonescharacter varying(255)True
preferred_namecharacter varying(255)True
registration_completed_timetimestamp without time zoneFalse
telecomcharacter varying(65535)True
telecom_preferencecharacter varying(7)True

The following tables have columns that reference this table: