audalosti


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idudalost serial 10 √ nextval('seq_audalosti'::regclass)
akon_audalost.idudalost akon_audalost_idudalost R
anaklakt.idadrudalost anaklakt_idadrudalost R
wextid.idadrudalost wextid_idadrudalost C
wkli_audalost.idudalost fk9a2d7f83649a3d32 R
wpriloha.idadrudalost wpriloha_idadrudalost R
wuziv_audalost.idudalost wuziv_audalost_idudalost R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
celodenni bool 1 √ true
dokonceni timestamp 29,6 √ null
druhudalk varchar 50 √ null
pocetpriloh int4 10 0
predmet varchar 255 √ null
prioritak varchar 50 √ null
stavudalk varchar 50 √ null
termin timestamp 29,6 √ null
umisteni varchar 255 √ null
volno bool 1 √ true
zahajeni timestamp 29,6 √ null
popis text 2147483647 √ null
poznam text 2147483647 √ null
idfirmy int4 10 √ null
aadresar.idfirmy fk14d4cd4f7b64b9e R
idtypakt int4 10 √ null
atypakt.idtypakt audalosti_idtypakt R
iduzivatel int4 10 √ null
wuzivatel.iduzivatel audalosti_iduzivatel R
idzakazky int4 10 √ null
uzakazky.idzakazky audalosti_idzakazky R
iddoklfak int4 10 √ null
ddoklfak.iddoklfak audalosti_iddoklfak R
iddoklint int4 10 √ null
ddoklint.iddoklint audalosti_iddoklint R
iddoklobch int4 10 √ null
ddoklobch.iddoklobch audalosti_iddoklobch R
iddoklsklad int4 10 √ null
ddoklsklad.iddoklsklad audalosti_iddoklsklad R
idcenik int4 10 √ null
ccenik.idcenik audalosti_idcenik R
idkontakt int4 10 √ null
akontakty.idkontakt audalosti_idkontakt R
idkonektor int4 10 √ null
wkonektor.idkonektor audalosti_idkonektor R
idreport int4 10 √ null
wreport.idreport audalosti_idreport R
idsmlouvy int4 10 √ null
dsmlouvy.idsmlouvy audalosti_idsmlouvy R
idpolsml int4 10 √ null
dpolsml.idpolsml audalosti_idpolsml R
processdefinitionid varchar 63 √ null
taskdefinitionkey varchar 255 √ null
actrutask varchar 63 √ null
idmajetek int4 10 √ null
mmajetek.idmajetku audalosti_idmajetek R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
audalosti_pkey Primary key Asc idudalost
audalosti_actrutask_index Performance Asc actrutask
audalosti_idcenik_index Performance Asc idcenik
audalosti_iddoklfak_index Performance Asc iddoklfak
audalosti_iddoklint_index Performance Asc iddoklint
audalosti_iddoklobch_index Performance Asc iddoklobch
audalosti_iddoklsklad_index Performance Asc iddoklsklad
audalosti_idfirmy_index Performance Asc idfirmy
audalosti_idkonektor_index Performance Asc idkonektor
audalosti_idkontakt_index Performance Asc idkontakt
audalosti_idmajetek_index Performance Asc idmajetek
audalosti_idpolsml_index Performance Asc idpolsml
audalosti_idreport_index Performance Asc idreport
audalosti_idsmlouvy_index Performance Asc idsmlouvy
audalosti_idtypakt_index Performance Asc idtypakt
audalosti_iduzivatel_index Performance Asc iduzivatel
audalosti_idzakazky_index Performance Asc idzakazky
audalosti_processdefinitionid_index Performance Asc processdefinitionid
audalosti_taskdefinitionkey_index Performance Asc taskdefinitionkey
audalosti_zahajeni_index Performance Asc zahajeni

Relationships

Close relationships within degrees of separation