võõrvõtmed
Võõrvõtmed, meaning "foreign keys" in Estonian, are a fundamental concept in relational database design. They are a type of constraint that ensures referential integrity between two tables. A foreign key in one table points to a primary key in another table, establishing a link between the data in those tables. This link prevents actions that would destroy the relationship between the tables, such as deleting a record in the parent table if there are related records in the child table.
The table containing the foreign key is typically referred to as the child table or referencing table,
Implementing foreign keys is crucial for maintaining data consistency and accuracy. They help to prevent orphaned