Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titlePrimary and Foreign Key Example

Image Modified

The Primary Key from the permitapps table is used as a Foreign Key in the contacts table. This means that there can only one application with an appid of 12 but there may be multiple contacts on that application. By writing a request to the database to see all of the records where the appid is 12 we would be able to see that there is one application and potentially several contacts.

...