Table openpetra_trunk.public.m_extract_master
Master file for extracts. Contains names for the extract id

 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
m_extract_id_i int4 10 0
m_extract.m_extract_id_i m_extract_fk1 R
m_extract_parameter.m_extract_id_i m_extract_parameter_fk1 R
p_form_letter_insert.m_extract_id_i p_form_letter_insert_fk3 R
s_group_extract.m_extract_id_i s_group_extract_fk2 R
Identifier for the extract
m_extract_name_c varchar 50  √  null Short name for the extract to be used in filenames
m_extract_desc_c varchar 160  √  null This is a long description for the extract
m_last_ref_d date 13  √  null
m_deletable_l bool 1 true
m_frozen_l bool 1 false The user can set the frozen field when the extract should not be updated.
m_key_count_i int4 10  √  0
m_public_l bool 1 true
m_manual_mod_l bool 1 false Indicates that the extract has been edited by a user
m_manual_mod_d date 13  √  null Date the extract was manually modified
m_manual_mod_by_c varchar 20  √  null
s_user.s_user_id_c m_extract_master_fk3 R
Who made the last manual modification ?
m_extract_type_code_c varchar 50  √  null
m_extract_type.m_code_c m_extract_master_fk4 R
Indicate the extract type. Which function was the extract created through?
m_template_l bool 1  √  false Is this extract just a template that has not yet been run?
m_restricted_l bool 1  √  false Indicates whether or not the extract has restricted access. If it does then the access will be controlled by s_group_extract
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c m_extract_master_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c m_extract_master_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
m_extract_id_i Primary key Asc m_extract_master_pk  
m_manual_mod_by_c Performance Asc inx_m_extract_master_fk3_key1  
m_extract_type_code_c Performance Asc inx_m_extract_master_fk4_key2  
s_created_by_c Performance Asc inx_m_extract_master_fkcr_key3  
s_modified_by_c Performance Asc inx_m_extract_master_fkmd_key4  
m_extract_id_i Must be unique Asc inx_m_extract_master_pk0  
m_extract_name_c Must be unique Asc inx_m_extract_master_uk0 This unique column is also nullable
m_extract_name_c Must be unique Asc m_extract_master_uk This unique column is also nullable

Close relationships  within of separation: