On Fri, 13 Sep 2024, Tony Shelver wrote:
Or if you want to get even more flexible, where a dairy could have more than one owner as well as one owner having more than one dairy, you could create an intersection / relationship table. Something like -- Create people table (one entry per person) CREATE TABLE people_dairy_map ( pdm_id SERIAL PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), email VARCHAR(100) UNIQUE ); phone_number VARCHAR(15), person_id INT REFERENCES people(person_id) dairy_id INT REFERENCES dairies(dairy_id);
Thanks, Tony. Regards, Rich
