Geography Data

[RobDixonIII]

Add geographical data capabilities.

Tables:

• city
  • id
  • name
  • country_region_id
  • country_id
• country
  • id
  • name
• language
  • id
  • name
• country_region
  • id
  • name
  • country_id
• country_language
  • country_id
  • language_id
• song_language
  • song_id
  • language_id
• song_live_venue
  • song_id
  • venue_id
• holiday_country
  • holiday_id
  • country_id
• studio
  • id
  • name
  • address
  • city_id
  • opened_on
  • closed_on
• venue
  • id
  • name
  • address
  • city_id
  • opened_on
  • closed_on

Fields:

• person
  • from_city_id
• artist
  • formed_city_id
• album release
  • release_country_id
• song
  • about_city_id
• label
  • address
  • city_id
• reference
  • language_id
• review
  • language_id