downcased provider_id foreign key column