Bolt: Details for Table

Table Name:	ce_col
Table Number:	4311
Group:	fcQuery
Description:	Properties/output/sort columns
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_ce_col

Keyboard shortcuts available

Fields:

(double-click a column header to select column text)

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151			USER_DEFINED, ALLOW_NULL	Row version number for mobile distribution purposes
field_type	LONG	int				USER_DEFINED	What data type is the property? string = 0, integer = 1, float = 2, date = 3, decimal = 4
is_id	LONG	int				USER_DEFINED	This is the id field for the parent query object
is_idNumber	LONG	int				USER_DEFINED	This is the id number field for the parent query object
is_output	LONG	int				USER_DEFINED	Is this an output column?
is_property	LONG	int				USER_DEFINED	Is this a property?
is_res	LONG	int				USER_DEFINED	Is this a data res column?
is_sort	LONG	int				USER_DEFINED	Is this a sort column?
list_type	LONG	int				USER_DEFINED	Should we use no list (=0), clarify list (=1), or user-defined list (=2)
objid	LONG	int	3			USER_DEFINED	Internal record number
output_format	CHAR	varchar		255		USER_DEFINED	Column Output Format Function
prop_list	CHAR	varchar		30		USER_DEFINED	List to use for the property
prop_name	CHAR	varchar		20		USER_DEFINED	The property name
prop_path	CHAR	varchar		255		USER_DEFINED	Query property path
rank	LONG	int				USER_DEFINED	What is the order for this item in the list of columns?

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
ce_col2ce_clause	OTM	ce_clause	ce_clause2ce_col	The clauses using this col	USER_DEFINED
ce_col2ce_object	MTO	ce_object	ce_object2ce_col		USER_DEFINED
ce_col2ce_query_col	OTM	ce_query_col	ce_query_col2ce_col		USER_DEFINED

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

ce_col

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user