Table openpetra_trunk.public.a_form_element
Each element that can be displayed on a form is defined on this table.

 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
a_form_code_c varchar 20
a_form.a_form_code_c a_form_element_fk1 R
a_form_element_type.a_form_code_c a_form_element_fk2 R
The code which defines the type of form described in the table
a_form_name_c varchar 20
a_form.a_form_name_c a_form_element_fk1 R
The name of the form being created for the form code.
a_form_sequence_i int4 10 0 Unique identifier of each form element within a form
a_form_element_type_code_c varchar 40
a_form_element_type.a_form_element_type_code_c a_form_element_fk2 R
The code of an element type that can be possitioned for use on a form.
a_column_i int4 10 1 The column that the element is to be displayed at on the form.
a_row_i int4 10 1 The row on the page that the element is to be displayed at.
a_length_i int4 10 1 The display length for the element. e.g. it may be necessary to truncate fields.
a_skip_i int4 10  √  0 This stores the number of characters to skip prior to printing. It can be used to spread a description over two lines.
a_when_print_c varchar 40 Indicates when the element is printed. This would indicate detail lines, first, last page etc.
a_literal_text_c varchar 2000  √  null Text to be displayed if the element is defined as a literal.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_form_element_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_form_element_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
a_form_code_c + a_form_name_c + a_form_sequence_i Primary key Asc/Asc/Asc a_form_element_pk
a_form_code_c + a_form_name_c + a_row_i + a_column_i + a_form_sequence_i Performance Asc/Asc/Asc/Asc/Asc a_form_element_pk0
a_form_code_c + a_form_name_c Performance Asc/Asc inx_a_form_element_fk1_key1
a_form_code_c + a_form_element_type_code_c Performance Asc/Asc inx_a_form_element_fk2_key2
s_created_by_c Performance Asc inx_a_form_element_fkcr_key3
s_modified_by_c Performance Asc inx_a_form_element_fkmd_key4
a_form_code_c + a_form_name_c + a_form_sequence_i Must be unique Asc/Asc/Asc inx_a_form_element_pk0

Close relationships  within of separation: