ddoklint


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddoklint serial 10 √ nextval('seq_ddoklint'::regclass)
audalosti.iddoklint audalosti_iddoklint R
catribut.iddoklint catribut_iddoklint C
dpolint.iddoklint fk38c13fe6475a0bcc R
pmzdvazbazav.iddoklint fk42e09a88475a0bcc R
udanevid.iddoklint udanevid_iddoklint R
wextid.iddoklint wextid_iddoklint C
wkli_doklint.iddoklint fk2e7b9635475a0bcc R
wpriloha.iddoklint wpriloha_iddoklint R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
bezpolozek bool 1 false
bic varchar 255 √ null
buc varchar 255 √ null
cisdodak varchar 30 √ null
cisdosle varchar 30 √ null
cisobj text 2147483647 √ null
cissml varchar 30 √ null
datobj date 13 √ null
datreal date 13 √ null
datsplat date 13 √ null
dattermin date 13 √ null
datucto date 13 √ null
datuhr date 13 √ null
datvyst date 13 null
dic varchar 20 √ null
doprava varchar 255 √ null
duzppuv date 13 √ null
duzpucto date 13 √ null
eankod varchar 20 √ null
postovnishodna bool 1 true
fanazev varchar 255 √ null
faeankod varchar 20 √ null
famesto varchar 255 √ null
fapsc varchar 255 √ null
faulice varchar 255 √ null
formauhrk varchar 50 √ null
iban varchar 255 √ null
ic varchar 20 √ null
kod varchar 20 null
kurz numeric 19,6 0.0
kurzmnozstvi numeric 19,6 0.0
mesto varchar 255 √ null
modul varchar 3 null
nazfirmy varchar 255 √ null
pocetpriloh int4 10 0
popis text 2147483647 √ null
poznam text 2147483647 √ null
psc varchar 255 √ null
slevadokl numeric 6,2 0.0
source varchar 50 √ null
specsym varchar 255 √ null
stavuzivk varchar 50 √ null
storno bool 1 false
sumcelkem numeric 15,2 0.0
sumcelkemmen numeric 15,2 0.0
sumdphsniz numeric 15,2 0.0
sumdphsnizmen numeric 15,2 0.0
sumdphsniz2 numeric 15,2 0.0
sumdphsniz2men numeric 15,2 0.0
sumdphzakl numeric 15,2 0.0
sumdphzaklmen numeric 15,2 0.0
sumosv numeric 15,2 0.0
sumosvmen numeric 15,2 0.0
sumzklsniz numeric 15,2 0.0
sumzklsnizmen numeric 15,2 0.0
sumzklsniz2 numeric 15,2 0.0
sumzklsniz2men numeric 15,2 0.0
sumzklzakl numeric 15,2 0.0
sumzklzaklmen numeric 15,2 0.0
sumnaklady numeric 15,2 0.0
szbdphsniz numeric 6,2 0.0
szbdphsniz2 numeric 6,2 0.0
szbdphzakl numeric 6,2 0.0
typpohybuk varchar 50 null
ucetni bool 1 false
ulice varchar 255 √ null
uuid varchar 50 √ null
uvodtxt text 2147483647 √ null
uzptuzemsko bool 1 false
varsym varchar 30 √ null
zamekk varchar 50 √ 'zamek.otevreno'::character varying
zavtxt text 2147483647 √ null
zuctovano bool 1 false
danevidk varchar 50 √ null
jakuhrk varchar 50 √ null
sparovano bool 1 false
idclendph int4 10 √ null
uclendph.idclendph fk649d3c1f9e26e1a5 R
idsazbydphosv int4 10 √ null
usazbydph.idsazbydph fk649d3c1f375c62d8 R
idzakazky int4 10 √ null
uzakazky.idzakazky fk649d3c1ffa994e2f R
idobchtrans int4 10 √ null
iobchtrans.idobchtrans fk649d3c1ffa63738b R
idmur int4 10 √ null
amisturc.idmur fk649d3c1f1e32cb48 R
idstatodesl int4 10 √ null
astaty.idstatu fk649d3c1fe2f2e7fe R
idfirmy int4 10 √ null
aadresar.idfirmy fk649d3c1ff7b64b9e R
iddodpodm int4 10 √ null
idodpodm.iddodpodm fk649d3c1fd855852d R
idkonsym int4 10 √ null
dkonsym.idkonsym fk649d3c1f16d5fb4 R
idsazbydphzakl int4 10 √ null
usazbydph.idsazbydph fk649d3c1f354447b6 R
idstatdph int4 10 √ null
astaty.idstatu fk649d3c1fd3286611 R
iddruhdopr int4 10 √ null
idruhdopr.iddruhdopr fk649d3c1faa8e8951 R
idzvlpoh int4 10 √ null
izvlpoh.idzvlpoh fk649d3c1fa570efa7 R
idpolrady int4 10 √ null
dradyrok.idradyrok fk649d3c1fb3280829 R
idstatpuvod int4 10 √ null
astaty.idstatu fk649d3c1fe308f91b R
idtypdokl int4 10 null
dtypdokl.idtypdokl fk649d3c1f6ba1df4 R
iduziv int4 10 √ null
wuzivatel.iduzivatel fk649d3c1f2ec2f001 R
idmeny int4 10 √ null
umeny.idmeny fk649d3c1fe36cb91d R
idfastatu int4 10 √ null
astaty.idstatu fk649d3c1f408ec4f R
idsmerkod int4 10 √ null
asmerkod.idsmerkod fk649d3c1f42e718e7 R
idbanspojdod int4 10 √ null
abanspoj.idbanspoj fk649d3c1ff3343ea4 R
idstaturc int4 10 √ null
astaty.idstatu fk649d3c1fd328a61b R
idstred int4 10 √ null
ustrediska.idstred fk649d3c1ff0c53e9f R
idkrajurc int4 10 √ null
ikrajurc.idkrajurc fk649d3c1fc6de1917 R
idprimucet int4 10 √ null
uucty.iducet fk649d3c1f1d7880f R
idstatu int4 10 √ null
astaty.idstatu fk649d3c1f43d3196a R
idrady int4 10 √ null
drady.idrady fk649d3c1faae264a R
iddphzaklucet int4 10 √ null
uucty.iducet fk649d3c1f8e40de77 R
idsazbydphsniz int4 10 √ null
usazbydph.idsazbydph fk649d3c1f354149ba R
idsazbydphsniz2 int4 10 √ null
usazbydph.idsazbydph ddoklint_idsazbydphsniz2 R
idprotiucet int4 10 √ null
uucty.iducet fk649d3c1f85077075 R
iddphsnizucet int4 10 √ null
uucty.iducet fk649d3c1f64253e7b R
iddphsniz2ucet int4 10 √ null
uucty.iducet ddoklint_iddphsniz2ucet R
idtypucop int4 10 √ null
utypucop.idtypucop ddoklint_idtypucop R
vatid varchar 20 √ null
generovatskl bool 1 true
zdrojproskl bool 1 true
generacemzdy bool 1 false
zaokrjaksumk varchar 50 √ null
zaokrnasumk varchar 50 √ null
zaokrjakdphk varchar 50 √ null
zaokrnadphk varchar 50 √ null
dphsnizkoef bool 1 false
dphsniz2koef bool 1 false
dphzaklkoef bool 1 false
vyloucitsaldo bool 1 false
vypishash varchar 255 √ null
vypiscisdokl varchar 50 √ null
idbsp int4 10 √ null
dbsp.idbsp dbsp_idbsp R
idbspban int4 10 √ null
dbsp.idbsp dbsp_idbspban R
idcinnost int4 10 √ null
ucinnost.idcinnost fk649d3c1f94e84085 R
idsmlouvy int4 10 √ null
dsmlouvy.idsmlouvy ddoklint_idsmlouvy R
zapocet bool 1 false
idtypdoklskl int4 10 √ null
dtypdokl.idtypdokl ddoklint_idtypdoklskl R
idzodposoba int4 10 √ null
wuzivatel.iduzivatel ddoklfak_iduzivatel_fk R
idkontaktosoba int4 10 √ null
akontakty.idkontakt doklint_kontakt_osoba R
idformauhradycis int4 10 √ null
dformauhradycis.idformauhradycis ddoklint_idformauhradycis R
idformadopravy int4 10 √ null
dformadopravy.idformadopravy ddoklint_idformadopravy R
kontaktjmeno varchar 255 √ null
kontakttel varchar 255 √ null
kontaktemail varchar 255 √ null
ekokomk varchar 50 √ null
balikpocet int4 10 √ 0
balikvytvxml bool 1 false
balikzacislovan bool 1 false
iddodatna int4 10 √ null
aadresar.idfirmy ddoklint_iddodatna R
idclenkonvykdph int4 10 √ null
uclenkonvykdph.idclenkonvykdph ddoklint_idclenkonvykdph R
osobupravadph bool 1 false
cissouhrnne varchar 30 √ null
eetpokladnizarizeni varchar 20 √ null
eetprovozovna int4 10 √ null
eetdicpoverujiciho varchar 20 √ null
eettypk varchar 50 √ null
eetstavk varchar 50 √ null
eetfik text 2147483647 √ null
eetpkp text 2147483647 √ null
eetdatcastrzby timestamp 29,6 √ null
eettisknoutpkp bool 1 true
eetbkp text 2147483647 √ null

