speakerinnen_liste icon indicating copy to clipboard operation
speakerinnen_liste copied to clipboard

Published 20 hours ago • verified publisher icon rubymonsters

Actual database schema

Open zaziemo opened this issue 7 years ago • 9 comments

db_overview_170918 001

zaziemo avatar Sep 18 '17 19:09 zaziemo

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

tyranja avatar Feb 09 '18 20:02 tyranja

@zaziemo update database please

tyranja avatar Jun 18 '18 17:06 tyranja

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

What about talks or media_url?

tyranja avatar Jun 19 '18 13:06 tyranja

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

tyranja avatar Jun 25 '18 17:06 tyranja

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!

zaziemo avatar Jul 09 '18 18:07 zaziemo

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

sabrina-ulbrich avatar Jul 23 '18 20:07 sabrina-ulbrich

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

tyranja avatar Aug 08 '18 11:08 tyranja

erd

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

tyranja avatar Aug 09 '18 13:08 tyranja

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

zaziemo avatar Mar 18 '19 20:03 zaziemo