Table Name:	alert_to_other
Table Number:	4300
Group:
Description:	Relates alerts to other tables
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_alert_to_other

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
alias_name	CHAR	varchar		80		USER_DEFINED	Alias of table/view that this row was found from	Search (1)
dev	LONG	int	151			USER_DEFINED, ALLOW_NULL	Row version number for mobile distribution purposes
obj_id	LONG	int				USER_DEFINED	Object ID of related row in table	Search (1)
obj_num	LONG	int				USER_DEFINED	Object number of related table	Search (1)
objid	LONG	int	3			USER_DEFINED	Internal Record number	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
to_other2alert	MTO	alert	alert2alert_to_other	Alert related to other tables	USER_DEFINED		Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
alert_other_ind	obj_num:obj_id

Indexes (Defined in Database):

Index Name	Fields	Additional Information
alert_other_ind	obj_num, obj_id	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4302	alert_view	alert, alert_to_other

My Recent Objects

alert_to_other

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user