# -*- coding: utf-8; srcfile://; mode: fundamental -*-

#DABEI
tab pnom uid: pntyp pnom
mov pnom pnom key nom pnom key typ pntyp
fld uid v 8
fld nom t
fld pnom t
fld typ v 2
fld pntyp v 2
tab mf uid: mf
fld mf v 1
tab mail uid mailref: mailuser mailhost
tab mt uid: user host
mov mt mail val norm mailref 
mov mail mail key ref mailref key nom mailuser key host mailhost rev priv norm mailref 
fld mailref v 8
fld host t
fld mailhost t
fld mailuser t
tab adr uid: land plz urb str
fld land v 2
fld plz t
fld urb t
fld str t
tab padr uid adrref: land plz urb str
mov padr padr key ref adrref 
mov adr padr val norm adrref key ort urb
fld adrref v 8
# define pfrol: role of person in firma/company/organisation
tab pfrol pfrol: pfrrem
# sign to be defined
fld pfrol v 8
# explanation of meaning
fld pfrrem t
# explain which role pfrol+pfrrem person plays in firma/company/organisation
# prfol is a predefined role from table pfrol, pfirmrem is an additional comment and can be used to replace pfrolin case no role is predefined
tab pfirm person firma: pfrol pfirmrem
fld person v 8
fld firma v 8
fld pfirmrem t
tab firma uid firmref: firmnom firmurl firmmem firmpub firmhom firmhomn firmhomp firmmon firmmonp firmtax firmtaxp firmdon firmdonp
mov firma firma key fid firmref key ref firmref key nom firmnom key mem firmmem
fld firmpub b
# can ffii publish the name of the company when speaking about its supporters ?
fld firmhom i
# number of employees, 
fld firmhomn i
# new employees last year 
fld firmhomp b
# publish number of employees ?
fld firmmon i
# last turnover / Umsatz
fld firmmonp b
# publish turnover?
fld firmtax i
# taxes paid last year
fld firmtaxp b
# publish tax sum ?
fld firmdon i 
# pledged donations to ffii for this year
fld firmrecv i
# donations received by ffii so far (not user-editable, display if firmdonp) 
fld firmdonp b
# publish donations ? 
fld firmref v 8
fld firmnom t
fld url v 20
fld firmurl v 20
fld mem b
fld firmmem b
tab beitrag uid: typ bet mon beg fin
tab pag uid: pagtyp pagsum pagmon pagbeg pagfin pagpap pagpub
mov beitrag pag key typ pagtyp key bet pagsum key mon pagmon key beg pagbeg key fin pagfin
fld pagtyp v 2
fld pagsum n 4 2
fld pagmon n 2
fld pagbeg d
fld pagfin d
fld pagpap b
fld pagpub b
fld beg d
fld fin d
tab konto uid: land blz bank knr inh iban
mov konto konto key nr knr
fld iban t
fld blz v 9
fld bank v 24
fld knr v 12
fld inh t
tab persist uid pstvar: pstval
mov persist persist key var pstvar key val pstval
tab sid uid: sidval
mov sid sid key val sidval
tab sessionid uid: val
mov sessionid sid key val sidval
fld var t
fld val t
fld pstvar t
fld pstval t
fld sidval t
tab tel uid: tel
tab teln uid telref: tel telrem
mov tel teln val norm ref key ref telref key rem telrem
mov teln teln key ref telref key rem telrem
fld tel t
fld ref v 8
fld telref v 8 
fld rem t
fld telrem t
tab http uid: http rem
fld http t
fld demo t
tab href uid urlref: http demo urlrem
mov http href val norm urlref key rem urlrm
mov href href key ref urlref key rem urlrem
fld urlref v 8
fld urlrem t
fld lvl n 2
fld ack b
tab sign uid sign: siglvl sigrem
mov sign sign key lvl siglvl key rem sigrem
fld sigrem t
tab signeubsa uid: lvl
tab signbund028 uid: lvl
mov signeubsa sign val eubsa sign key lvl siglvl
mov signbund028 sign val bund028 sign key lvl siglvl
fld sign v 8
tab subs uid subs: sublvl faru
mov subs subs key lvl sublvl
fld faru b
tab subsneues uid: lvl
mov subsneues subs val neues subs key lvl sublvl
tab subsverein uid: lvl
mov subsverein subs val verein subs key lvl sublvl
tab subsnews uid: lvl
mov subsnews subs val news subs key lvl sublvl
tab subsswpat uid: lvl
mov subsswpat subs val swpat subs key lvl sublvl
tab subsoffen uid: lvl
mov subsoffen subs val offen subs key lvl sublvl
tab subspatinfo uid: lvl
mov subspatinfo subs val patinfo subs key lvl sublvl
fld subs v 16
fld org v 8
tab ffii uid: lvl rem
mov ffii asoc val org ffii key lvl asolvl key rem asorem
tab asoc uid org: asolvl asorem
mov asoc asoc key lvl asolvl key rem asorem
fld asolvl n
fld sublvl n
fld siglvl n
fld memlvl n
fld replvl n
tab memq uid org: memlvl
mov memq memq key fid org key ref org key lvl memlvl
tab memqbitkom uid: lvl
mov memqbitkom memq val bitkom org key lvl memlvl
tab memqgiev uid: lvl
mov memqgiev memq val giev org key lvl memlvl
tab memqvsi uid: lvl
mov memqvsi memq val vsi org key lvl memlvl
tab memqvdma uid: lvl
mov memqvdma memq val vdma org key lvl memlvl
tab memqzvei uid: lvl
mov memqzvei memq val zvei org key lvl memlvl
tab memqccc uid: lvl
mov memqccc memq val ccc org key lvl memlvl
tab memqguug uid: lvl
mov memqguug memq val guug org key lvl memlvl
tab memqfitug uid: lvl
mov memqfitug memq val fitug org key lvl memlvl
tab memqfiff uid: lvl
mov memqfiff memq val fiff org key lvl memlvl
tab memqisoc uid: lvl
mov memqisoc memq val isoc org key lvl memlvl
tab memqfsfe uid: lvl
mov memqfsfe memq val fsfe org key lvl memlvl
tab memqdmmv uid: lvl
mov memqdmmv memq val dmmv org key lvl memlvl
tab part uid: ref lvl sub
tab repr uid grp vip: replvl reprem
mov repr repr key lvl replvl key rem reprem
fld reprem t
fld grp v 3
fld vip t
tab epat uid pat: tech deal clms iclm dclm clm1 prog epatrem
mov epat epat key rem epatrem
fld epatrem t
fld pat v 12
fld tech i 1
fld deal i 1
fld clms i 4
fld iclm i 2
fld dclm b
fld prog t
fld clm1 t
tab ven uid ven: venlvl
mov ven ven key lvl venlvl
tab venqber021205 uid: lvl
tab venqbru021107 uid: lvl
mov venqber021205 ven val ber021205 ven key lvl venlvl
mov venqbru021107 ven val bxl021107 ven key lvl venlvl
fld venlvl i
fld ven v 12
fld text t
fld sessionid v 12
fld cdnr i
tab glos uid ref: lok rem
nodb glos
nodb rol
tab perm uid permuid permvar: permval permrem
mov perm perm key mid permuid key tem permvar key val permval key rem permrem
fld permuid v 8
fld permvar t
fld permrem t
fld permval t
tab lang uid lang: lvl rem
tab uidlang uid lang: langlvl langrem
mov lang uidlang key lvl langlvl key rem langrem
tab proj uid proj: upproj projurl projfin
fld proj v 8
fld langlvl i 1
fld langrem t
fld upproj v 8
fld projurl t
tab projtxt uid proj lang: projtit projdes
fld projtit t
fld projdes t
fld lang v 2
tab projhlp uid proj: hlplvl hlprem faru
tab projdon uid proj: donsum dontyp donvalut donrem
tab projval uid proj: vallvl valrem
tab projprm uid proj prmuid: prmlvl
mov projperm projprm key hom prmuid key perm prmlvl
fld hlplvl n 1
fld hlprem t
fld dontyp n 1
fld donsum n 6
fld donvalut v 3 # 'eur'
fld donrem t
fld vallvl n 2
fld valrem t
fld prmuid v 8
fld prmlvl i
fld prmrem t
tab pass uid: pass
fld pass v 16
tab news uid nbas ndat lang: proj ntit ndes nurl
fld nbas v 8
fld ndat d
fld ntit t
fld ndes t
fld nurl t
tab langtxt uid dok mlid lang: mltxt mlcki
tab mlexp uid dok mlid lang: ciksi ckisku
fld mlid v 16
fld mltxt t
fld mlcki t
fld ciksi v 8
fld ckisku t
tab dokurl dok lang: url
tab zgana uid dok lang: zgalvl
fld zgalvl i
tab wikipags uid wikipag: wikisrc wikitit
fld wikisrc t
fld wikitit t
tab grev uid grevref: grevpag kovrpag grevrem g040407 g040414 g040509 g040512 g040609 grevstd grevstm grevsty grevend grevenm greveny grevtype
fld grevref v 4
fld grevpag t
fld kovrpag t
fld grevrem t
fld g040407 b
fld g040414 b
fld g040509 b
fld g040512 b
fld g040609 b
fld grevtst t
# http://kwiki.ffii.org/MlhtDbHotelsEn
tab hotnokts uid hotel hotrm: hotnokt
fld hotel v 8
fld hotrm v 8
fld hotnokt d
tab mepqs0405 uid mep: m45q1a m45q1b m45q1t m45q2a m45q2b m45q2t m45q3a m45q3b m45q3t m45q4a m45q4b m45q4t m45qt m45qcdate m45qsc removed declined
fld m45q1a v 1
fld m45q1b v 1
fld m45q1t t
fld m45q2a v 1
fld m45q2b v 1
fld m45q2t t
fld m45q3a v 1
fld m45q3b v 1
fld m45q3t t
fld m45q4a v 1
fld m45q4b v 1
fld m45q4t t
fld m45qt t
fld m45qcdate d
fld m45qsc t
fld removed b
fld declined b