In Inserting Hierarchical Rows, how we can find out which two tables are connected to each other or multiple table. How to find out which table is parent table and which is children table?
The child table has a foreign key referencing the parent table.
You’ll learn about foreign keys in the Designing Databases section.
1 Like
Hi, I have just completed the section on Inserting Hierarchical Rows.
In the section below are we changing the value of the price of the item by inserting them with a price here? I mean aren’t the item prices for the items in sql_store.products already?
Thanks
Vivian
One might think it’s redundant to have a unit_price both in products
and order_items
. But in case the price in products
changes you still want to continue processing orders with the price that was valid by the time they were placed.
1 Like