Table contained 29 rows

Indexes

Constraint Name Type Sort Column(s)
ddoklint_pkey Primary key Asc iddoklint
ddoklint_cissouhrnne_bsp_ban_index Performance Asc idbsp
ddoklint_danevidk Performance Asc danevidk
ddoklint_dattermin Performance Asc dattermin
ddoklint_datucto Performance Asc datucto
ddoklint_datvyst Performance Asc datvyst
ddoklint_duzppuv Performance Asc duzppuv
ddoklint_duzpucto Performance Asc duzpucto
ddoklint_idbanspojdod_index Performance Asc idbanspojdod
ddoklint_idbsp_index Performance Asc idbsp
ddoklint_idbspban_index Performance Asc idbspban
ddoklint_idcinnost_index Performance Asc idcinnost
ddoklint_idclendph_index Performance Asc idclendph
ddoklint_idclenkonvykdph_index Performance Asc idclenkonvykdph
ddoklint_iddodatna_index Performance Asc iddodatna
ddoklint_iddodpodm_index Performance Asc iddodpodm
ddoklint_iddphsniz2ucet_index Performance Asc iddphsniz2ucet
ddoklint_iddphsnizucet_index Performance Asc iddphsnizucet
ddoklint_iddphzaklucet_index Performance Asc iddphzaklucet
ddoklint_iddruhdopr_index Performance Asc iddruhdopr
ddoklint_idfastatu_index Performance Asc idfastatu
ddoklint_idfirmy_index Performance Asc idfirmy
ddoklint_idformadopravy_index Performance Asc idformadopravy
ddoklint_idformauhradycis_index Performance Asc idformauhradycis
ddoklint_idkonsym_index Performance Asc idkonsym
ddoklint_idkontaktosoba_index Performance Asc idkontaktosoba
ddoklint_idkrajurc_index Performance Asc idkrajurc
ddoklint_idmeny_index Performance Asc idmeny
ddoklint_idmur_index Performance Asc idmur
ddoklint_idobchtrans_index Performance Asc idobchtrans
ddoklint_idpolrady_index Performance Asc idpolrady
ddoklint_idprimucet_index Performance Asc idprimucet
ddoklint_idprotiucet_index Performance Asc idprotiucet
ddoklint_idrady_index Performance Asc idrady
ddoklint_idsazbydphosv_index Performance Asc idsazbydphosv
ddoklint_idsazbydphsniz2_index Performance Asc idsazbydphsniz2
ddoklint_idsazbydphsniz_index Performance Asc idsazbydphsniz
ddoklint_idsazbydphzakl_index Performance Asc idsazbydphzakl
ddoklint_idsmerkod_index Performance Asc idsmerkod
ddoklint_idsmlouvy_index Performance Asc idsmlouvy
ddoklint_idstatdph_index Performance Asc idstatdph
ddoklint_idstatodesl_index Performance Asc idstatodesl
ddoklint_idstatpuvod_index Performance Asc idstatpuvod
ddoklint_idstatu_index Performance Asc idstatu
ddoklint_idstaturc_index Performance Asc idstaturc
ddoklint_idstred_index Performance Asc idstred
ddoklint_idtypdokl_index Performance Asc idtypdokl
ddoklint_idtypdoklskl_index Performance Asc idtypdoklskl
ddoklint_idtypucop_index Performance Asc idtypucop
ddoklint_iduziv_index Performance Asc iduziv
ddoklint_idzakazky_index Performance Asc idzakazky
ddoklint_idzodposoba_index Performance Asc idzodposoba
ddoklint_idzvlpoh_index Performance Asc idzvlpoh
ddoklint_kod_key Must be unique Asc/Asc kod + modul
ddoklint_modul Performance Asc modul
ddoklint_typpohybuk Performance Asc typpohybuk
ddoklint_uuid_unique_key Must be unique Asc uuid
ddoklint_varsym_upper_index Performance
ddoklint_vypishash_bsp_ban_index Performance Asc/Asc vypishash + idbsp

Relationships

Close relationships within degrees of separation