Designing One-to-One Tables
Learn Designing One-to-One Tables (Relationships & Database Design, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A one-to-one relationship means each row in table A matches at most one row in table B, and the reverse. In MySQL you build it by making the child's foreign key also UNIQUE (or by making the foreign key the child's primary key).