chamadocronograma


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idchamadocronograma int8 19 null
chamadocrodependencia.idchamadocronogradepende fk_cbk72ortu8sbcflfwbw7tq1iy R
chamadocrodependencia.idchamadocronograma fk_okg85qyxey5k7nym7xw50c1fh R
chamadocrodependencia_aud.idchamadocronograma Implied Constraint R
chamadocronograma_aud.idchamadocronograma Implied Constraint R
idchamado int8 19 null
chamado.idchamado fk_5vqwcbcu2i0wachxqmuwsqhh1 R
idusuarioresponsavel int8 19 √ null
usuario.idusuario fk_l74sj85msw8eiva5o2vvyivoi R
descricao varchar 80 √ null
datainicio date 13 √ null
datafim date 13 √ null
horainicio varchar 8 √ null
horafim varchar 8 √ null
tempoduracao varchar 18 √ null
percentualconclusao numeric 18,6 √ null
idnacordocomcliente int2 5 null
idtipocronograma int8 19 √ null
tipocronograma.idtipocronograma fk_jp93a76b76kgx8n67ja4bu2dm R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk66098be4 Primary key Asc idchamadocronograma
idx2ed39013 Performance Asc idchamado
idx6b317da3 Performance Asc idtipocronograma
idxe49f5aa1 Performance Asc idusuarioresponsavel
idxwsversao_66098be4 Performance Desc wsversao
uc2a33a638 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation