cdodavatele


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddodavatel serial 10 √ nextval('seq_cdodavatele'::regclass)
wextid.iddodavatel wextid_iddodavatel C
wkli_cdodavatele.iddodavatel wkli_cdodavatele_iddodavatel R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
kodindi varchar 20 √ null
nakupcena numeric 19,6 0.0
poznam text 2147483647 √ null
primarni bool 1 false
automgener bool 1 false
stavmj numeric 19,6 √ NULL::numeric
idcenik int4 10 null
ccenik.idcenik cdodavatele_idcenik C
idfirmy int4 10 √ null
aadresar.idfirmy cdodavatele_idfirmy R
idmeny int4 10 √ null
umeny.idmeny cdodavatele_idmeny R
dodacilhuta numeric 19,6 √ null
idmjdodacilhuta int4 10 √ null
cmerjed.idmj cdodavatele_idmjdodacilhuta R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
cdodavatele_pkey Primary key Asc iddodavatel
cdodavatele_idcenik_index Performance Asc idcenik
cdodavatele_idfirmy_index Performance Asc idfirmy
cdodavatele_idmeny_index Performance Asc idmeny
cdodavatele_idmjdodacilhuta_index Performance Asc idmjdodacilhuta
cdodavatele_unique_key Must be unique Asc/Asc/Asc idcenik + idfirmy + idmeny

Relationships

Close relationships within degrees of separation