message_header table - SuperOffice

message_header Table (259)

This table contains small pieces of information which is listed over the body for each message.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
message_id	The id of the message this header entry is connected to.	FK ej_message	No
type	The type for this header entry.	type	Yes
name	A name for this entry.	String(64)	Yes
value	A value for this entry.	Clob	Yes
std_item	If this has a value, it indicates that a standard header text from the language database should be used - and witch one to use.	std_item	Yes
std_item_col	If this is 1, concatenate the standard item text with header name field, if 2 use header value field instead. If this col is 0, use the empty field - preferably the value column.	std_item_col	Yes

Indexes

Fields	Types	Description
message_id	FK	Index

Relationships

Table	Description
ej_message	This table contains the messages listed under tickets.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Enum MessageHeaderStdItem Enum MessageHeaderStdItemCol ej_message table Message table s_message table Delete Message Headers

⌘I