Data Cache Data Model

dcr_id

decimal

Data Container ID

☑

Reference to a data container.

tbe_check_count_rows_max

decimal

Check Count of Rows (Max)

☐

Maximum number of rows that all table partitions of this table should contain.

tbe_check_count_rows_min

decimal

Check Count of Rows (Min)

☐

Minimum number of rows that all table partitions of this table should contain.

tbe_created_at

string(60)

Created in

☑

The code of the function in the modules table from within which the user created the record. This value will never change after creation of the record.

tbe_created_by

string(60)

Created by

☑

Who created the record.

tbe_date_created

datetime

Created at

☑

The system time in UTC at which the record was created. This value will never change after creation of the record.

tbe_date_lv_last_got_created

datetime

Date Logical View Last Got Created

☐

Date/time at which the overall and/or partition logical views were last maintained.

tbe_date_modified

datetime

Updated at

☑

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

tbe_facts_table_name

string(30)

Facts Table Name

☑

Name of the facts table with last downloaded data for this table.

tbe_fragment_code

string(5)

Table Name Fragment Code

☑

Random sequence of characters used to compose the name of the facts table with.

tbe_full_qualified_name

string(240)

Full Qualified Name

☑

Full qualified name of the table to be downloaded.

tbe_history_table_md5

string(60)

MD5 of History Table

☐

MD5 of the SQL used to create the history table.

tbe_history_table_name

string(30)

History Table Name

☑

Name of the history table with current and all previous seen data for this table.

tbe_id

decimal

ID

☑

Unique identifier.

tbe_index_facts_table_flag

string(1)

Index Facts Table?

☑

Whether indexes on facts table must be created and maintained.

tbe_index_history_table_flag

string(1)

Index History Table?

☑

Whether indexes on history table must be created and maintained.

tbe_lv_overall_active_flag

string(1)

Maintain Overall Logical Views

☑

Whether overall logical views must be created and maintained.

tbe_lv_overall_view_name

string(240)

Name of Overall Logical View

☐

Name of the overall logical view.

tbe_lv_ptn_active_flag

string(1)

Maintain Partition Logical Views

☑

Whether partition logical views must be created and maintained.

tbe_lv_ptn_view_name_postfix

string(30)

Postfix Partition Logical View Name

☐

Postfix for the name of a partition logical view.

tbe_lv_ptn_view_name_prefix

string(30)

Prefix Partition Logical View Name

☐

Prefix for the name of a partition logical view.

tbe_modified_at

string(60)

Updated in

☑

The code of the function in the modules table from within which the user last updated the record. This value will change for every mutation of the record.

tbe_modified_by

string(60)

Updated by

☑

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

tbe_orig_system_group

string(240)

Original System Group

☐

Reference for identifying the group of records on the system from which it originated. It is commonly used to group records for later validation in an application control.

tbe_orig_system_reference

string(240)

Original System Reference

☐

Reference for identifying the record on the system from which it originated.

tbe_seconds_before_droppable

decimal

Seconds before Droppable

☑

Default for minimum number of seconds before a table partition version facts table becomes droppable.

tbe_seconds_before_obsolete

decimal

Seconds before Obsolete

☑

Default for minimum number of seconds before a table partition version facts table becomes obsolete.

tbe_seconds_metadata_is_droppable

decimal

Seconds before Metadata Droppable

☑

Default for minimum number of seconds before a table partition version facts table becomes obsolete.

tbe_session_created

string(240)

Session Created

☑

The ID of the session which created the record. This value will not change after insert.

tbe_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

tbe_table_md5

string(60)

MD5 of Facts Table

☐

MD5 of the SQL used to create the facts table.

tbe_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

tbe_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.