parceiroanotacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idparceiroanotacao int8 19 null
parceiroanotacao_aud.idparceiroanotacao Implied Constraint R
idparceiro int8 19 null
parceiro.idparceiro fk_cx3ucy7qvwdx4ctut7a42g2kk R
idlocal int8 19 √ null
local.idlocal fk_qesfhd3i5fmfoh9tt0kogl8om R
idusuario int8 19 null
usuario.idusuario fk_g5ntuwq0si6hr4o50cja74axm R
idnivelimportancia int8 19 √ null
nivelimportancia.idnivelimportancia fk_9yj9d6wsr02xqoa1kbpwj9t2y R
datacadastro date 13 null
horacadastro varchar 8 null
titulo varchar 80 null
observacao varchar 4000 √ null
idtiposituacaoanotacao int8 19 √ null
tiposituacaoanotacao.idtiposituacaoanotacao fk_480g9g5c6w502st5lwal07xkc R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk677ffba5 Primary key Asc idparceiroanotacao
idx5be6d565 Performance Asc idnivelimportancia
idx745d9224 Performance Asc idtiposituacaoanotacao
idx801f8e70 Performance Asc idusuario
idx982f75e1 Performance Asc idparceiro
idxf92ed9c0 Performance Asc idlocal
idxwsversao_677ffba5 Performance Desc wsversao
uc63678a75 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation