notificacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idnotificacao int8 19 null
notificacao_aud.idnotificacao Implied Constraint R
idnotificacaoperiodo int8 19 √ null
notificacaoperiodo.idnotificacaoperiodo fk_hdmal376hs3wfqbft89rga8yi R
idorigem int8 19 √ null
sglorigem varchar 10 √ null
idusuario int8 19 null
usuario.idusuario fk_q500lsgft57mihkhqaeidkft6 R
titulo varchar 80 null
data date 13 null
hora varchar 8 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pke06d5afa Primary key Asc idnotificacao
idx5c66d783 Performance Asc idnotificacaoperiodo
idxf8caaed6 Performance Asc idusuario
idxwsversao_e06d5afa Performance Desc wsversao
uc734d4782 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation