I would have expected a CHECK(loss_type IN ('structural', 'nonstructural',  'contents', 'occupancy')) here.