Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
_iddefaultgroup.[idunitgroup] unitgroup.[idunitgroup]
alertconf.[idbranch] branch.[idbranch]
alertconf_unitgroup.[idbranch] branch.[idbranch]
device.[idbranch] branch.[idbranch]
device.[serialnumber] device_rnt.[serialnumber]
digital_inputport_cfg_peripheral_template.[idporticon] porticon.[idporticon]
digital_outputport_cfg_peripheral_template.[idoutputport_action] outputport_action.[idoutputport_action]
digital_outputport_cfg_peripheral_template.[idporticon] porticon.[idporticon]
driver.[idbranch] branch.[idbranch]
georeference.[idbranch] branch.[idbranch]
georeferencecategory.[idbranch] branch.[idbranch]
inputoutput.[idincident] incident.[idincident]
macroconf_multifield.[idmacroconf] macroconf.[idmacroconf]
macroconf_processor.[idmayauser] mayauser.[idmayauser]
mayauser.[idbranch] branch.[idbranch]
mayausergroup.[idbranch] branch.[idbranch]
outputport_action.[idporticon] porticon.[idporticon]
ping_request_audit.[idmayauser] ternium_mayauser.[idmayauser]
port.[idperipheral] peripheral.[idperipheral]
shipperconf.[idbranch] branch.[idbranch]
technicalaccount.[idbranch] branch.[idbranch]
tmp_device.[idbranch] branch.[idbranch]
tmp_device.[idmodeldevice] devicemodel.[idmodeldevice]
tmp_device.[idproduct] product.[idproduct]
tmp_device.[idtechnicalaccount] technicalaccount.[idtechnicalaccount]
tmp_device.[serialnumber] device_rnt.[serialnumber]
tmp_event_code.[idmodeldevice] devicemodel.[idmodeldevice]
tmp_port.[idperipheral] peripheral.[idperipheral]
tmp_port.[idporttype] porttype.[idporttype]
unit.[idbranch] branch.[idbranch]
unit_driverloginconf.[iddriverloginconf] driverloginconf.[iddriverloginconf]
unitgroup.[idbranch] branch.[idbranch]
vehicle.[idvehicle_class] vehicle_class.[idvehicle_class]

Tables without indexes

Table
_iddefaultgroup
event0
event_archive
event_restored
note
outage
t1
tmp_device
tmp_event_code
tmp_geofence_history
tmp_port

Tables that contain a single column

Table Column
_iddefaultgroup idunitgroup
portcfg idport
t1 ?column?

Tables with incrementing column names, potentially indicating denormalization

Table
gnx_retried_commands
serialcfg
serialcfg_peripheral
serialcfg_peripheral_template

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected