Venue ID API: Database Tables: venues

Purpose

Storing information about venue updates which have been submitted by users with the intention of having the venues permanently modified with this new data.

Columns

uid Primary key
venue_id Venue ID code
venue_name Name of venue
alt_names Alternative names for venue
previous_names Previous names for venue
address1 First line of address
address2 Second line of address
town_txt Town
region_txt County, state or region
country_txt Country in ISO 3166-1 Alpha-2 format
postcode Postcode
latitude Latitude
longitude Longitude
status Status: 0 is deleted, 1 is pending
input_ts Time and date when update was submitted
submit_user_uid The ID of the user who submitted this update