uzakazky


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idzakazky serial 10 √ nextval('seq_uzakazky'::regclass)
audalosti.idzakazky audalosti_idzakazky R
ddoklfak.idzakazky fk649d2f40fa994e2f R
ddoklint.idzakazky fk649d3c1ffa994e2f R
ddoklobch.idzakazky fk2f0cd348fa994e2f R
ddoklsklad.idzakazky fkb2ca2c67fa994e2f R
dpolfak.idzakazky fk38c13307fa994e2f R
dpolint.idzakazky fk38c13fe6fa994e2f R
dpolobch.idzakazky fkdf694861fa994e2f R
dpolsklad.idzakazky fkdfc5a6efa994e2f R
dpolskladdoklad.idzakazky Implied Constraint R
dpolskladf.idzakazky Implied Constraint R
dpolskladfbezvc.idzakazky Implied Constraint R
dpolsml.idzakazky dpolsml_idzakazky R
dsmlouvy.idzakazky dsmlouvy_idzakazky R
mdannakl.idzakazky fkf3c0f458fa994e2f R
mdanodpisy.idzakazky fk936a678fa994e2f R
mleasing.idzakazky fka11fef6afa994e2f R
mmajetek.idzakazky fkcfab66befa994e2f R
msplatkal.idzakazky fkb1b6e7e1fa994e2f R
mtypleas.idzakazky fk6b344b69fa994e2f R
mtypmaj.idzakazky fk1c3b8198fa994e2f R
mucetodpisy.idzakazky fk58e7afdefa994e2f R
mudalosti.idzakazky fkf48280e0fa994e2f R
pmzdsloz.idzakazka fk319b3c6bfa994e17 R
ppracestred.idzakazka ppracestred_idzakazka R
pstalamzdsloz.idzakazka fk87a8c236fa994e17 R
udanevid.idzakazky fk32c69288fa994e2f R
wactclenstvi.idzakazky wactclenstvi_idzakazky R
wextid.idzakazka wextid_idzakazka C
wkli_uzakazky.idzakazky wkli_uzakazky_idzakazky R
wparam.idzakazky wparam_idzakazky R
wpriloha.idzakazky wpriloha_idzakazky 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
popis text 2147483647 √ null
poznam text 2147483647 √ null
procvyh numeric 18,6 0.0
show bool 1 true
platido int4 10 9999
platiod int4 10 0
datkonec date 13 √ null
datzahaj date 13 √ null
termin timestamp 29,6 √ null
splatdny int4 10 √ null
pocetpriloh int4 10 0
varsym varchar 30 √ null
idstred int4 10 √ null
ustrediska.idstred fkbe722d56f0c53e9f R
idfirmy int4 10 √ null
aadresar.idfirmy fkbe722d56f7b64b9e R
idmur int4 10 √ null
amisturc.idmur uzakazky_idmur R
idstavzakazky int4 10 √ null
ustavzakazky.idstavzakazky uzakazky_idstavzakazky R
idtypzakazky int4 10 √ null
utypzakazky.idtypzakazky uzakazky_idtypzakazky R
iduzivatel int4 10 √ null
wuzivatel.iduzivatel uzakazky_iduzivatel R
idvyhzakazky int4 10 √ null
uvyhzakazky.idvyhzakazky uzakazky_idvyhzakazky R
idkontaktosoba int4 10 √ null
akontakty.idkontakt zakazky_kontakt_osoba R
rozsah numeric 19,6 0.0
nakladypredpoklad numeric 19,6 0.0
ziskpredpoklad numeric 19,6 0.0
idmena int4 10 √ null
umeny.idmeny uzakazky_idmena R
cisobj varchar 30 √ null
cissml varchar 30 √ null
datzahajplan timestamp 29,6 √ null
datpredaniplan timestamp 29,6 √ null
datpredani timestamp 29,6 √ null
zaruka bool 1 false
datzaruky timestamp 29,6 √ null

Table contained 2 rows

Indexes

Constraint Name Type Sort Column(s)
uzakazky_pkey Primary key Asc idzakazky
uzakazky_idfirmy_index Performance Asc idfirmy
uzakazky_idkontaktosoba_index Performance Asc idkontaktosoba
uzakazky_idmena_index Performance Asc idmena
uzakazky_idmur_index Performance Asc idmur
uzakazky_idstavzakazky_index Performance Asc idstavzakazky
uzakazky_idstred_index Performance Asc idstred
uzakazky_idtypzakazky_index Performance Asc idtypzakazky
uzakazky_iduzivatel_index Performance Asc iduzivatel
uzakazky_idvyhzakazky_index Performance Asc idvyhzakazky
uzakazky_kod_key Must be unique Asc kod

Relationships

Close relationships within degrees of separation