replaced rc_id by resource_class_id throughout the schema and added the foreign keys on resource_class_id