aadresar


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idfirmy serial 10 √ nextval('seq_aadresar'::regclass)
abanspoj.idfirmy fkab68e206f7b64b9e R
akontakty.idfirmy fk4eff58daf7b64b9e R
amisturc.idfirmy fkff494388f7b64b9e R
astaty.idfukraj astaty_idfukraj R
astaty.idfuuzprac astaty_idfuuzprac R
audalosti.idfirmy fk14d4cd4f7b64b9e R
ccenhladcenikview.idfirmy Implied Constraint R
ccenhladusers.idfirmy Implied Constraint R
ccenhladview.idfirmy Implied Constraint R
ccenik.iddodavatel cenik_dodavatel_vazba R
ccenik.idvyrobce ccenik_idvyrobce R
cchl_adr.idfirmy cchl_adr_idfirmy R
cdodavatele.idfirmy cdodavatele_idfirmy R
codberatele.idfirmy codberatele_idfirmy R
ddoklfak.iddodatna ddoklfak_iddodatna R
ddoklfak.idfirmy fk649d2f40f7b64b9e R
ddoklint.iddodatna ddoklint_iddodatna R
ddoklint.idfirmy fk649d3c1ff7b64b9e R
ddoklobch.iddodatna ddoklobch_iddodatna R
ddoklobch.idfirmy fk2f0cd348f7b64b9e R
ddoklsklad.iddodatna ddoklsklad_iddodatna R
ddoklsklad.idfirmy fkb2ca2c67f7b64b9e R
dpolfak.idfirmy fk38c13307f7b64b9e R
dpolint.idfirmy fk38c13fe6f7b64b9e R
dpolobch.idfirmy fkdf694861f7b64b9e R
dpolsklad.idfirmy fkdfc5a6ef7b64b9e R
dpolskladdoklad.idfirmy Implied Constraint R
dpolsml.idfirmyfakt dpolsml_idfirmyfakt R
dsmlouvy.idfirmy dsmlouvy_idfirmy R
dsmlouvy.idfirmyfakt dsmlouvy_idfirmyfakt R
mleasing.idfirmydod fka11fef6a90967d57 R
mleasing.idfirmyvyr fka11fef6a9096c22d R
mmajetek.idfirmydod fkcfab66be90967d57 R
mmajetek.idfirmyvyr fkcfab66be9096c22d R
nnastav.idfinurad idfinuradfk R
nnastav.idfukraj nnastav_idfukraj R
nnastav.idfuuzemprac nnastav_idfuuzemprac R
nnastav.idmzdadrdan nnastav_idmzdadrdan R
nnastav.idmzdadrsocpoj fk45946497273dc0d5 R
posoba.idzdravpoj fkc3adf9faa5048c67 R
srezervace.idfirmy fk1f4f5aaef7b64b9e R
uzakazky.idfirmy fkbe722d56f7b64b9e R
wactclenstvi.idfirmy wactclenstvi_idfirmy R
wadrcert.idadresar wadrcert_adresar_id R
wextid.idadresar wextid_idadresar C
wkli_aadresar.idfirmy fk791d4c3bf7b64b9e R
wparam.idfirmy wparam_idfirmy R
wpriloha.idadresar wpriloha_idadresar R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
kod varchar 20 null
nazev varchar 255 null
nazeva varchar 255 √ null
nazevb varchar 255 √ null
nazevc varchar 255 √ null
nazev2 varchar 255 √ null
nazev2a varchar 255 √ null
nazev2b varchar 255 √ null
nazev2c varchar 255 √ null
popis text 2147483647 √ null
poznam text 2147483647 √ null
show bool 1 true
platido int4 10 9999
platiod int4 10 0
email varchar 255 √ null
fax varchar 255 √ null
mesto varchar 255 √ null
mobil varchar 255 √ null
psc varchar 255 √ null
tel varchar 255 √ null
ulice varchar 255 √ null
www varchar 255 √ null
bonita int4 10 √ 0
dic varchar 20 √ null
eankod varchar 20 √ null
faeankod varchar 20 √ null
fajmenofirmy varchar 255 √ null
famesto varchar 255 √ null
fapsc varchar 255 √ null
faulice varchar 255 √ null
formexportk varchar 50 √ null
ic varchar 20 √ null
limitfak numeric 15,2 0.0
pocetpriloh int4 10 0
platcedph bool 1 false
specsym varchar 255 √ null
splatdny int4 10 √ null
limitposplatdny int4 10 √ null
limitposplatzakaz bool 1 false
typvztahuk varchar 50 √ null
idfastatu int4 10 √ null
astaty.idstatu fk7be1c6ed408ec4f R
idstred int4 10 √ null
ustrediska.idstred fk7be1c6edf0c53e9f R
idstatu int4 10 √ null
astaty.idstatu fk7be1c6ed43d3196a R
idskupfir int4 10 √ null
askupfir.idskupfir fk7be1c6ed3dd4ae2d R
idskupcen int4 10 √ null
cskupcen.idskupcen aadresar_idskupcen R
idzodposoba int4 10 √ null
wuzivatel.iduzivatel aadresar_iduzivatel_fk R
idformauhradycis int4 10 √ null
dformauhradycis.idformauhradycis aadresar_idformauhradycis R
vatid varchar 20 √ null
postovnishodna bool 1 true
kodpojistovny varchar 20 √ null
nazevpojistovny varchar 255 √ null
osloveni varchar 255 √ null
slevadokl numeric 6,2 0.0
obpautomhotovo bool 1 false
insolvence bool 1 false
nespolehlivyplatce bool 1 false
revize int4 10 0
katastruzemi varchar 255 √ null
parcela varchar 255 √ null
datnaroz date 13 √ null
datzaloz date 13 √ null
rodcis varchar 20 √ null
skrytneuhrfaktnatisku bool 1 false
creditcheckk varchar 50 √ null
canceled bool 1 false
uuid varchar 50 √ null

Table contained 557 rows

Indexes

Constraint Name Type Sort Column(s)
aadresar_pkey Primary key Asc idfirmy
aadresar_dic_upper_index Performance
aadresar_eankod_upper_index Performance
aadresar_ic_upper_index Performance
aadresar_idfastatu_index Performance Asc idfastatu
aadresar_idformauhradycis_index Performance Asc idformauhradycis
aadresar_idskupcen_index Performance Asc idskupcen
aadresar_idskupfir_index Performance Asc idskupfir
aadresar_idstatu_index Performance Asc idstatu
aadresar_idstred_index Performance Asc idstred
aadresar_idzodposoba_index Performance Asc idzodposoba
aadresar_kod_key Must be unique Asc kod
aadresar_mesto_ulice_index Performance Asc/Asc mesto + ulice

Relationships

Close relationships within degrees of separation