Versions Compared


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


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.