Tables


SchemaSpy Analysis of Flexibee_DB.public

Generated on St Dub 11 01:09 CEST 2018

XML Representation
Insertion Order Deletion Order
TABLES 250
VIEWS 9
COLUMNS 5221
Constraints 1040

Database Properties

Database Type: PostgreSQL - 9.3.4

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
aadresar 48 7 68 557 Table
abanspoj 11 5 20 12 Table
act_ge_bytearray 4 1 6 0 Table
act_ge_property 0 0 3 3 Table
act_hi_actinst 0 0 13 0 Table
act_hi_attachment 0 0 10 0 Table
act_hi_comment 0 0 9 0 Table
act_hi_detail 0 0 15 0 Table
act_hi_procinst 0 0 12 0 Table
act_hi_taskinst 0 0 18 0 Table
act_hi_varinst 0 0 12 0 Table
act_id_group 0 0 4 0 View
act_id_info 0 0 8 0 Table
act_id_membership 0 0 2 0 View
act_id_user 0 0 7 0 View
act_re_deployment 2 0 4 0 Table
act_re_model 0 3 12 0 Table
act_re_procdef 3 0 12 0 Table
act_ru_event_subscr 0 1 9 0 Table
act_ru_execution 9 4 14 0 Table
act_ru_identitylink 0 3 8 0 Table
act_ru_job 0 1 16 0 Table
act_ru_task 1 3 16 0 Table
act_ru_variable 0 3 12 0 Table
akon_audalost 0 2 2 0 Table
akontakty 12 2 35 11 Table
amisturc 8 3 19 0 Table
anaklakt 0 4 12 0 Table
apsc 0 1 18 20776 Table
askupfir 3 3 17 2 Table
asmerkod 7 0 13 79 Table
astaty 58 3 24 258 Table
atypakt 3 1 14 4 Table
atypnaklakt 2 1 12 0 Table
audalosti 6 15 33 0 Table
catribut 0 6 14 0 Table
ccenhlad 12 1 36 0 Table
ccenhladcenikview 0 6 40 0 View
ccenhladusers 0 4 38 0 View
ccenhladview 0 6 40 0 View
ccenik 39 12 123 18 Table
cchl_adr 0 2 2 0 Table
cchl_cen 0 2 2 0 Table
cchl_skz 0 2 2 0 Table
cdodavatele 2 4 13 0 Table
cekokom 0 1 18 0 Table
changelog 0 0 8 0 Table
ckusovnik 2 3 13 0 Table
cmerjed 21 0 19 4 Table
codberatele 1 5 13 0 Table
cpodobne 1 2 5 0 Table
cpoplatky 1 2 6 0 Table
cprislusenstvi 0 2 5 0 Table
csady 1 2 6 0 Table
cskc_chl 0 2 2 0 Table
cskupcen 6 0 12 0 Table
cskupzboz 7 7 40 6 Table
cstavcen 2 0 13 5 Table
ctypatribut 2 1 17 79 Table
ctypatribut_typzbozi 0 2 2 67 Table
ctypzbozi 2 0 15 3 Table
dautotisk 0 1 8 4 Table
dbsp 29 12 53 5 Table
dbversion 0 0 5 2 Table
dcislobal 0 4 7 0 Table
ddoklfak 13 46 177 47 Table
ddoklint 8 45 157 29 Table
ddoklobch 7 47 143 0 Table
ddoklsklad 8 46 140 22 Table
deetkom 0 0 30 0 Table
delbanformat 1 0 19 16 Table
dformadopravy 7 1 31 9 Table
dformauhrady 1 3 14 0 Table
dformauhradycis 9 1 21 8 Table
dformauhradyzauc 0 3 5 0 Table
dkonsym 7 0 13 15 Table
dpolfak 6 22 100 70 Table
dpolint 5 22 99 29 Table
dpolobch 4 22 96 0 Table
dpolprikazuhr 0 6 31 0 Table
dpolsklad 9 22 101 31 Table
dpolskladdoklad 0 11 75 0 View
dpolskladf 0 5 19 0 View
dpolskladfbezvc 0 4 15 0 View
dpolsml 5 12 46 0 Table
dprikazuhr 1 3 19 0 Table
drady 9 0 15 26 Table
dradydiry 0 1 4 4 Table
dradyrok 5 2 10 26 Table
dsmlouvy 9 10 52 0 Table
dstavsml 3 0 13 0 Table
dtypdokl 71 31 86 40 Table
dtypsml 3 2 32 0 Table
dvazebtab 0 0 8 82 Table
dzurnalsml 0 1 8 0 Table
hook 0 0 8 0 Table
idodpodm 5 0 13 18 Table
idruhdopr 5 0 13 8 Table
iintrmerjed 1 0 13 44 Table
ikrajurc 5 0 13 20 Table
inomen 1 1 14 17421 Table
iobchtrans 5 0 13 44 Table
izvlpoh 5 0 13 12 Table
mdannakl 0 5 15 0 Table
mdanodpisy 0 5 17 15 Table
mleasing 6 12 49 0 Table
mmajetek 8 16 68 7 Table
msazby 1 0 24 32 Table
msplatkal 0 10 27 0 Table
mtypleas 2 10 23 1 Table
mtypmaj 2 10 24 4 Table
mucetodpisy 0 5 16 180 Table
mudalosti 0 7 24 5 Table
mumisteni 4 0 12 0 Table
mzapujcky 0 4 19 0 Table
nnastav 1 64 205 1 Table
nucetobdobi 15 0 10 1 Table
pcismzdsloz 11 0 59 352 Table
pdite 5 1 12 0 Table
pdite_posoba 0 2 2 0 Table
pmzdcalc 1 4 33 8014 Table
pmzdcalchlav 4 1 13 12 Table
pmzdcalchrom 0 3 18 12 Table
pmzdcalcinit 0 3 19 277 Table
pmzdsloz 3 9 44 0 Table
pmzdvazbazav 0 4 9 0 Table
pmzdyparam 0 0 4 38 Table
pnepritomnost 3 3 10 0 Table
posoba 3 15 109 0 Table
posobahlav 15 0 7 0 Table
ppracestred 1 5 14 0 Table
ppracpom 1 11 50 0 Table
ppracpomhlav 7 1 10 0 Table
pskuposob 3 8 22 0 Table
psmeny 1 3 9 0 Table
psrazka 2 5 25 0 Table
pstalamzdsloz 3 5 30 0 Table
ptyppracpom 3 0 12 11 Table
ptyppracpomparam 0 3 29 371 Table
sfifovazby 0 3 5 0 Table
sinventura 2 1 12 0 Table
skarty 5 6 42 16 Table
smapsklad 1 4 6 0 Table
spolinventura 0 7 28 0 Table
srezervace 0 5 12 0 Table
stavcen_cenik 0 2 2 0 Table
sumisteni 3 0 13 0 Table
svazbypolsklad 0 0 3 0 Table
svyrobnicislo 3 9 11 0 Table
svyrobnicislohlav 1 1 3 0 Table
ucinnost 15 0 13 0 Table
uclendph 11 1 21 215 Table
uclenkonvykdph 9 1 18 30 Table
udanevid 0 7 15 0 Table
udphpren 5 0 14 54 Table
ukurzy 1 1 11 2 Table
umeny 27 0 16 50 Table
uobraty 0 5 14 65 Table
uradekpriznanidph 0 2 12 0 Table
usazbydph 26 1 10 122 Table
usesradky 11 1 21 624 Table
usesrozpaduce 0 2 10 0 Table
usesstdpred 0 2 9 1762 Table
usessumace 0 2 5 810 Table
usestavy 2 8 68 7 Table
usesuzivpred 0 2 8 0 Table
ustavzakazky 1 0 11 4 Table
ustducty 2 1 17 349 Table
ustrediska 41 1 33 1 Table
utyporg 11 1 13 4 Table
utypucop 27 6 31 39 Table
utypzakazky 2 2 16 2 Table
uucty 95 5 28 79 Table
uvyhzakazky 1 0 12 0 Table
uzakazky 32 9 38 2 Table
wactclenstvi 0 5 8 0 Table
wactdefinice 0 1 16 0 Table
wactskupina 1 0 14 0 Table
wadrcert 1 1 9 0 Table
wadrcertcipher 0 1 4 0 Table
wautcert 1 0 7 11 Table
wautcertcipher 0 1 3 11 Table
wcolumn 0 1 9 2220 Table
wcustbutton 1 0 9 0 Table
wdashboardpanel 1 1 16 3 Table
wdashboardsharing 0 2 6 0 Table
wdataprava 0 1 6 0 Table
wdotaz_wreport 0 2 2 0 Table
wdotazy 4 1 17 16 Table
wdotazyparam 1 1 17 10 Table
wdotazyprop 1 1 18 97 Table
wextid 0 75 79 2 Table
wfiltry 0 1 11 0 Table
wkli_aadresar 0 2 3 1 Table
wkli_akontakt 0 2 3 0 Table
wkli_amisturc 0 2 3 0 Table
wkli_atypakt 0 2 3 0 Table
wkli_audalost 0 2 3 0 Table
wkli_cdodavatele 0 2 3 0 Table
wkli_cenik 0 2 3 0 Table
wkli_cskupzboz 0 2 3 0 Table
wkli_dbsp 0 2 3 0 Table
wkli_dformadopravy 0 2 3 0 Table
wkli_dformauhrady 0 2 3 0 Table
wkli_dformauhradycis 0 2 3 0 Table
wkli_doklfak 0 2 3 0 Table
wkli_doklint 0 2 3 0 Table
wkli_doklobch 0 2 3 0 Table
wkli_doklsklad 0 2 3 0 Table
wkli_dstavsml 0 2 3 0 Table
wkli_dtypsml 0 2 3 0 Table
wkli_mleasing 0 2 3 0 Table
wkli_mmajetek 0 2 3 0 Table
wkli_pmzdsloz 0 2 3 0 Table
wkli_pnepritomnost 0 2 3 0 Table
wkli_polfak 0 2 3 0 Table
wkli_polint 0 2 3 0 Table
wkli_polobch 0 2 3 0 Table
wkli_polsklad 0 2 3 0 Table
wkli_polsml 0 2 3 0 Table
wkli_pstalamzdsloz 0 2 3 0 Table
wkli_smlouva 0 2 3 0 Table
wkli_stavcen 0 2 3 0 Table
wkli_typzbozi 0 2 3 0 Table
wkli_ucinnost 0 2 3 0 Table
wkli_ustredisko 0 2 3 0 Table
wkli_uzakazky 0 2 2 0 Table
wkli_wuzivatel 0 2 3 0 Table
wkli_wvazbatyp 0 2 3 0 Table
wkli_zdite 0 2 3 0 Table
wkli_zosoba 0 2 3 0 Table
wkonektor 2 2 19 0 Table
wlocks 0 0 6 0 Table
wlokcis 0 0 8 901 Table
wokna 0 1 7 33 Table
woscert 1 1 12 1 Table
woscertcipher 0 1 3 1 Table
wparam 0 8 13 0 Table
wpriloha 2 20 37 0 Table
wprilohadata 1 0 3 0 Table
wpristprava 0 1 6 0 Table
wreport 4 3 15 0 Table
wrole 5 2 15 10 Table
wsablona 0 0 31 4 Table
wsetting 0 1 4 41 Table
wskupvybklic 2 0 13 0 Table
wstrom 1 1 16 1 Table
wtexty 1 0 25 0 Table
wuzel 4 2 19 3 Table
wuziv_audalost 0 2 2 0 Table
wuzivatel 40 2 28 2 Table
wvazba 1 1 21 0 Table
wvazbatyp 3 0 22 0 Table
wvazuzel 1 1 4 0 Table
wvybklice 39 1 33 3 Table
wxslt 0 0 11 0 Table
wzamky 0 0 23 0 Table
wzastupnosti 1 2 12 0 Table
wzurnal 0 0 10 13248 Table