Location

Contents

[edit]

Description

[edit]

Attributes

Column Name Type Default Description
Primary Key location_id int
Required name varchar(255)
description varchar(255) NULL
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
county_district varchar(50) NULL
neighborhood_cell varchar(50) NULL
Primary Key primary key, Required required
Retrieved from "http://openmrs.org/wiki/Location"