Where possible, codes having the same meaning should be equal across different tables.
The 'unchecked' value has a different code in tables duplicates, location quality and quality flag: 4-duplicates,3-location quality,2-quality flag
The 'failed/bad' has a different code in tables location quality and quality flag: 2-location quality, 1-quality flag
Certain codes values could be reserved i.e. 0-good, 1-bad, 2-doubtfull, 3-unchecked...adding later any other table specific values using different codes.