Last active
June 28, 2017 16:59
-
-
Save dphilla/68db439667d2be574cc5cb0fa3c85915 to your computer and use it in GitHub Desktop.
DB visualation Qs -Daniel Phillips
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. a unique key on the table on given resource table | |
2. a reference to another tables primary key | |
3. a schema is visual representation of table relationships | |
4. a one-to-many relationship indicates that many resources "belong" to a single resource in another table, while a many-to-many | |
relationship indicates multiple resources point referencing other multiple resources | |
5. a foreign key on a table is a copy of/references the a single primary key on its own (native?/primary?/home?) table. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment