DEM_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.

flowchart LR
  T_ABSTRACTIONLAYER["ABSTRACTIONLAYER"]
  T_ACTIVITY["ACTIVITY"]
  T_ACTIVITYPOLICY["ACTIVITYPOLICY"]
  T_ACTIVITYTYPE["ACTIVITYTYPE"]
  T_CATEGORIES["CATEGORIES"]
  T_COMMENTS["COMMENTS"]
  T_ELEMENTSTATEMESSAGE["ELEMENTSTATEMESSAGE"]
  T_ELEMENTSTATEMESSAGELEVELS["ELEMENTSTATEMESSAGELEVELS"]
  T_ELEMENTWORKFLOWDATA["ELEMENTWORKFLOWDATA"]
  T_ELEMENTWORKFLOWHISTORY["ELEMENTWORKFLOWHISTORY"]
  T_ELEMENTWORKFLOWSTATE["ELEMENTWORKFLOWSTATE"]
  T_FILETYPEWORKFLOWACTIVITY["FILETYPEWORKFLOWACTIVITY"]
  T_FILETYPEWORKFLOWSTATE["FILETYPEWORKFLOWSTATE"]
  T_MESSAGELEVEL["MESSAGELEVEL"]
  T_MESSAGEPOLICY["MESSAGEPOLICY"]
  T_NOTIFYWARNING["NOTIFYWARNING"]
  T_POSTS["POSTS"]
  T_ROLES["ROLES"]
  T_SCHEDULENOTIFY["SCHEDULENOTIFY"]
  T_STATE["STATE"]
  T_USERS["USERS"]
  T_USER_ROLES["USER_ROLES"]
  T_WARNING["WARNING"]
  T_WORKFLOW["WORKFLOW"]
  T_WORKFLOWACTIVITY["WORKFLOWACTIVITY"]
  T_WORKFLOWMULTIPLIERS["WORKFLOWMULTIPLIERS"]
  T_WORKFLOWSTATE["WORKFLOWSTATE"]
  T_ABSTRACTIONLAYER --> T_WORKFLOWACTIVITY
  T_ACTIVITY --> T_STATE
  T_ACTIVITY --> T_ACTIVITYTYPE
  T_ACTIVITYPOLICY --> T_WORKFLOWACTIVITY
  T_COMMENTS --> T_POSTS
  T_ELEMENTSTATEMESSAGE --> T_ELEMENTWORKFLOWSTATE
  T_ELEMENTSTATEMESSAGE --> T_ELEMENTWORKFLOWHISTORY
  T_ELEMENTSTATEMESSAGE --> T_WORKFLOWSTATE
  T_ELEMENTSTATEMESSAGELEVELS --> T_MESSAGELEVEL
  T_ELEMENTSTATEMESSAGELEVELS --> T_ELEMENTSTATEMESSAGE
  T_ELEMENTWORKFLOWDATA --> T_WORKFLOWSTATE
  T_ELEMENTWORKFLOWHISTORY --> T_WORKFLOWSTATE
  T_ELEMENTWORKFLOWHISTORY --> T_WORKFLOWACTIVITY
  T_ELEMENTWORKFLOWSTATE --> T_WORKFLOWSTATE
  T_FILETYPEWORKFLOWACTIVITY --> T_WORKFLOWACTIVITY
  T_FILETYPEWORKFLOWSTATE --> T_WORKFLOWSTATE
  T_MESSAGEPOLICY --> T_MESSAGELEVEL
  T_NOTIFYWARNING --> T_WORKFLOWACTIVITY
  T_POSTS --> T_CATEGORIES
  T_SCHEDULENOTIFY --> T_WORKFLOWACTIVITY
  T_USER_ROLES --> T_ROLES
  T_USER_ROLES --> T_USERS
  T_WARNING --> T_WORKFLOWACTIVITY
  T_WORKFLOW --> T_WORKFLOWMULTIPLIERS
  T_WORKFLOWACTIVITY --> T_ACTIVITY
  T_WORKFLOWACTIVITY --> T_WORKFLOW
  T_WORKFLOWACTIVITY --> T_WORKFLOWACTIVITY
  T_WORKFLOWSTATE --> T_STATE
  T_WORKFLOWSTATE --> T_WORKFLOW