nan
on 2026-09-29, when asked about the various levels of qualifier id's, Roger said:
Yes, perhaps we should rename the columns, it felt logical when designed, but are a bit confusing. now. If I were to rename them, then it would be like this:
- “qualifier” => “symbol”
- “cardinal_qualifier_id” => “qualifier_id”
The “tbl_value_qualifier_symbols” is a lookup table containing all known symbols. Some of these symbols have the same meaning e.g. ”!=” and ”<>”, “not equal”. The purpose of the tbl_value_qualifiers lookup table is to group symbols by their meaning i.e. rows in tbl_value_qualifier_symbols with the same “cardinal_qualifier_id” has the same semantic meaning.