3 ms·
Collection of real world database schemas from open-source packages
- dvh 5y agoI remember installing WordPress 2 years ago. Default schema had 7 tables with 3 different naming conventions.
- nkmnz 5y agoI once saw a huge website with hundreds of schemas, but I cannot find it anymore. It looked like straight from the 90s, but the examples seemed to recent. Does anyone know that place?
- crunchbang123 5y agoMaybe this[1] is what you're referring to? I found it from this SO[2] answer. [1]: http://www.databaseanswers.org/data_models/ http://www.databaseanswers.org/data_models/ [2]: https://stackoverflow.com/questions/9993842/where-to-find-practical-well-designed-database-schema-examples-to-learn-from https://stackoverflow.com/questions/9993842/where-to-find-pr...
- nkmnz 5y agoYes, thank you!! Is stuff like that „timeless“ if one wanted to learn from it?
- persona 5y agoPerhaps this one: http://www.databaseanswers.org/data_models/ http://www.databaseanswers.org/data_models/
- sunsetSamurai 5y agohow accurate is this? It shows only 5 tables for Airbnb, seems like it should be much more.
- Tanjreeve 5y agoI could believe an application DB fora service architecture wouldn't be some hulking great data warehouse monstrosity capturing the entire business. Those tables could be TB large. But some aren't real e.g the Twitter one is just someone's project attempting to model how Twitter works which in no way means it's correct.
- ojosilva 5y agoIt's an useful resource. According to their features page, I think if you register you can export (download) the schema DDL. It would be nice to get sample data too. It's quite hard to find good sample databases with data in them, and in tidily constrained schemas. Supposedly you can get an Access Database (yuck) at http://www.databaseanswers.org/data_models/ http://www.databaseanswers.org/data_models/ by emailing the site owner (yuck2).