consumer type id or label? if label it should be 255 to match public.cp_consumer_type.
Also why not make it a FK to consumer_type?