astaty


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idstatu serial 10 √ nextval('seq_astaty'::regclass)
aadresar.idfastatu fk7be1c6ed408ec4f R
aadresar.idstatu fk7be1c6ed43d3196a R
abanspoj.idstatu fkab68e20643d3196a R
akontakty.idstatu fk4eff58da43d3196a R
amisturc.idstatu fkff49438843d3196a R
apsc.idstatu apsc_idstatu R
ccenik.idstatu fkaccf7fcb43d3196a R
dbsp.idstatu dbsp_idstatu R
ddoklfak.idfastatu fk649d2f40408ec4f R
ddoklfak.idstatdph fk649d2f40d3286611 R
ddoklfak.idstatodesl fk649d2f40e2f2e7fe R
ddoklfak.idstatpuvod fk649d2f40e308f91b R
ddoklfak.idstatu fk649d2f4043d3196a R
ddoklfak.idstaturc fk649d2f40d328a61b R
ddoklint.idfastatu fk649d3c1f408ec4f R
ddoklint.idstatdph fk649d3c1fd3286611 R
ddoklint.idstatodesl fk649d3c1fe2f2e7fe R
ddoklint.idstatpuvod fk649d3c1fe308f91b R
ddoklint.idstatu fk649d3c1f43d3196a R
ddoklint.idstaturc fk649d3c1fd328a61b R
ddoklobch.idfastatu fk2f0cd348408ec4f R
ddoklobch.idstatdph fk2f0cd348d3286611 R
ddoklobch.idstatodesl fk2f0cd348e2f2e7fe R
ddoklobch.idstatpuvod fk2f0cd348e308f91b R
ddoklobch.idstatu fk2f0cd34843d3196a R
ddoklobch.idstaturc fk2f0cd348d328a61b R
ddoklsklad.idfastatu fkb2ca2c67408ec4f R
ddoklsklad.idstatdph fkb2ca2c67d3286611 R
ddoklsklad.idstatodesl fkb2ca2c67e2f2e7fe R
ddoklsklad.idstatpuvod fkb2ca2c67e308f91b R
ddoklsklad.idstatu fkb2ca2c6743d3196a R
ddoklsklad.idstaturc fkb2ca2c67d328a61b R
dpolprikazuhr.idstatubanky fk37149fd93f46ca1b R
dpolprikazuhr.idstatuprijem fk37149fd97c214775 R
dprikazuhr.idfastatu fk72ed5d1e408ec4f R
dtypdokl.idstatdph fkc4463b53d3286611 R
dtypdokl.idstatodesl fkc4463b53e2f2e7fe R
dtypdokl.idstatpuvod fkc4463b53e308f91b R
dtypdokl.idstaturc fkc4463b53d328a61b R
msplatkal.idstatdph fkb1b6e7e1d3286611 R
mzapujcky.idstatu fk774ab16043d3196a R
nnastav.idfastatu fk45946497408ec4f R
nnastav.idpoststatu nnastav_poststatu_id R
nnastav.idstatu fk4594649743d3196a R
nnastav.idstatuleg fk459464974ba9b8ec R
posoba.idcizpojstatu fkc3adf9fa4248e313 R
posoba.idstatu fkc3adf9fa43d3196a R
posoba.idstatukon fkc3adf9fa4ba9b668 R
posoba.idstatukontuz fkc3adf9fa73713339 R
posoba.idstatunaroz fkc3adf9fa3feff3a8 R
posoba.idstatuobcan fkc3adf9fa3ffe457b R
uclendph.idstatu fk1038baf543d3196a R
uclenkonvykdph.idstatu uclenkonvykdph_idstatu R
usazbydph.idstatu fk525104ae43d3196a R
ustrediska.idstatu ustrediska_idstatu R
utyporg.idstatu fkc36d652e43d3196a R
wreport.idstatu Implied Constraint R
wuzivatel.idstatu fk5925434343d3196a R
lastupdate timestamp 29,6 '2008-01-01 00:00:00'::timestamp without time zone
kod varchar 20 null
koddph varchar 20 null
kodnum varchar 20 √ null
kodalpha3 varchar 20 √ null
nazzemec25 varchar 30 √ null
nazev varchar 255 null
nazeva varchar 255 √ null
nazevb varchar 255 √ null
nazevc varchar 255 √ null
idmeny int4 10 √ null
umeny.idmeny astaty_idmeny R
popis text 2147483647 √ null
poznam text 2147483647 √ null
show bool 1 true
platido int4 10 9999
platiod int4 10 0
cleneu bool 1 false
vatid varchar 20 √ null
vatidmoss varchar 20 √ null
idfukraj int4 10 √ null
aadresar.idfirmy astaty_idfukraj R
idfuuzprac int4 10 √ null
aadresar.idfirmy astaty_idfuuzprac R
telpredvolba varchar 20 √ null
uuid varchar 50 √ null

Table contained 258 rows

Indexes

Constraint Name Type Sort Column(s)
astaty_pkey Primary key Asc idstatu
astaty_kod_key Must be unique Asc kod
astaty_nazev_index Performance Asc nazev

Relationships

Close relationships within degrees of separation