Table: attention_messages

Home → Table Definitions → Attention File Tables
Attention Files Object Group
Table: attention_messages
<= attention_flags	Table Definitions =>

Description

This table contains the list of attention messages for the files that may need operator intervention.

Column Name	Description
attn_file_id	The attention file ID number
attn_flag_id	The attention flag ID number
attn_message	The attention message
attn_time	The time the attention message was added

Definition

attention_messages
Column Name	Type	Nullable	Default Value
attn_file_id	integer	NO
attn_flag_id	integer	NO
attn_message	text	NO
attn_time	timestamp	NO

Constraints

Constraint Name	Definition [and Description]
attention_messages_primary_key	PRIMARY KEY (attn_file_id, attn_flag_id)
attn_file_id_reference	FOREIGN KEY (attn_file_id) REFERENCES attention_files(attn_file_id)
attn_flag_id_reference	FOREIGN KEY (attn_flag_id) REFERENCES attention_flags(attn_flag_id)

<= attention_flags

Attention File Tables

Table Definitions =>