skarty


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idkarty serial 10 √ nextval('seq_skarty'::regclass)
dpolsklad.idkarty fkdfc5a6e4a595a3 R
dpolskladdoklad.idkarty Implied Constraint R
dpolskladf.idkarty Implied Constraint R
spolinventura.idkarty spolinventura_idkarty R
wextid.idskladkarty wextid_idskladkarty C
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
nazev varchar 255 √ null
nazeva varchar 255 √ null
nazevb varchar 255 √ null
nazevc varchar 255 √ null
cenpopis text 2147483647 √ null
cenpopisa text 2147483647 √ null
cenpopisb text 2147483647 √ null
cenpopisc text 2147483647 √ null
cenpoznam text 2147483647 √ null
datposl date 13 √ null
datstavmj numeric 19,6 0.0
datstavmen numeric 19,6 0.0
datstavtuz numeric 19,6 0.0
maxmj numeric 19,6 0.0
minmj numeric 19,6 0.0
pocatmj numeric 19,6 0.0
pocatmen numeric 19,6 0.0
pocattuz numeric 19,6 0.0
popis text 2147483647 √ null
popisa text 2147483647 √ null
popisb text 2147483647 √ null
popisc text 2147483647 √ null
poslcenamen numeric 19,6 0.0
poslcenatuz numeric 19,6 0.0
poznamvelka text 2147483647 √ null
prumcenamen numeric 19,6 0.0
prumcenatuz numeric 19,6 0.0
rezervmj numeric 19,6 0.0
stavmj numeric 19,6 0.0
stavmjspozadavky numeric 19,6 0.0
pozadavkymj numeric 19,6 0.0
stavmen numeric 19,6 0.0
stavtuz numeric 19,6 0.0
vydexpir bool 1 false
idskladu int4 10 null
dbsp.idbsp skarty_idskladu R
idcenik int4 10 null
ccenik.idcenik fkc88c04ae451651ce R
idmistnost int4 10 √ null
sumisteni.idumisteni skarty_idmistnost R
idregal int4 10 √ null
sumisteni.idumisteni skarty_idregal R
idpolice int4 10 √ null
sumisteni.idumisteni skarty_idpolice R
iducetobdobi int4 10 null
nucetobdobi.iducetobdobi fkc88c04ae93614163 R

Table contained 16 rows

Indexes

Constraint Name Type Sort Column(s)
skarty_pkey Primary key Asc idkarty
skarty_idcenik_idbsp_key Must be unique Asc/Asc/Asc idcenik + idskladu + iducetobdobi
skarty_idcenik_index Performance Asc idcenik
skarty_idmistnost_index Performance Asc idmistnost
skarty_idpolice_index Performance Asc idpolice
skarty_idregal_index Performance Asc idregal
skarty_idskladu_index Performance Asc idskladu
skarty_iducetobdobi_index Performance Asc iducetobdobi

Relationships

Close relationships within degrees of separation