Table Name:	tree_node
Table Number:	5894
Group:	Analytics
Description:	Information about the decision tree node
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_tree_node

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
condition	CHAR	varchar		1333			Node condition
coverage	LONG	int				DIRECT	Num of people in total population
coverage_percent	LONG	int				DIRECT	Percent of people in total population
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exp_accuracy	FLOAT	real					A formula to calculate the accuracy of the condition
hit	LONG	int				DIRECT	Num of people that answers true to the node's condition
hit_percent	LONG	int				DIRECT	Percent of people that answers TRUE to the node's condition
node_level	LONG	int				DIRECT	The depth of the node in the tree
objid	LONG	int	3			DIRECT	Internal record number
parent_id	LONG	int				DIRECT	Id of the parent node
rw_coverage	LONG	int				DIRECT	Num of people in real world that answers false to the node's condition
rw_coverage_percent	LONG	int				DIRECT	Percent of people in total population in real world
rw_exp_accuracy	FLOAT	real					A formula to calculate the accuracy of the condition in the real world
rw_hit	LONG	int				DIRECT	Num of people that answers TRUE to the node's condition in real world
rw_hit_percent	LONG	int				DIRECT	Percent of people that answers TRUE to the node's condition in real world

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
tree_node2dec_tree	MTO	dec_tree	dec_tree2tree_node	Node of a decision tree
tree_node2tree_class	MTO	tree_class	tree_class2tree_node	Conditions of all the nodes in a certain class (e.g age>40, state=NY, etc)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

tree_node

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user