Geography Data - Githubissues

planettelex / Bloom

Bloom Music Suite

Apache License 2.0

2 stars 0 forks source link

Geography Data #151

Open RobDixonIII opened 8 years ago

RobDixonIII commented 8 years ago

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