What is the name of the type of testing in which, after migration, the database checks whether the relationship between two columns is correct?

Question

Software testing

There is a table A in which there are fields Field1 and Field2. There is a well-known relationship between these two fields. For simplicity, let's take Field2 = Field1 * 2. Unfortunately, it turned out that due to an error in the script, there are records in table A that do not satisfy this condition. We need to write a test that detects such cases.

What type of tests are these tests? Modular, iteration, functional, e2e or Acceptance (I heard during the stream that there are such tests). Itself intuitively I can not understand what type these tests belong to.

Answer 1

Well look. First of all, you need to understand that testing is about checking the logic of the code.
All actions in the database are performed by some method or set of methods. Means it is necessary to check the logic of operation of these methods.
This can be done at different levels of the testing pyramid, but the lower the checks are, the better. In this case, it is possible to check at the level of integration tests, but it is also possible at the level of unit tests, depending on how the code of the
ps system is implemented. This has nothing to do with migration tests.

Answer 2

These are migration tests)