Skip to content

Instantly share code, notes, and snippets.

@dphilla
Last active June 28, 2017 16:59
Show Gist options
  • Save dphilla/68db439667d2be574cc5cb0fa3c85915 to your computer and use it in GitHub Desktop.
Save dphilla/68db439667d2be574cc5cb0fa3c85915 to your computer and use it in GitHub Desktop.
DB visualation Qs -Daniel Phillips
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