msplatkal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idsplatkal serial 10 √ nextval('seq_msplatkal'::regclass)
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
clensplk varchar 50 √ null
datucto date 13 √ null
datvyst date 13 null
kod varchar 20 null
modul varchar 3 null
poznam text 2147483647 √ null
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 15,2 0.0
typsplk varchar 50 √ null
typszbdphk varchar 50 √ null
ucetni bool 1 false
iddphdalucet int4 10 √ null
uucty.iducet fkb1b6e7e14f7aacdc R
idzakazky int4 10 √ null
uzakazky.idzakazky fkb1b6e7e1fa994e2f R
idzklmducet int4 10 √ null
uucty.iducet fkb1b6e7e1cda078c5 R
idleasing int4 10 null
mleasing.idleasing fkb1b6e7e1be4b7caa R
idzkldalucet int4 10 √ null
uucty.iducet fkb1b6e7e17f8edfd R
idstatdph int4 10 null
astaty.idstatu fkb1b6e7e1d3286611 R
idstred int4 10 null
ustrediska.idstred fkb1b6e7e1f0c53e9f R
iddphmducet int4 10 √ null
uucty.iducet fkb1b6e7e1438be206 R
idclendph int4 10 null
uclendph.idclendph fkb1b6e7e19e26e1a5 R
iddoklfak int4 10 √ null
ddoklfak.iddoklfak fkb1b6e7sssa994e2f R
cisrad int4 10 0

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
msplatkal_pkey Primary key Asc idsplatkal
msplatkal_datvyst_index Performance Asc datvyst
msplatkal_idclendph_index Performance Asc idclendph
msplatkal_iddoklfak_index Performance Asc iddoklfak
msplatkal_iddphdalucet_index Performance Asc iddphdalucet
msplatkal_iddphmducet_index Performance Asc iddphmducet
msplatkal_idleasing_index Performance Asc idleasing
msplatkal_idstatdph_index Performance Asc idstatdph
msplatkal_idstred_index Performance Asc idstred
msplatkal_idzakazky_index Performance Asc idzakazky
msplatkal_idzkldalucet_index Performance Asc idzkldalucet
msplatkal_idzklmducet_index Performance Asc idzklmducet
msplatkal_kod_index Performance Asc kod

Relationships

Close relationships within degrees of separation