Actual database schema - Githubissues

rubymonsters / speakerinnen_liste

International Women* Speaker Directory

https://speakerinnen.org

MIT License

75 stars 62 forks source link

Actual database schema #644

Open zaziemo opened 7 years ago

zaziemo commented 7 years ago

db_overview_170918 001

tyranja commented 6 years ago

old database scheme: https://github.com/rubymonsters/speakerinnen_liste/issues/613

tyranja commented 6 years ago

@zaziemo update database please

tyranja commented 6 years ago

We don't have twitter, city, website in the Profiles tables any more.

What about talks or media_url?

tyranja commented 6 years ago

And languages seems to be iso_languages nowadays. ( see: https://github.com/rubymonsters/speakerinnen_liste/pull/526 and https://github.com/rubymonsters/speakerinnen_liste/commit/ed2f801e19a87b84458398b244b1e9203a5f7e8f )

And we have to remove city, twitter, website, main_topic and bio from the profile database because those are all translated fields and moved to the profile_translations table.

All in Profiles table:

[ ] languages
[ ] city
[ ] twitter
[ ] website
[ ] main_topic
[ ] bio

zaziemo commented 6 years ago

Yes, that is true. I think we wanted to keep those fields a little while because we did many migrations and were not sure whether everything works out properly. But now 1 year has passed and nobody complained ;) Can be deleted!

sabrina-ulbrich commented 6 years ago

city, twitter, website, main_topic, bio and languages are no longer in the profile table, look at pull request #733

tyranja commented 6 years ago

Maybe we can use this to create an actual db schema: https://github.com/voormedia/rails-erd

tyranja commented 6 years ago

erd

https://github.com/rubymonsters/speakerinnen_liste/tree/anja-create-db-schema

zaziemo commented 5 years ago

@tyranja do we want to stick to that gem? It think some tables are missing there. Or should I update the PPT-Doc?