agendanotificacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idagendanotificacao int8 19 null
agendanotificacao_aud.idagendanotificacao Implied Constraint R
idnnotificado int2 5 √ null
sgltiponotificacao varchar 10 null
destinatario varchar 255 √ null
horanotificacao varchar 8 null
datanotificacao date 13 null
idagenda int8 19 null
agenda.idagenda fk_9i8cc0e848lwoehmi3txx5jjq R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkb39abf4e Primary key Asc idagendanotificacao
idxb405f987 Performance Asc idagenda
idxwsversao_b39abf4e Performance Desc wsversao
uc1f4182ce Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation