Foreign Key Mapping — StudySection Blog

Foreign Key Mapping — StudySection Blog

Foreign Key Mapping is the process of establishing a link between two records. Suppose I have a User and I make a table called users that has some specific ID that should be a primary key.

An additional table named ‘vehicles’ has a listing of vehicles with descriptions such as the vehicle model, brand, color, and so on. The thing that comes to mind is that I have to establish a relationship with the vehicles’ owners. I am going to add a new column named user_id which works as a foreign key to the user’s table in the vehicles table.

SQL Query Example:

ALTER TABLE `vehicles` ADD CONSTRAINT `user_vehicles` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

One-to-one mapping occurs when records of a primary table relate to a single record of a secondary table. For example, a relationship between the User table and the UserDetails table.

Another case occurs when a record is linked to multiple records. For example, users may have multiple vehicles, multiple phone numbers, multiple documents, etc.

Whenever a record of a first table can reference multiple records of a second table and similarly a second table record can reference multiple records of a first table, it refers to many-to-many mapping. As an example, a product could have multiple tags and each tag may relate to multiple products.

jQuery allows the user to create powerful and dynamic webpages that run without any hiccup. With StudySection, you have the liberty to choose among beginner or expert level jQuery Certification Exams to help you excel in this career field.

Originally published at https://studysection.com on March 31, 2022.

--

--

The most loved online platform for eCertification in several subjects including but not limited to Software Development, Aptitude and more.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Study Section

Study Section

The most loved online platform for eCertification in several subjects including but not limited to Software Development, Aptitude and more.