dpolint


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpolint serial 10 √ nextval('seq_dpolint'::regclass)
dpolint.idpolintpoplatek dpolint_idpolintpoplatek R
svyrobnicislo.idpolintprijem idpolintprijem_fk N
svyrobnicislo.idpolintvydej idpolintvydej_fk N
wextid.idpolint wextid_idpolint C
wkli_polint.idpolint wkli_polint_idpolint R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
autozaokr bool 1 false
autogen bool 1 false
baleniid int4 10 0
cenjednotka numeric 19,6 0.0
cenamj numeric 19,6 0.0
cenamjnakup numeric 19,6 0.0
cenamjprodej numeric 19,6 0.0
cenamjceniktuz numeric 19,6 0.0
cisrad int4 10 0
datucto date 13 √ null
datvyst date 13 null
eankod varchar 20 √ null
expirace date 13 √ null
dattrvan date 13 √ null
datvyroby date 13 √ null
kod varchar 20 √ null
kopclendph bool 1 true
kopdphdalucet bool 1 true
kopdphmducet bool 1 true
kopklice bool 1 true
kopstred bool 1 true
kopzakazku bool 1 true
kopzkldalucet bool 1 true
kopzklmducet bool 1 true
koptypucop bool 1 true
kopdanevid bool 1 true
kopcinnost bool 1 true
kopdatucto bool 1 true
mnozbaleni numeric 19,6 0.0
mnozmj numeric 19,6 0.0
mnozmjplan numeric 19,6 0.0
mnozmjreal numeric 19,6 0.0
modul varchar 3 null
nazev varchar 255 √ null
nazeva varchar 255 √ null
nazevb varchar 255 √ null
nazevc varchar 255 √ null
objednatk varchar 50 √ null
objem numeric 19,6 0.0
poznam text 2147483647 √ null
proczakl numeric 19,6 0.0
rezervovat bool 1 false
sarze varchar 255 √ null
slevadokl numeric 6,2 0.0
slevamnoz numeric 6,2 0.0
slevapol numeric 6,2 0.0
source varchar 50 √ null
stavuzivk varchar 50 √ null
storno bool 1 false
stornopol bool 1 false
sumdph numeric 15,2 0.0
sumdphmen numeric 15,2 0.0
sumzkl numeric 15,2 0.0
sumzklmen numeric 15,2 0.0
szbdph numeric 6,2 0.0
typcenydphk varchar 50 √ null
typpolozkyk varchar 50 null
typszbdphk varchar 50 √ null
typvypcenyk varchar 50 √ null
ucetni bool 1 false
uplslevadokl bool 1 false
vyrobnicislaok bool 1 false
zaokrjakk varchar 50 √ null
zaokrnak varchar 50 √ null
idzklmducet int4 10 √ null
uucty.iducet fk38c13fe6cda078c5 R
idsazbydph int4 10 √ null
usazbydph.idsazbydph fk38c13fe6791322ee R
idsazbydphpuv int4 10 √ null
usazbydph.idsazbydph dpolint_idsazbydphpuv R
iddphmducet int4 10 √ null
uucty.iducet fk38c13fe6438be206 R
idmj int4 10 √ null
cmerjed.idmj fk38c13fe67af9caba R
idzkldalucet int4 10 √ null
uucty.iducet fk38c13fe67f8edfd R
iddoklint int4 10 null
ddoklint.iddoklint fk38c13fe6475a0bcc R
iddphdalucet int4 10 √ null
uucty.iducet fk38c13fe64f7aacdc R
idbspskl int4 10 √ null
dbsp.idbsp dbsp_idbspskl R
idclendph int4 10 √ null
uclendph.idclendph fk38c13fe69e26e1a5 R
idmeny int4 10 √ null
umeny.idmeny fk38c13fe6e36cb91d R
idzakazky int4 10 √ null
uzakazky.idzakazky fk38c13fe6fa994e2f R
idmjobjem int4 10 √ null
cmerjed.idmj fk38c13fe62002dda9 R
idfirmy int4 10 √ null
aadresar.idfirmy fk38c13fe6f7b64b9e R
idstred int4 10 √ null
ustrediska.idstred fk38c13fe6f0c53e9f R
idcenik int4 10 √ null
ccenik.idcenik fk38c13fe6451651ce R
idcenhlad int4 10 √ null
ccenhlad.idcenhlad dpolint_idcenhlad R
idtypucop int4 10 √ null
utypucop.idtypucop dpolint_idtypucop R
danevidk varchar 50 √ null
idcinnost int4 10 √ null
ucinnost.idcinnost fk38c13fe694e84085 R
generacemzdy bool 1 false
idpolintpoplatek int4 10 √ null
dpolint.idpolint dpolint_idpolintpoplatek R
idpoldobropis int4 10 √ null
zdrojproskl bool 1 true
ekokomk varchar 50 √ null
kopekokom bool 1 true
idclenkonvykdph int4 10 √ null
uclenkonvykdph.idclenkonvykdph dpolint_idclenkonvykdph R
kopclenkonvykdph bool 1 true
ciselnykodzbozi varchar 255 √ null
druhzbozi varchar 255 √ null
zapocet bool 1 false
eettypplatbyk varchar 50 √ null
iddphpren int4 10 √ null
udphpren.iddphpren dpolint_iddphpren_fk R

Table contained 29 rows

Indexes

Constraint Name Type Sort Column(s)
dpolint_pkey Primary key Asc idpolint
dpolint_datucto Performance Asc datucto
dpolint_datvyst_index Performance Asc datvyst
dpolint_idbspskl_index Performance Asc idbspskl
dpolint_idcenhlad_index Performance Asc idcenhlad
dpolint_idcenik_index Performance Asc idcenik
dpolint_idcinnost_index Performance Asc idcinnost
dpolint_idclendph_index Performance Asc idclendph
dpolint_idclenkonvykdph_index Performance Asc idclenkonvykdph
dpolint_iddoklint_index Performance Asc iddoklint
dpolint_iddphdalucet_index Performance Asc iddphdalucet
dpolint_iddphmducet_index Performance Asc iddphmducet
dpolint_iddphpren_index Performance Asc iddphpren
dpolint_idfirmy_index Performance Asc idfirmy
dpolint_idmeny_index Performance Asc idmeny
dpolint_idmj_index Performance Asc idmj
dpolint_idmjobjem_index Performance Asc idmjobjem
dpolint_idpolintpoplatek_index Performance Asc idpolintpoplatek
dpolint_idsazbydph_index Performance Asc idsazbydph
dpolint_idsazbydphpuv_index Performance Asc idsazbydphpuv
dpolint_idstred_index Performance Asc idstred
dpolint_idtypucop_index Performance Asc idtypucop
dpolint_idzakazky_index Performance Asc idzakazky
dpolint_idzkldalucet_index Performance Asc idzkldalucet
dpolint_idzklmducet_index Performance Asc idzklmducet
dpolint_modul Performance Asc modul

Relationships

Close relationships within degrees of separation