sg_alertas

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ale_id INT 10 √ null
sg_alerta_destinatario.ale_id FKsngjrv5bob4c91dn0yaa42nl8 R
ale_codigo VARCHAR 45 √ null
ale_habilitado BIT 1 √ null
ale_nombre VARCHAR 255 √ null
ale_ult_mod_fecha DATETIME 19 √ null
ale_ult_mod_origen VARCHAR 45 √ null
ale_ult_mod_usuario VARCHAR 45 √ null
ale_version INT 10 √ null
ale_tolerancia_dias INT 10 √ null
ale_plantilla_mail INT 10 √ null
sg_plantillas.pla_id FKjkwqnvf907430hino59u10ua4 R
ale_delay_minutos INT 10 √ null
ale_disparador INT 10 √ null
sg_disparadores.dis_id FKgnie5tmo3jf2omf7e04dq08tf R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ale_id
FKgnie5tmo3jf2omf7e04dq08tf Performance Asc ale_disparador
FKjkwqnvf907430hino59u10ua4 Performance Asc ale_plantilla_mail
UKblm29ca53f19m8pahlqe5yqkl Must be unique Asc ale_codigo

Relationships

Close relationships within degrees of separation