schema.validate(table) does a foreign key and a primary key validation. But only the foreign key validation considers the actual row data of the table, while the primary key validation only validates if the field with the name exists. This validation should be already done by schema.validate() anyways and does not require any Table data.
I think schema.validate(table) should:
- validate primary key values are unique
- validate foreign keys reference existing values
- validate all the data rows (the current fk check reads the whole data anyways)
schema.validate(table) does a foreign key and a primary key validation. But only the foreign key validation considers the actual row data of the table, while the primary key validation only validates if the field with the name exists. This validation should be already done by schema.validate() anyways and does not require any Table data.
I think schema.validate(table) should: