Table of Contents

INFOCAD_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 2628 tabelle estratte). FK complete in db-detail.json.

flowchart LR
  T_ACCOUNTING_BUDGET["ACCOUNTING_BUDGET"]
  T_ACCOUNTING_BUDGETDATA["ACCOUNTING_BUDGETDATA"]
  T_ACCOUNTING_BUDGETPROJECTS["ACCOUNTING_BUDGETPROJECTS"]
  T_ACCOUNTING_BUDGETTYPE["ACCOUNTING_BUDGETTYPE"]
  T_ACCOUNTING_CURRENCY["ACCOUNTING_CURRENCY"]
  T_ACCOUNTING_DOCDATA["ACCOUNTING_DOCDATA"]
  T_ACCOUNTING_DOCS["ACCOUNTING_DOCS"]
  T_ACCOUNTING_FISCALYEAR["ACCOUNTING_FISCALYEAR"]
  T_BIM_ENTITYMAPPING["BIM_ENTITYMAPPING"]
  T_BIM_PROJECTDATA["BIM_PROJECTDATA"]
  T_BOOKING_BOOK_INFORMATION["BOOKING_BOOK_INFORMATION"]
  T_BOOKING_USERS["BOOKING_USERS"]
  T_CITTA_["CITTA_"]
  T_COMPRENSORI_["COMPRENSORI_"]
  T_DOCS_DOCUMENT["DOCS_DOCUMENT"]
  T_DOCS_TAG["DOCS_TAG"]
  T_DRAWINGS_GEOMETRYTYPES["DRAWINGS_GEOMETRYTYPES"]
  T_EDIFICI_["EDIFICI_"]
  T_GLOBAL_CATEGORIES["GLOBAL_CATEGORIES"]
  T_GLOBAL_CLIP_WFACTION["GLOBAL_CLIP_WFACTION"]
  T_GLOBAL_COMPANIES["GLOBAL_COMPANIES"]
  T_GLOBAL_CONTACTS["GLOBAL_CONTACTS"]
  T_GLOBAL_COSTCENTRE["GLOBAL_COSTCENTRE"]
  T_GLOBAL_OBJECTS["GLOBAL_OBJECTS"]
  T_GLOBAL_TENANCY["GLOBAL_TENANCY"]
  T_MAINT_JOBLISTS["MAINT_JOBLISTS"]
  T_PIANI_["PIANI_"]
  T_PROJECT["PROJECT"]
  T_REGIONI_["REGIONI_"]
  T_SERV_ACTIVITIES["SERV_ACTIVITIES"]
  T_SERV_CATEGORIES["SERV_CATEGORIES"]
  T_SERV_SUBCATACT["SERV_SUBCATACT"]
  T_SERV_SUBCATEGORIES["SERV_SUBCATEGORIES"]
  T_STOCK_ITEM["STOCK_ITEM"]
  T_VANI_["VANI_"]
  T_WORK_ACC_BUDGET["WORK_ACC_BUDGET"]
  T_WORK_ACC_BUDGET_COSTS_DETAILS["WORK_ACC_BUDGET_COSTS_DETAILS"]
  T_WORK_ACC_FINANCING_DETAILS["WORK_ACC_FINANCING_DETAILS"]
  T_WORK_ACC_FISCALYEAR["WORK_ACC_FISCALYEAR"]
  T_WORK_ACC_SAL["WORK_ACC_SAL"]
  T_ACCOUNTING_BUDGET --> T_ACCOUNTING_BUDGETTYPE
  T_ACCOUNTING_BUDGET --> T_ACCOUNTING_CURRENCY
  T_ACCOUNTING_BUDGET --> T_ACCOUNTING_FISCALYEAR
  T_ACCOUNTING_BUDGET --> T_ACCOUNTING_BUDGET
  T_ACCOUNTING_BUDGETDATA --> T_ACCOUNTING_BUDGETPROJECTS
  T_ACCOUNTING_BUDGETDATA --> T_ACCOUNTING_CURRENCY
  T_ACCOUNTING_BUDGETDATA --> T_ACCOUNTING_BUDGETDATA
  T_ACCOUNTING_BUDGETDATA --> T_ACCOUNTING_BUDGET
  T_ACCOUNTING_BUDGETPROJECTS --> T_ACCOUNTING_BUDGETPROJECTS
  T_ACCOUNTING_BUDGETPROJECTS --> T_ACCOUNTING_BUDGET
  T_ACCOUNTING_BUDGETPROJECTS --> T_ACCOUNTING_CURRENCY
  T_ACCOUNTING_BUDGETTYPE --> T_ACCOUNTING_BUDGETTYPE
  T_ACCOUNTING_DOCDATA --> T_ACCOUNTING_DOCDATA
  T_ACCOUNTING_DOCDATA --> T_ACCOUNTING_DOCS
  T_ACCOUNTING_DOCDATA --> T_ACCOUNTING_CURRENCY
  T_ACCOUNTING_DOCS --> T_ACCOUNTING_BUDGETPROJECTS
  T_ACCOUNTING_DOCS --> T_ACCOUNTING_CURRENCY
  T_ACCOUNTING_DOCS --> T_ACCOUNTING_FISCALYEAR
  T_ACCOUNTING_DOCS --> T_ACCOUNTING_BUDGET
  T_ACCOUNTING_FISCALYEAR --> T_ACCOUNTING_FISCALYEAR
  T_BIM_ENTITYMAPPING --> T_BIM_PROJECTDATA
  T_BIM_ENTITYMAPPING --> T_BIM_ENTITYMAPPING
  T_CITTA_ --> T_REGIONI_
  T_COMPRENSORI_ --> T_CITTA_
  T_DOCS_DOCUMENT --> T_DOCS_DOCUMENT
  T_DOCS_TAG --> T_DOCS_TAG
  T_EDIFICI_ --> T_COMPRENSORI_
  T_GLOBAL_CLIP_WFACTION --> T_GLOBAL_TENANCY
  T_GLOBAL_CONTACTS --> T_GLOBAL_COMPANIES
  T_GLOBAL_COSTCENTRE --> T_GLOBAL_COSTCENTRE
  T_GLOBAL_OBJECTS --> T_GLOBAL_COMPANIES
  T_GLOBAL_OBJECTS --> T_GLOBAL_CATEGORIES
  T_PIANI_ --> T_EDIFICI_
  T_PROJECT --> T_DOCS_DOCUMENT
  T_SERV_ACTIVITIES --> T_SERV_CATEGORIES
  T_SERV_SUBCATACT --> T_SERV_ACTIVITIES
  T_SERV_SUBCATACT --> T_SERV_SUBCATEGORIES
  T_SERV_SUBCATEGORIES --> T_SERV_CATEGORIES
  T_VANI_ --> T_PIANI_
  T_WORK_ACC_BUDGET --> T_WORK_ACC_BUDGET
  T_WORK_ACC_BUDGET --> T_WORK_ACC_FISCALYEAR
  T_WORK_ACC_SAL --> T_WORK_ACC_FISCALYEAR