Table openpetra_trunk.public.s_error_message
List of error messages used by Petra s_errmsg.p program. This allows language-specific runtime error messages to be displayed depending on the language of the logged in user.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
s_language_code_c varchar 20 '99'::character varying
p_language.p_language_code_c s_error_message_fk1 R
s_error_code_c varchar 12
s_message_line_1_c varchar 100
s_message_line_2_c varchar 100  √  null
s_message_line_3_c varchar 100  √  null
s_response_c varchar 100  √  null
s_alert_type_c varchar 24  √  'Warning'::character varying
s_title_c varchar 48  √  'Invalid Data Entered'::character varying
s_log_error_l bool 1  √  false Determines whether to log the error in the s_error_log table
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c s_error_message_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c s_error_message_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 412 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
s_language_code_c + s_error_code_c Primary key Asc/Asc s_error_message_pk
s_language_code_c Performance Asc inx_s_error_message_fk1_key1
s_created_by_c Performance Asc inx_s_error_message_fkcr_key2
s_modified_by_c Performance Asc inx_s_error_message_fkmd_key3
s_language_code_c + s_error_code_c Must be unique Asc/Asc inx_s_error_message_pk0

Close relationships  within of separation: