controledocumento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcontroledocumento int8 19 null
controledocumento_aud.idcontroledocumento Implied Constraint R
controledocumentoanexo.idcontroledocumento fk_b682djtvngfx3gcg6dfo03ycx R
controledocumentoanexo_aud.idcontroledocumento Implied Constraint R
fluxocontrole.idcontroledocumento fk_in85ee6rwnc4pi5bxnol37qa8 R
fluxocontrole_aud.idcontroledocumento Implied Constraint R
idgrupotipodocumento int8 19 null
grupotipodocumento.idgrupotipodocumento fk_nlaj46x525ot6ld8x7tntvfi9 R
idlocal int8 19 √ null
local.idlocal fk_6hml4962g5p5qasujmy0kijc8 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_on4si707fg9hp9fdjjqvq9576 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk4cff68cc Primary key Asc idcontroledocumento
idx31012c83 Performance Asc idparceiro
idx3d7d1169 Performance Asc idgrupotipodocumento
idxc35f4856 Performance Asc idlocal
idxwsversao_4cff68cc Performance Desc wsversao
ucce262e10 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation