Set PK as a combined string of table 1 and 2 records
I think you just need a proper UNIQUE or PRIMARY KEY constraint:

ALTER TABLE drink 
    ADD CONSTRAINT drink_pk
        PRIMARY KEY 
        (drink_type, drink_flavor);`


If you often want the concatenation of the 2 columns in query results, you can use a view or a generated column (depending on MySQL version).