Patient


Contents

Description

Attributes

Column Name Type Default Description
Primary Key patient_id int
Required gender varchar(50)
race varchar(50) NULL
birthdate date NULL
birthdate_estimated bit NULL
birthplace varchar(50) NULL
tribe tribe.tribe_id int NULL
citizenship varchar(50) NULL
mothers_name varchar(50) NULL
civil_status int NULL
Required dead int(1)
death_date datetime NULL
cause_of_death concept.concept_id int NULL
health_district varchar(255) NULL
health_center int NULL
Required creator users.user_id int
Required date_created datetime 0000-00-00 00:00:00
changed_by users.user_id int NULL
date_changed datetime NULL
Required voided bit
voided_by users.user_id int NULL
date_voided datetime NULL
void_reason varchar(255) NULL
Primary Key primary key, Required required