allowed_series_entity_type and allowed_collection_entity_type are currently implemented as hard-coded constraints. Updating them is a schema change.

It'd be useful to be able to modify these without changing the schema. The proposal here is to replace these constraints with tables that store the list of types.