MySQLではデータベースの一貫性を保つため、外部キー（Foreign Key）制約がサポートされています。

I'm adding a table and subclass table to my DB. (Subclass table = table where the primary key joins to the primary key of another table, to give extra row information to some subset of the rows ...

Properly expressing foreign keys (which means understanding the possible semantic subtleties involved in various alternatives), singles out mastery of the data modeling process. And truly ...

Foreign key 'geneassay_fk' references invalid column 'geneassay' in referencing table 'b_SequencingData_seq'. Msg 1750, Level 16, State 0, Line 43 Could not create constraint.

Retaining an infinitude of Foreign Keys may cause future performance bottlenecks as transactional volume will get a performance hit by maintaining all those foreign keys and the indexes behind them.