In my attempt to model a one to many relationship, I am trying to achieve the following in SQL (MariaDB) given my basic DB knowledge:
Profiles Table: Primary Key: profileName <----- | Repositories Table: | Composite Primary Keys: (profileName, repository_name)
Is this a possibility?