departamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddepartamento int8 19 null
chamado.iddeptusuresponsavel fk_9ik3ly3184wo3fupofwj09woc R
chamadoatualizacao.iddepartamento fk_lyf22qbl7xqplm6x7dwlbaf3c R
chamadoatualizacao_aud.iddepartamento Implied Constraint R
chamadolog.iddeptusurespanterior fk_oh4m1sdfrswd9866s5pff2k2x R
chamadolog.iddeptusuresponsavel fk_1f5t75u1ov9wnikshn1l2w41t R
chamadolog.idusuariodepartamento fk_ndbw6r3sx0u4hocfg1waq78xm R
chamadoreabertura.iddeptusureabertura fk_g3fw44clb9cqlpk9dr2cc4b4e R
departamento.iddepartamentosuperior fk_lhgtijh9b6ffrpvgsk6g9a2et R
departamento_aud.iddepartamento Implied Constraint R
usuario.iddepartamento fk_1d4902wfu7tqasjc4sywipvvg R
usuario_aud.iddepartamento Implied Constraint R
iddepartamentosuperior int8 19 √ null
departamento.iddepartamento fk_lhgtijh9b6ffrpvgsk6g9a2et R
idusuarioresponsavel int8 19 √ null
usuario.idusuario fk_ndhkarvga1r4ncymtdeegrbaw R
descricao varchar 80 null
observacao varchar 400 null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkbdc88024 Primary key Asc iddepartamento
idx4eae0858 Performance Asc iddepartamentosuperior
idx7c8b7e32 Performance Asc idusuarioresponsavel
idx8da7232d Performance Asc idusuarioresponsavel
idxwsversao_bdc88024 Performance Desc wsversao
uc11b443b6 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation