mleasing


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idleasing serial 10 √ nextval('seq_mleasing'::regclass)
mdannakl.idleasing fkf3c0f458be4b7caa R
msplatkal.idleasing fkb1b6e7e1be4b7caa R
mzapujcky.idleasing fk774ab160be4b7caa R
wextid.idleasing wextid_idleasing C
wkli_mleasing.idleasing fk9e5b74b8be4b7caa R
wpriloha.idleasing wpriloha_idleasing R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
kod varchar 20 null
nazev varchar 255 null
nazeva varchar 255 √ null
nazevb varchar 255 √ null
nazevc varchar 255 √ null
popis text 2147483647 √ null
poznam text 2147483647 √ null
show bool 1 true
platido int4 10 9999
platiod int4 10 0
cena numeric 15,2 0.0
cidporiz varchar 20 0
datkoupe date 13 null
datvyroby date 13 √ null
druhk varchar 50 null
eankod varchar 20 √ null
frekdannaklk varchar 50 √ null
mjzarukyk varchar 50 √ null
pocetdannakl int4 10 0
pocetsplatek int4 10 0
sumsplaceno numeric 15,2 0.0
sumzbyva numeric 15,2 0.0
vyrcis varchar 20 √ null
zamek bool 1 false
zaruka int4 10 0
pocetpriloh int4 10 0
vozcislo varchar 255 √ null
vozspz varchar 255 √ null
vozznacka varchar 255 √ null
vozmodel varchar 255 √ null
voztyp varchar 255 √ null
vozobjem numeric 15,2 0.0
vozhavar varchar 255 √ null
vozhavarvyse numeric 15,2 0.0
vozvybava text 2147483647 √ null
idzakazky int4 10 √ null
uzakazky.idzakazky fka11fef6afa994e2f R
idfirmyvyr int4 10 √ null
aadresar.idfirmy fka11fef6a9096c22d R
idcasucet int4 10 √ null
uucty.iducet fka11fef6aafb08228 R
idstred int4 10 null
ustrediska.idstred fka11fef6af0c53e9f R
idzavazucet int4 10 √ null
uucty.iducet fka11fef6abc8ee63b R
idmeny int4 10 √ null
umeny.idmeny fka11fef6ae36cb91d R
iddphzaklucet int4 10 √ null
uucty.iducet fka11fef6a8e40de77 R
iddphsnizucet int4 10 √ null
uucty.iducet fka11fef6a64253e7b R
idtypleas int4 10 null
mtypleas.idtypleas fka11fef6a5282c088 R
idnaklucet int4 10 √ null
uucty.iducet fka11fef6ab226d8bd R
idfirmydod int4 10 √ null
aadresar.idfirmy fka11fef6a90967d57 R
iduziv int4 10 √ null
wuzivatel.iduzivatel fka11fef6af1048d1d R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
mleasing_pkey Primary key Asc idleasing
mleasing_idcasucet_index Performance Asc idcasucet
mleasing_iddphsnizucet_index Performance Asc iddphsnizucet
mleasing_iddphzaklucet_index Performance Asc iddphzaklucet
mleasing_idfirmydod_index Performance Asc idfirmydod
mleasing_idfirmyvyr_index Performance Asc idfirmyvyr
mleasing_idmeny_index Performance Asc idmeny
mleasing_idnaklucet_index Performance Asc idnaklucet
mleasing_idstred_index Performance Asc idstred
mleasing_idtypleas_index Performance Asc idtypleas
mleasing_iduziv_index Performance Asc iduziv
mleasing_idzakazky_index Performance Asc idzakazky
mleasing_idzavazucet_index Performance Asc idzavazucet
mleasing_kod_key Must be unique Asc kod

Relationships

Close relationships within degrees of separation