<commit_before><?xml version="1.0"?>
<database-schema>
	<table name="distPoller" visable="false">
		<column name="dpNumber"/>
		<column name="dpName"/>
		<column name="dpIP"/>
		<column name="dpComment"/>
		<column name="dpDiscLimit"/>
		<column name="dpAdminState"/>
		<column name="dpRunState"/>
	</table>

	<table name="node"> 
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="nodeID"/>
		<column name="dpName" visable="false"/>
		<column name="nodeCreateTime"/>
		<column name="nodeParentID"/>
		<column name="nodeType"/>
		<column name="nodeSysOID"/>
		<column name="nodeSysName"/>
		<column name="nodeSysDescription"/>
		<column name="nodeSysLocation"/>
		<column name="nodeSysContact"/>
		<column name="nodeLabel"/>
	</table>

	<table name="categories">
		<join column="categoryID" table="category_node" table-column="categoryID"/>
		<column name="categoryID" />
		<column name="categoryName" />
		<column name="categoryDescription" />
	</table>

	<table name="category_node">
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="categoryID" visable="false" />
		<column name="nodeID" visable="false" />
	</table>

	<table name="ipInterface" key="primary">
		<column name="nodeID" visable="false"/>
		<column name="ipAddr"/>
		<column name="ipHostname"/>
		<column name="isManaged"/>
		<column name="ipStatus"/>
		<column name="ipLastCapsdPoll"/>
	</table>

	<table name="snmpInterface">
		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
		<column name="nodeID" visable="false"/>
		<column name="ipAddr" visable="false"/>
		<column name="snmpIpAdEntNetMask"/>
		<column name="snmpPhysAddr"/>
		<column name="snmpIfIndex"/>
		<column name="snmpIfDescr"/>
		<column name="snmpIfType"/>
		<column name="snmpIfSpeed"/>
		<column name="snmpIfAdminStatus"/>
		<column name="snmpIfOperStatus"/>
	</table>
	
	<table name="service">
		<join column="serviceID" table="ifServices" table-column="serviceID" />
		<column name="serviceID" visable="false" />
		<column name="serviceName"/>
	</table>

	<table name="ifServices">
		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
		<column name="ipAddr" visable="false"/>
		<column name="id"/>
		<column name="serviceID"/>
		<column name="lastGood"/>
		<column name="lastFail"/>
	</table>
	
	<table name="serverMap">
     		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
     		<column name="ipAddr" visable="false"/>
     		<column name="serverName"/>
	</table>
	
	<table name="serviceMap">
     		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
     		<column name="ipAddr" visable="false"/>
     		<column name="serviceMapName"/>
	</table>
	
	<table name="assets">
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="nodeID" visable="false"/>
		<column name="displayCategory"/>
		<column name="notifyCategory"/>
		<column name="pollerCategory"/>
		<column name="thresholdCategory"/>
	</table>

	<table name="applications">
		<join column="id" table="application_service_map" table-column="appId"/>
		<column name="id" />
		<column name="name" />
	</table>

	<table name="application_service_map">
		<join column="ifServiceId" table="ifServices" table-column="id"/>
		<column name="appId" visable="false" />
		<column name="ifServiceId" visable="false" />
	</table>


</database-schema>

<commit_msg>update relationship between ifservice and ipinterface table to include nodeId in the join<commit_after><?xml version="1.0"?>
<database-schema>
	<table name="distPoller" visable="false">
		<column name="dpNumber"/>
		<column name="dpName"/>
		<column name="dpIP"/>
		<column name="dpComment"/>
		<column name="dpDiscLimit"/>
		<column name="dpAdminState"/>
		<column name="dpRunState"/>
	</table>

	<table name="node"> 
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="nodeID"/>
		<column name="dpName" visable="false"/>
		<column name="nodeCreateTime"/>
		<column name="nodeParentID"/>
		<column name="nodeType"/>
		<column name="nodeSysOID"/>
		<column name="nodeSysName"/>
		<column name="nodeSysDescription"/>
		<column name="nodeSysLocation"/>
		<column name="nodeSysContact"/>
		<column name="nodeLabel"/>
	</table>

	<table name="categories">
		<join column="categoryID" table="category_node" table-column="categoryID"/>
		<column name="categoryID" />
		<column name="categoryName" />
		<column name="categoryDescription" />
	</table>

	<table name="category_node">
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="categoryID" visable="false" />
		<column name="nodeID" visable="false" />
	</table>

	<table name="ipInterface" key="primary">
		<column name="nodeID" visable="false"/>
		<column name="ipAddr"/>
		<column name="ipHostname"/>
		<column name="isManaged"/>
		<column name="ipStatus"/>
		<column name="ipLastCapsdPoll"/>
	</table>

	<table name="snmpInterface">
		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
		<column name="nodeID" visable="false"/>
		<column name="ipAddr" visable="false"/>
		<column name="snmpIpAdEntNetMask"/>
		<column name="snmpPhysAddr"/>
		<column name="snmpIfIndex"/>
		<column name="snmpIfDescr"/>
		<column name="snmpIfType"/>
		<column name="snmpIfSpeed"/>
		<column name="snmpIfAdminStatus"/>
		<column name="snmpIfOperStatus"/>
	</table>
	
	<table name="service">
		<join column="serviceID" table="ifServices" table-column="serviceID" />
		<column name="serviceID" visable="false" />
		<column name="serviceName"/>
	</table>

	<table name="ifServices">
		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="ipAddr" visable="false"/>
		<column name="nodeID" visable="false"/>
		<column name="id"/>
		<column name="serviceID"/>
		<column name="lastGood"/>
		<column name="lastFail"/>
	</table>
	
	<table name="serverMap">
     		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
     		<column name="ipAddr" visable="false"/>
     		<column name="serverName"/>
	</table>
	
	<table name="serviceMap">
     		<join column="ipAddr" table="ipInterface" table-column="ipAddr"/>
     		<column name="ipAddr" visable="false"/>
     		<column name="serviceMapName"/>
	</table>
	
	<table name="assets">
		<join column="nodeID" table="ipInterface" table-column="nodeID"/>
		<column name="nodeID" visable="false"/>
		<column name="displayCategory"/>
		<column name="notifyCategory"/>
		<column name="pollerCategory"/>
		<column name="thresholdCategory"/>
	</table>

	<table name="applications">
		<join column="id" table="application_service_map" table-column="appId"/>
		<column name="id" />
		<column name="name" />
	</table>

	<table name="application_service_map">
		<join column="ifServiceId" table="ifServices" table-column="id"/>
		<column name="appId" visable="false" />
		<column name="ifServiceId" visable="false" />
	</table>


</database-schema>


{'fraction_non_alphanumeric': 0.19252709640616086, 'fraction_numerical': 0.0005704506560182544, 'mean_word_length': 5.278424350940018, 'pattern_counts': {'":': 0, '<': 203, '<?xml version=': 2, '>': 203, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3518753', 'n_tokens_mistral': 2453, 'n_tokens_neox': 2279, 'n_words': 459}