REQUESTCENTER_TEST38 — ERD (foreign key dichiarate)

Note

Mostra solo le FK dichiarate a livello di database. Molte relazioni Infocad sono applicative (stored procedure / SQL dinamico), non vincoli FK, quindi non appaiono qui.

Note

Grafo troncato ai 40 nodi più connessi (su 60 tabelle estratte). FK complete in db-detail.json.

flowchart LR
  T_CALLTYPE["CALLTYPE"]
  T_CUSTOMLIST["CUSTOMLIST"]
  T_DEFERABILITY["DEFERABILITY"]
  T_FILEEXTENSIONALLOWED["FILEEXTENSIONALLOWED"]
  T_FILETYPE["FILETYPE"]
  T_FLOWTYPE["FLOWTYPE"]
  T_INTERVENTTYPE["INTERVENTTYPE"]
  T_PRICECATEGORY["PRICECATEGORY"]
  T_RC_TENANTCALLTYPE["RC_TENANTCALLTYPE"]
  T_RC_TENANTROLES["RC_TENANTROLES"]
  T_REQUESTAPPROVAL["REQUESTAPPROVAL"]
  T_REQUESTAPPROVALHISTORY["REQUESTAPPROVALHISTORY"]
  T_REQUESTCATEGORY["REQUESTCATEGORY"]
  T_REQUESTCHARGES["REQUESTCHARGES"]
  T_REQUESTCOMPLAINT["REQUESTCOMPLAINT"]
  T_REQUESTCOMPONENT["REQUESTCOMPONENT"]
  T_REQUESTCONTACT["REQUESTCONTACT"]
  T_REQUESTCS["REQUESTCS"]
  T_REQUESTCSREASON["REQUESTCSREASON"]
  T_REQUESTCUSTOMLIST["REQUESTCUSTOMLIST"]
  T_REQUESTFROMTYPE["REQUESTFROMTYPE"]
  T_REQUESTINTERVENT["REQUESTINTERVENT"]
  T_REQUESTINTERVENTACTOR["REQUESTINTERVENTACTOR"]
  T_REQUESTINTERVENTCOMPONENT["REQUESTINTERVENTCOMPONENT"]
  T_REQUESTINTERVENTFILES["REQUESTINTERVENTFILES"]
  T_REQUESTINTERVENTMO["REQUESTINTERVENTMO"]
  T_REQUESTINTERVENTSIGNS["REQUESTINTERVENTSIGNS"]
  T_REQUESTLINKED["REQUESTLINKED"]
  T_REQUESTMAINTACTIVITY["REQUESTMAINTACTIVITY"]
  T_REQUESTMO["REQUESTMO"]
  T_REQUESTREGISTRY["REQUESTREGISTRY"]
  T_REQUESTREGISTRYFILES["REQUESTREGISTRYFILES"]
  T_REQUESTREGISTRYSIGNS["REQUESTREGISTRYSIGNS"]
  T_REQUESTTYPE["REQUESTTYPE"]
  T_REQUESTTYPOLOGY["REQUESTTYPOLOGY"]
  T_REQUESTURGE["REQUESTURGE"]
  T_ROLE["ROLE"]
  T_USERREGISTRY["USERREGISTRY"]
  T_USERROLE["USERROLE"]
  T_USERS["USERS"]
  T_FILETYPE --> T_FILEEXTENSIONALLOWED
  T_PRICECATEGORY --> T_FLOWTYPE
  T_RC_TENANTCALLTYPE --> T_CALLTYPE
  T_RC_TENANTROLES --> T_ROLE
  T_REQUESTAPPROVAL --> T_REQUESTREGISTRY
  T_REQUESTAPPROVAL --> T_ROLE
  T_REQUESTAPPROVAL --> T_USERS
  T_REQUESTAPPROVALHISTORY --> T_USERS
  T_REQUESTAPPROVALHISTORY --> T_REQUESTAPPROVAL
  T_REQUESTCATEGORY --> T_USERS
  T_REQUESTCHARGES --> T_PRICECATEGORY
  T_REQUESTCOMPLAINT --> T_REQUESTREGISTRY
  T_REQUESTCOMPLAINT --> T_USERS
  T_REQUESTCOMPONENT --> T_USERS
  T_REQUESTCOMPONENT --> T_REQUESTMO
  T_REQUESTCONTACT --> T_USERREGISTRY
  T_REQUESTCS --> T_USERS
  T_REQUESTCS --> T_REQUESTCSREASON
  T_REQUESTCS --> T_REQUESTREGISTRY
  T_REQUESTCSREASON --> T_USERS
  T_REQUESTCUSTOMLIST --> T_REQUESTREGISTRY
  T_REQUESTCUSTOMLIST --> T_CUSTOMLIST
  T_REQUESTINTERVENT --> T_USERS
  T_REQUESTINTERVENT --> T_REQUESTREGISTRY
  T_REQUESTINTERVENT --> T_INTERVENTTYPE
  T_REQUESTINTERVENTACTOR --> T_USERS
  T_REQUESTINTERVENTACTOR --> T_REQUESTINTERVENT
  T_REQUESTINTERVENTCOMPONENT --> T_USERS
  T_REQUESTINTERVENTCOMPONENT --> T_REQUESTINTERVENTMO
  T_REQUESTINTERVENTFILES --> T_REQUESTINTERVENT
  T_REQUESTINTERVENTMO --> T_REQUESTINTERVENT
  T_REQUESTINTERVENTMO --> T_USERS
  T_REQUESTINTERVENTSIGNS --> T_ROLE
  T_REQUESTINTERVENTSIGNS --> T_REQUESTINTERVENT
  T_REQUESTLINKED --> T_REQUESTREGISTRY
  T_REQUESTMAINTACTIVITY --> T_REQUESTREGISTRY
  T_REQUESTMO --> T_REQUESTREGISTRY
  T_REQUESTMO --> T_USERS
  T_REQUESTREGISTRY --> T_REQUESTCONTACT
  T_REQUESTREGISTRY --> T_REQUESTTYPE
  T_REQUESTREGISTRY --> T_DEFERABILITY
  T_REQUESTREGISTRY --> T_REQUESTTYPOLOGY
  T_REQUESTREGISTRY --> T_REQUESTFROMTYPE
  T_REQUESTREGISTRY --> T_REQUESTCATEGORY
  T_REQUESTREGISTRY --> T_CALLTYPE
  T_REQUESTREGISTRY --> T_USERS
  T_REQUESTREGISTRYFILES --> T_REQUESTREGISTRY
  T_REQUESTREGISTRYFILES --> T_FILETYPE
  T_REQUESTREGISTRYSIGNS --> T_ROLE
  T_REQUESTREGISTRYSIGNS --> T_REQUESTREGISTRY
  T_REQUESTTYPOLOGY --> T_USERS
  T_REQUESTURGE --> T_USERS
  T_REQUESTURGE --> T_REQUESTREGISTRY
  T_ROLE --> T_ROLE
  T_USERROLE --> T_ROLE
  T_USERROLE --> T_USERS