added foreign key reference associations when cloud account is created