The work_attribute table has the following in CreateTables:

-- Either it has a value from the allowed list, or is free text
CHECK ( work_attribute_type_allowed_value IS NULL OR work_attribute_text IS NULL )

However, that check does not achieve what the comment asks for (because it's possible for both to be null).