Table Name:	key_column
Table Number:	5877
Group:	Analytics
Description:	Information about the key column in the flt table
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_key_column

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
clfy_key_type	LONG	smallint			-1	DIRECT	Holds the type id of the object in ClarifyCRM database. e.g., if the key is contact, then it will be 45. Default = -1
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
key_level	LONG	int				DIRECT	The key level
key_order	LONG	int				DIRECT	If there is more than one key, then order of the keys
objid	LONG	int	3			DIRECT	Internal record number
score_col_name	CHAR	varchar		32			Helps Maping of columns in the flat table with columns in the scores table. It contains the correct field name of the implementation key in scores table

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
key2anls_object	MTO	anls_object	anls_object2key_column	Object this key (primary or secondary) belongs too
key2obj_column	OTOP	obj_column	obj_column2key_column	Columns belonging to the key (primary or secondary)

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

key_column

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user