<?php
    // file created on August 9, 2019, 3:44 pm
    
    // field specifications for table htm.orga_mannschaften_kontakte
    $fieldspec['verbaende_art_id']          = array('type' => 'string',
                                                    'size' => 5,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['verbaende_kuerzel']         = array('type' => 'string',
                                                    'size' => 10,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['vereine_kuerzel']           = array('type' => 'string',
                                                    'size' => 20,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['saison_id']                 = array('type' => 'string',
                                                    'size' => 10,
                                                    'pkey' => 'y',
                                                    'required' => 'y');
    
    $fieldspec['mannschaften_id']           = array('type' => 'string',
                                                    'size' => 10,
                                                    'pkey' => 'y',
                                                    'required' => 'y');
    
    $fieldspec['kontakt_ma_user_id']        = array('type' => 'string',
                                                    'size' => 16,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y',
                                                    'control' => 'popup',
                                                    'task_id' => 'htm_orga_kontakte_account(popup1)',
                                                    'foreign_field' => 'user_id');
    
    $fieldspec['kontakt_ma_user_seq_no']    = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 11,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'pkey' => 'y',
                                                    'required' => 'y');
    
    $fieldspec['kontakt_ma_user_rdcaccount_id']= array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 10,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'default' => '1',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['rdcaccount_id']             = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 10,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'required' => 'y',
                                                    'default' => '1',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['kontakt_ma_name']           = array('type' => 'string',
                                                    'size' => 50,
                                                    'required' => 'y');
    
    $fieldspec['kontakt_ma_vorname']        = array('type' => 'string',
                                                    'size' => 50);
    
    $fieldspec['kontakt_ma_position_01']    = array('type' => 'string',
                                                    'size' => 3);
    
    $fieldspec['kontakt_ma_position_02']    = array('type' => 'string',
                                                    'size' => 3);
    
    $fieldspec['kontakt_ma_position_03']    = array('type' => 'string',
                                                    'size' => 3);
    
    $fieldspec['kontakt_ma_position_rdcaccount_id']= array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 10,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295);
    
    $fieldspec['kontakt_ma_trikot_no']      = array('type' => 'integer',
                                                    'type_native' => 'smallint',
                                                    'size' => 2,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 99);
    
    $fieldspec['kontakt_ma_trikot_groesse'] = array('type' => 'string',
                                                    'size' => 20);
    
    $fieldspec['kontakt_ma_groesse']        = array('type' => 'float',
                                                    'size' => 22);
    
    $fieldspec['kontakt_ma_gewicht']        = array('type' => 'integer',
                                                    'type_native' => 'tinyint',
                                                    'size' => 4,
                                                    'minvalue' => -128,
                                                    'maxvalue' => 127);
    
    $fieldspec['kontakt_ma_im_verein_seit'] = array('type' => 'date',
                                                    'size' => 12);
    
    $fieldspec['kontakt_ma_vertrag_bis']    = array('type' => 'date',
                                                    'size' => 12);
    
    $fieldspec['kontakt_ma_letzter_verein'] = array('type' => 'string',
                                                    'size' => 100);
    
    $fieldspec['kontakt_ma_gruppe']         = array('type' => 'string',
                                                    'size' => 30);
    
    $fieldspec['kontakt_typ_id']            = array('type' => 'string',
                                                    'size' => 6,
                                                    'required' => 'y',
                                                    'control' => 'dropdown',
                                                    'optionlist' => 'kontakt_typ_id_list');
    
    $fieldspec['kontakt_typ_rdcaccount_id'] = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 10,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'required' => 'y',
                                                    'default' => '1');
    
    $fieldspec['node_id']                   = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 5,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'default' => '0');
    
    $fieldspec['kontakt_stamm_verbaende_art_id']= array('type' => 'string',
                                                    'size' => 5,
                                                    'uppercase' => 'y',
                                                    'control' => 'popup',
                                                    'task_id' => 'htm_orga_vereine(popup1)',
                                                    'foreign_field' => 'kontakt_stamm_verbaende_art_id',
                                                    'nosearch' => 'y');
    
    $fieldspec['kontakt_stamm_verbaende_kuerzel']= array('type' => 'string',
                                                    'size' => 10,
                                                    'uppercase' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['kontakt_stamm_vereine_kuerzel']= array('type' => 'string',
                                                    'size' => 20,
                                                    'uppercase' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['kontakt_stamm_vereine_name']= array('type' => 'string',
                                                    'size' => 255,
                                                    'noedit' => 'y');
    
    $fieldspec['created_date']              = array('type' => 'datetime',
                                                    'size' => 20,
                                                    'required' => 'y',
                                                    'default' => '2014-01-01 00:00:00',
                                                    'autoinsert' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['created_user']              = array('type' => 'string',
                                                    'size' => 16,
                                                    'required' => 'y',
                                                    'autoinsert' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['revised_date']              = array('type' => 'datetime',
                                                    'size' => 20,
                                                    'autoupdate' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['revised_user']              = array('type' => 'string',
                                                    'size' => 16,
                                                    'autoupdate' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    // primary key details 
    $this->primary_key                      = array('verbaende_art_id',
                                                    'verbaende_kuerzel',
                                                    'vereine_kuerzel',
                                                    'saison_id',
                                                    'mannschaften_id',
                                                    'kontakt_ma_user_id',
                                                    'kontakt_ma_user_seq_no',
                                                    'kontakt_ma_user_rdcaccount_id');
    
    // unique key details 
    $this->unique_keys                      = array();
    
    // child relationship details 
    $this->child_relations[]                = array('child' => 'orga_mannschaften_kontakte_ausruestung',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel',
                                                                      'saison_id' => 'saison_id',
                                                                      'mannschaften_id' => 'mannschaften_id',
                                                                      'kontakt_ma_user_id' => 'ma_ausruestung_user_id',
                                                                      'kontakt_ma_user_seq_no' => 'ma_ausruestung_user_seq_no',
                                                                      'kontakt_ma_user_rdcaccount_id' => 'ma_ausruestung_user_rdcaccount_id'));
    
    $this->child_relations[]                = array('child' => 'orga_spiele',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel',
                                                                      'saison_id' => 'saison_id',
                                                                      'mannschaften_id' => 'mannschaften_id',
                                                                      'kontakt_ma_user_id' => 'spiele_trikot_user_id',
                                                                      'kontakt_ma_user_seq_no' => 'spiele_trikot_user_seq_no',
                                                                      'kontakt_ma_user_rdcaccount_id' => 'rdcaccount_id'));
    
    $this->child_relations[]                = array('child' => 'training_plan_anwesenheit',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'tplan_anwesenheit_verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'tplan_anwesenheit_verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'tplan_anwesenheit_vereine_kuerzel',
                                                                      'saison_id' => 'tplan_anwesenheit_saison_id',
                                                                      'mannschaften_id' => 'tplan_anwesenheit_mannschaften_id',
                                                                      'kontakt_ma_user_id' => 'tplan_anwesenheit_user_id',
                                                                      'kontakt_ma_user_seq_no' => 'tplan_anwesenheit_user_seq_no',
                                                                      'kontakt_ma_user_rdcaccount_id' => 'tplan_anwesenheit_user_rdcaccount_id'));
    
    // parent relationship details 
    $this->parent_relations[]               = array('parent' => 'orga_kontakte_account',
                                                    'fields' => array('kontakt_ma_user_id' => 'user_id',
                                                                      'kontakt_ma_user_seq_no' => 'user_seq_no',
                                                                      'kontakt_ma_user_rdcaccount_id' => 'rdcaccount_id'));
    
    $this->parent_relations[]               = array('parent' => 'orga_kontakte_adresse',
                                                    'fields' => array('kontakt_ma_user_id' => 'user_id',
                                                                      'kontakt_ma_user_seq_no' => 'user_seq_no',
                                                                      'rdcaccount_id' => 'rdcaccount_id'));
    
    $this->parent_relations[]               = array('parent' => 'orga_kontakte_typ',
                                                    'fields' => array('kontakt_typ_id' => 'kontakt_typ_id',
                                                                      'kontakt_typ_rdcaccount_id' => 'rdcaccount_id'));
    
    $this->parent_relations[]               = array('parent' => 'orga_mannschaften',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel',
                                                                      'saison_id' => 'saison_id',
                                                                      'mannschaften_id' => 'mannschaften_id'));
    
    $this->parent_relations[]               = array('parent' => 'orga_mannschaften_eigene',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel',
                                                                      'saison_id' => 'saison_id',
                                                                      'mannschaften_id' => 'mannschaften_id'));
    
    $this->parent_relations[]               = array('parent' => 'orga_schulen',
                                                    'fields' => array('kontakt_stamm_verbaende_art_id' => 'verbaende_art_id',
                                                                      'kontakt_stamm_verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'kontakt_stamm_vereine_kuerzel' => 'schule_kuerzel'));
    
   $this->parent_relations[]               = array('parent' => 'orga_vereine',
                                                    'fields' => array('kontakt_stamm_verbaende_art_id' => 'verbaende_art_id',
                                                                      'kontakt_stamm_verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'kontakt_stamm_vereine_kuerzel' => 'vereine_kuerzel'));
   
    $this->parent_relations[]               = array('parent' => 'mnu_account',
                                                    'dbname' => 'menu',
                                                    'subsys_dir' => 'menu',
                                                    'fields' => array('rdcaccount_id' => 'rdcaccount_id'));
    
    // determines if database updates are recorded in an audit log 
    $this->audit_logging                    = TRUE;
    
    // default sort sequence 
    $this->default_orderby                  = '';
    
    // alternative language options 
    $this->alt_language_table               = '';
    $this->alt_language_cols                = '';
    
    // alias names 
    $this->nameof_start_date                = '';
    $this->nameof_end_date                  = '';
    
    // finished
?>
<?php
    // file created on June 19, 2018, 10:31 am
    
    // field specifications for table htm.orga_vereine
    $fieldspec['verbaende_art_id']          = array('type' => 'string',
                                                    'size' => 5,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['verbaende_kuerzel']         = array('type' => 'string',
                                                    'size' => 10,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['vereine_kuerzel']           = array('type' => 'string',
                                                    'size' => 20,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'uppercase' => 'y');
    
    $fieldspec['rdcaccount_id']             = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 10,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'required' => 'y',
                                                    'default' => '1',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['node_id']                   = array('type' => 'integer',
                                                    'type_native' => 'int',
                                                    'size' => 5,
                                                    'minvalue' => 0,
                                                    'maxvalue' => 4294967295,
                                                    'default' => '0',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['vereine_name']              = array('type' => 'string',
                                                    'size' => 255,
                                                    'required' => 'y');
    
    $fieldspec['vereine_name_zusatz']       = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_strasse']           = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_lkz']               = array('type' => 'string',
                                                    'size' => 10);
    
    $fieldspec['vereine_plz']               = array('type' => 'string',
                                                    'size' => 10);
    
    $fieldspec['vereine_ort']               = array('type' => 'string',
                                                    'size' => 100);
    
    $fieldspec['vereine_telefon']           = array('type' => 'string',
                                                    'size' => 30);
    
    $fieldspec['vereine_fax']               = array('type' => 'string',
                                                    'size' => 30);
    
    $fieldspec['vereine_email']             = array('type' => 'string',
                                                    'size' => 100);
    
    $fieldspec['vereine_website']           = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_logo']              = array('type' => 'string',
                                                    'size' => 150,
                                                    'subtype' => 'image',
                                                    'imagewidth' => 16,
                                                    'imageheight' => 16,
                                                    'control' => 'filepicker',
                                                    'task_id' => 'htm_orga_vereine(filepicker)',
                                                    'nosearch' => 'y');
    
    $fieldspec['vereine_spielbetrieb']      = array('type' => 'boolean',
                                                    'type_native' => 'tinyint',
                                                    'default' => '1',
                                                    'true' => '1',
                                                    'false' => '0',
                                                    'control' => 'checkbox');
    
    $fieldspec['vereine_mitgliedschaft_01'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_mitgliedschaft_02'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_mitgliedschaft_03'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_mitgliedschaft_04'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_mitgliedschaft_05'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['vereine_mitgliedschaft_06'] = array('type' => 'string',
                                                    'size' => 255);
    
    $fieldspec['created_date']              = array('type' => 'datetime',
                                                    'size' => 20,
                                                    'required' => 'y',
                                                    'default' => '2014-01-01 00:00:00',
                                                    'autoinsert' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['created_user']              = array('type' => 'string',
                                                    'size' => 16,
                                                    'required' => 'y',
                                                    'autoinsert' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['revised_date']              = array('type' => 'datetime',
                                                    'size' => 20,
                                                    'autoupdate' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    $fieldspec['revised_user']              = array('type' => 'string',
                                                    'size' => 16,
                                                    'autoupdate' => 'y',
                                                    'noedit' => 'y',
                                                    'nosearch' => 'y');
    
    // primary key details 
    $this->primary_key                      = array('verbaende_art_id',
                                                    'verbaende_kuerzel',
                                                    'vereine_kuerzel');
    
    // unique key details 
    $this->unique_keys                      = array();
    
    // child relationship details 
    $this->child_relations[]                = array('child' => 'orga_mannschaften_kontakte',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'kontakt_stamm_verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'kontakt_stamm_verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'kontakt_stamm_vereine_kuerzel'));
    
    $this->child_relations[]                = array('child' => 'orga_saisons',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel'));
    
    $this->child_relations[]                = array('child' => 'orga_treffpunkte',
                                                    'type' => 'RES',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel',
                                                                      'vereine_kuerzel' => 'vereine_kuerzel'));
    
    // parent relationship details 
    $this->parent_relations[]               = array('parent' => 'orga_verbaende',
                                                    'fields' => array('verbaende_art_id' => 'verbaende_art_id',
                                                                      'verbaende_kuerzel' => 'verbaende_kuerzel'));
    
    $this->parent_relations[]               = array('parent' => 'mnu_account',
                                                    'dbname' => 'menu',
                                                    'subsys_dir' => 'menu',
                                                    'fields' => array('rdcaccount_id' => 'rdcaccount_id'));
    
    // determines if database updates are recorded in an audit log 
    $this->audit_logging                    = TRUE;
    
    // default sort sequence 
    $this->default_orderby                  = '';
    
    // alternative language options 
    $this->alt_language_table               = '';
    $this->alt_language_cols                = '';
    
    // alias names 
    $this->nameof_start_date                = '';
    $this->nameof_end_date                  = '';
    
    // finished
?>