mtypmaj


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtypmaj serial 10 √ nextval('seq_mtypmaj'::regclass)
mmajetek.idtypmaj fkcfab66be3435caba R
wextid.idtypmaj wextid_idtypmaj C
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
druhk varchar 50 √ null
jeodpis bool 1 true
workflow bool 1 false
idodpucet int4 10 √ null
uucty.iducet fk1c3b81982f6f8c8e R
idopravucet int4 10 √ null
uucty.iducet fk1c3b81989ffe7739 R
idprotiucetzar int4 10 √ null
uucty.iducet fk1c3b81983769d858 R
iducetobdobido int4 10 √ null
nucetobdobi.iducetobdobi fk1c3b819827752ae R
idstred int4 10 √ null
ustrediska.idstred fk1c3b8198f0c53e9f R
iducetobdobiod int4 10 √ null
nucetobdobi.iducetobdobi fk1c3b819827753f8 R
idzakazky int4 10 √ null
uzakazky.idzakazky fk1c3b8198fa994e2f R
idprimucet int4 10 √ null
uucty.iducet fk1c3b81981d7880f R
idzustvyrazucet int4 10 √ null
uucty.iducet mtypmaj_idzustvyrazucet R
idtyporg int4 10 1
utyporg.idtyporg mtypmaj_idtyporg_vazba R
uuid varchar 50 √ null

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
mtypmaj_pkey Primary key Asc idtypmaj
mtypmaj_idodpucet_index Performance Asc idodpucet
mtypmaj_idopravucet_index Performance Asc idopravucet
mtypmaj_idprimucet_index Performance Asc idprimucet
mtypmaj_idprotiucetzar_index Performance Asc idprotiucetzar
mtypmaj_idstred_index Performance Asc idstred
mtypmaj_iducetobdobido_index Performance Asc iducetobdobido
mtypmaj_iducetobdobiod_index Performance Asc iducetobdobiod
mtypmaj_idzakazky_index Performance Asc idzakazky
mtypmaj_idzustvyrazucet_index Performance Asc idzustvyrazucet
mtypmaj_kod_index Performance Asc kod
mtypmaj_kod_typorg_key Must be unique Asc/Asc kod + idtyporg
mtypmaj_typorg_index Performance Asc idtyporg

Relationships

Close relationships within degrees of separation