Venue ID API: Database Tables: venues

Purpose

Storing all venue information.

Columns

uid Primary key
venue_uid The numeric part of venue_id (currently the same as venue_id)
venue_id Venue ID code
venue_name Name of venue
alt_names Alternative names for venue
previous_names Previous names for venue
address Address of venue
town Town
region County, state or region
country_code Country in ISO 3166-1 Alpha-2 format
postal_code Postal code
latitude Latitude
longitude Longitude
status Status: 0 is deleted, 1 is pending, 2 is active
input_ts Time and date when venue was created
updated_ts Time and date when venue was last modified
submit_user_uid The ID of the user who originally submitted the venue