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 ...

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.

Some database designers may feel that it’s OK to arbitrarily assign all dimensional foreign keys as part of a fact’s primary key even when one or more do not actually contribute to the fact table’s ...