Business Entities and Systems - TDM DB Tables

TDM settings are saved in the TDM PostgreSQL DB.

Business Entity (BE) and System definitions update the following TDM DB tables:

Business_Entities

This table holds all BEs defined in the TDM Portal.

  • A new record is created for each BE.

  • Each BE is created in Active status and gets a unique be_id sequence, which is the table's PK.

  • Deleted BEs have an Inactive status and are not physically deleted from this table.

Note that to prevent creating several active BEs with the same name, the be_name column has a unique index when the status is Active.

Products

This table holds all systems (products) defined in the TDM Portal.

  • A new record is created for each system.
  • Each system (product) is created in Active status and gets a unique product_id sequence which is the table's PK.
  • Deleted systems have an Inactive status and are not physically deleted from this table.

Note that to prevent creating several active systems with the same name, the product_name column has a unique index when the status is Active.

Product_Logical_Units

This table holds the links between a BE, LU and a system (product), as follows:

  • Links between LUs and a BE.
  • Links between parent-child LU relationships in a BE.
  • Links between a BE and its LUs to a system (product). Each BE and LU combination can be attached to a system.

Adding an LU to a BE creates a new record in this table. Each record is marked with a unique lu_id sequence which is the table's PK. The table contains the following information:

  • LU information - lu_id, lu_name, lu_description and lu_dc_name columns.
  • BE information - be_id column. This is the link to the business_entities table.
  • LU relationship in the BE - lu_parent_id and lu_parent_name columns holding the ID and name of the parent LU if it exists.
  • System (product) information - product_id and product_name columns. The product_id links to the Products table. The product_id and product_name columns are set to -1 and NULL default values when the record is created. System Information settings are defined when an LU is attached to a system. If the LU is deleted from a system, the system information's columns return to their default values.

TDM_BE_Post_Exe_Process

This table holds a list of Post-Execution Processes attached to each BE. A separate record is created for each post-execution process. Each record is marked with a unique process_id sequence which is the table's PK.

The following information is stored in this table:

  • Process Information - process_id, process_name, process_description and execution_order columns.

  • BE information - be_id column that links to the business_entities table.

    Previous

Business Entities and Systems - TDM DB Tables

TDM settings are saved in the TDM PostgreSQL DB.

Business Entity (BE) and System definitions update the following TDM DB tables:

Business_Entities

This table holds all BEs defined in the TDM Portal.

  • A new record is created for each BE.

  • Each BE is created in Active status and gets a unique be_id sequence, which is the table's PK.

  • Deleted BEs have an Inactive status and are not physically deleted from this table.

Note that to prevent creating several active BEs with the same name, the be_name column has a unique index when the status is Active.

Products

This table holds all systems (products) defined in the TDM Portal.

  • A new record is created for each system.
  • Each system (product) is created in Active status and gets a unique product_id sequence which is the table's PK.
  • Deleted systems have an Inactive status and are not physically deleted from this table.

Note that to prevent creating several active systems with the same name, the product_name column has a unique index when the status is Active.

Product_Logical_Units

This table holds the links between a BE, LU and a system (product), as follows:

  • Links between LUs and a BE.
  • Links between parent-child LU relationships in a BE.
  • Links between a BE and its LUs to a system (product). Each BE and LU combination can be attached to a system.

Adding an LU to a BE creates a new record in this table. Each record is marked with a unique lu_id sequence which is the table's PK. The table contains the following information:

  • LU information - lu_id, lu_name, lu_description and lu_dc_name columns.
  • BE information - be_id column. This is the link to the business_entities table.
  • LU relationship in the BE - lu_parent_id and lu_parent_name columns holding the ID and name of the parent LU if it exists.
  • System (product) information - product_id and product_name columns. The product_id links to the Products table. The product_id and product_name columns are set to -1 and NULL default values when the record is created. System Information settings are defined when an LU is attached to a system. If the LU is deleted from a system, the system information's columns return to their default values.

TDM_BE_Post_Exe_Process

This table holds a list of Post-Execution Processes attached to each BE. A separate record is created for each post-execution process. Each record is marked with a unique process_id sequence which is the table's PK.

The following information is stored in this table:

  • Process Information - process_id, process_name, process_description and execution_order columns.

  • BE information - be_id column that links to the business_entities table.

    Previous