#====================================
# subroutine db_field_is_hierarchical
# ===================================

# retruns true if the database field supports hierarchies

subroutine(db_field_is_hierarchical(
	string profile_name,
	string database_field_name), (
	
	bool hierarchical_support = false;
	
	if (node_exists("profiles." . profile_name . ".database.fields." . database_field_name . ".log_field")) then (
	
		string log_field_name = node_value("profiles." . profile_name . ".database.fields." . database_field_name . ".log_field");
		
		if (node_exists("profiles." . profile_name . ".log.fields." . log_field_name . ".type")) then (
		
			string log_field_type = node_value("profiles." . profile_name . ".log.fields." . log_field_name . ".type");
			
			if (log_field_type ne "flat") then (
			
				hierarchical_support = true;
			);
		);
	);

	hierarchical_support;
));