I have a foreign key constraint that I created to reference the primary key of another table:constraint geneassay_fk foreign key(geneassay) references ...

When only a sub-set of the foreign keys comprise the full primary key of the fact table, it is not unusual for developers, or query writers, to gloss over the documentation and assume that all foreign ...

Therefore, to support this misrepresentation of foreign keys the data modeler may have to exclude the Start Date from the primary key, misleading users as to how a unique row is identified. Or ...