Patient address

Contents

[edit]

Description

[edit]

Attributes

Column Name Type Default Description
Primary Key patient_address_id int
Required patient_id patient.patient_id int
Required preferred bit
address1 varchar(50) NULL
address2 varchar(50) NULL
city_village varchar(50) NULL
state_province varchar(50) NULL
postal_code varchar(50) NULL
country varchar(50) NULL
latitude varchar(50) NULL
longitude varchar(50) NULL
Required creator users.user_id int
Required date_created datetime 0000-00-00 00:00:00
Required voided bit
voided_by users.user_id int NULL
date_voided datetime NULL
void_reason varchar(255) NULL
county_district varchar(50) NULL
neighborhood_cell varchar(50) NULL
Primary Key primary key, Required required
Retrieved from "http://openmrs.org/wiki/Patient_address"