This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
database_views [2019/03/24 14:39] steve |
database_views [2019/03/24 14:40] steve [Database Views] |
||
---|---|---|---|
Line 3: | Line 3: | ||
On all the SQL database schemas, the data is [[https://en.wikipedia.org/wiki/Database_normalization|normalized]]. However, I realize most people don't want to write a lot of JOINS just to get to what they want, and so there is ''scriptures'' VIEW that runs the query for you to return a non-normalized result set. | On all the SQL database schemas, the data is [[https://en.wikipedia.org/wiki/Database_normalization|normalized]]. However, I realize most people don't want to write a lot of JOINS just to get to what they want, and so there is ''scriptures'' VIEW that runs the query for you to return a non-normalized result set. | ||
- | Each database is different, but for the sake of simplicity, here's the schema for each one: | + | Each database is different, but for the sake of simplicity, here's the schema for some: |
==== SQLite ==== | ==== SQLite ==== |