It would be better when the following checks are added.
- The
MIN_SALARY, when it's not NULL, should be positive.
- The
MAX_SALARY, when it's not NULL, should be positive.
- When both columns are not
NULL,
- The
MIN_SALARY should be less than or equal to the MAX_SALARY.
It would be better when the following checks are added.
MIN_SALARY, when it's notNULL, should be positive.MAX_SALARY, when it's notNULL, should be positive.NULL,MIN_SALARYshould be less than or equal to theMAX_SALARY.