sg_solicitudes

436 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sol_id INT 10 √ null
sg_cambio_estado_sol.cae_solicitud fk_sg_cambio_estado_sol_1 R
sol_ult_mod_fecha DATETIME 19 √ null
sol_ult_mod_usuario VARCHAR 45 √ null
sol_ult_mod_origen VARCHAR 45 √ null
sol_version INT 10 √ null
sol_aud INT 10 √ null
sg_audiencias.aud_id fk_sg_solicitudes_1 R
sol_compr INT 10 √ null
sg_compromisos.com_id fk_sg_solicitudes_2 R
sol_modulo VARCHAR 40 √ null
sol_componente VARCHAR 40 √ null
sol_accion VARCHAR 40 √ null
sol_inst BIGINT 19 √ null
ssinstituciones.InsId fk_sg_solicitudes_3 R
sol_ult_estado VARCHAR 45 √ null
sol_leida BIT 1 √ b'0'
sol_usu INT 10 √ null
sg_usuarios.usu_id fk_sg_solicitudes_4 R
sol_deriv INT 10 √ null
sg_derivaciones.der_id fk_sg_solicitudes_5 R
sol_usu_solicitado INT 10 √ null
sg_usuarios.usu_id fk_sg_solicitudes_6 R
sol_convertir_aud_en_comp INT 10 √ null
sg_audiencias.aud_id fk_sg_solicitudes_7 R
sol_comp_convertir_aud_en_comp INT 10 √ null
sg_compromisos.com_id fk_sg_solicitudes_8 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sol_id
fk_sg_solicitudes_1 Performance Asc sol_aud
fk_sg_solicitudes_2 Performance Asc sol_compr
fk_sg_solicitudes_3_idx Performance Asc sol_inst
fk_sg_solicitudes_4_idx Performance Asc sol_usu
fk_sg_solicitudes_5_idx Performance Asc sol_deriv
fk_sg_solicitudes_6_idx Performance Asc sol_usu_solicitado
fk_sg_solicitudes_7_idx Performance Asc sol_convertir_aud_en_comp
fk_sg_solicitudes_8_idx Performance Asc sol_comp_convertir_aud_en_comp

Relationships

Close relationships within degrees of separation