amisturc


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmur serial 10 √ nextval('seq_amisturc'::regclass)
ddoklfak.idmur fk649d2f401e32cb48 R
ddoklint.idmur fk649d3c1f1e32cb48 R
ddoklobch.idmur fk2f0cd3481e32cb48 R
ddoklsklad.idmur fkb2ca2c671e32cb48 R
dpolsml.idmisto dpolsml_idmisto R
uzakazky.idmur uzakazky_idmur R
wextid.idmisturc wextid_idmisturc C
wkli_amisturc.idmur wkli_amisturc_idmisturc R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
mesto varchar 255 √ null
psc varchar 255 √ null
ulice varchar 255 √ null
email varchar 255 √ null
fax varchar 255 √ null
mobil varchar 255 √ null
tel varchar 255 √ null
www varchar 255 √ null
eankod varchar 20 √ null
nazev varchar 255 √ null
popis text 2147483647 √ null
poznam text 2147483647 √ null
primarni bool 1 false
nazev2 varchar 255 √ null
idstatu int4 10 √ null
astaty.idstatu fkff49438843d3196a R
idfirmy int4 10 null
aadresar.idfirmy fkff494388f7b64b9e R
idkontaktosoba int4 10 √ null
akontakty.idkontakt misturc_kontakt_osoba R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
amisturc_pkey Primary key Asc idmur
amisturc_idfirmy_index Performance Asc idfirmy
amisturc_idkontaktosoba_index Performance Asc idkontaktosoba
amisturc_idstatu_index Performance Asc idstatu

Relationships

Close relationships within degrees of separation