Table Detail Report
DM_TEMP_CONSTRAINTS
Column Section | Top of Page |
Table-level Detail
Description: | Temporary table for primary key constraints. |
Definition: | DM Merge table |
Table Type: | ACTIVITY |
Column Detail - DM_TEMP_CONSTRAINTS
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_NAME | VARCHAR(30) | Y | Column name |
CONSTRAINT_NAME | VARCHAR(30) | Y | Constraint name |
POSITION | DOUBLE | Y | Column position |
TABLE_NAME | VARCHAR(30) | Y | TABLE NAME |
DM_TEXT_FIND
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM_TEXT_FIND |
Definition: | This table will store meta-data about the new Text Search tool owned by DM |
Table Type: | REFERENCE |
Column Detail - DM_TEXT_FIND
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DM_TEXT_FIND_ID | DOUBLE | N | Primary Key for table |
FIND_NAME | VARCHAR(50) | N | Name of search criteria inside category |
FIND_NAME_KEY | VARCHAR(50) | N | Similar to FIND_NAME but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performance |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DM_TEXT_FIND
Parent Column in DM_TEXT_FIND (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DM_TEXT_FIND_ID | DM_TEXT_FIND_CAT_R | DM_TEXT_FIND_ID |
DM_TEXT_FIND_DETAIL | DM_TEXT_FIND_ID |
DM_TEXT_FIND_CAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Database Management Text Find Category |
Definition: | This table will store meta-data about the new Text Search tool owned by DM |
Table Type: | REFERENCE |
Column Detail - DM_TEXT_FIND_CAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DM_TEXT_FIND_CAT_ID | DOUBLE | N | Primary Key for table |
FIND_CATEGORY | VARCHAR(30) | N | Name of search category |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DM_TEXT_FIND_CAT
Parent Column in DM_TEXT_FIND_CAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DM_TEXT_FIND_CAT_ID | DM_TEXT_FIND_CAT_R | DM_TEXT_FIND_CAT_ID |
DM_TEXT_FIND_COMMENT | DM_TEXT_FIND_CAT_ID | ||
DM_TEXT_FIND_HIGHLIGHT | DM_TEXT_FIND_CAT_ID | ||
DM_TEXT_FIND_QUERY | DM_TEXT_FIND_CAT_ID | ||
DM_TEXT_FIND_STRUCT | DM_TEXT_FIND_CAT_ID | ||
DM_TEXT_FIND_SUMMARY | DM_TEXT_FIND_CAT_ID |
DM_TEXT_FIND_CAT_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Database Management Text Find Category Relation |
Definition: | This table will store meta-data about the new Text Search tool owned by DM |
Table Type: | REFERENCE |
Column Detail - DM_TEXT_FIND_CAT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DM_TEXT_FIND_CAT_ID | DOUBLE | N | Reference to the DM_TEXT_FIND_CAT table |
DM_TEXT_FIND_CAT_R_ID | DOUBLE | N | Primary Key for table |
DM_TEXT_FIND_ID | DOUBLE | N | Reference to the DM_TEXT_FIND table |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DM_TEXT_FIND_CAT_R
Child Column in DM_TEXT_FIND_CAT_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DM_TEXT_FIND_ID | DM_TEXT_FIND | DM_TEXT_FIND_ID |
DM_TEXT_FIND_CAT_ID | DM_TEXT_FIND_CAT | DM_TEXT_FIND_CAT_ID |
DM_TEXT_FIND_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM_TEXT_FIND_COMMENT |
Definition: | Stores a list of unstructured objects the user has chosen to exclude from their interrogator reports. |
Table Type: | REFERENCE |
Column Detail - DM_TEXT_FIND_COMMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_COL_DT_TM | DATETIME | N | The date value stored in the column named in comment_col_name to use for comparison by the interrogator application. |
COMMENT_COL_NAME | VARCHAR(30) | N | The name of the column used to compare for source object changes. This will likely be 'scriptCompileDate', but other values may be provided. |
COMMENT_DT_TM | DATETIME | N | The date this comment was requested. |
COMMENT_PRSNL_ID | DOUBLE | N | The user who is requesting this comment. |
COMMENT_STATE_FLAG | DOUBLE | N | The state flag to indicate the state of the comment when it was recorded by the user. |
COMMENT_TEXT | VARCHAR(1000) | Y | The message, if any, the user records to indicate why they are excluding this object. |
COMMENT_TYPE_FLAG | DOUBLE | N | The type flag indicator used to differentiate between comment types. |
DATA_SOURCE | VARCHAR(255) | N | The object source_data identifier, as determined by the interrogator application. |
DM_TEXT_FIND_CAT_ID | DOUBLE | N | Reference to the DM_TEXT_FIND_CAT table for the category this comment is associated with. |
DM_TEXT_FIND_COMMENT_ID | DOUBLE | N | Unique generated number that identifies a single row on the DM_TEXT_FIND_COMMENT table. |
DM_TEXT_FIND_DATA_ID | DOUBLE | N | Reference to the DM_TEXT_FIND_DATA table for the object being commented on. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DM_TEXT_FIND_COMMENT
Child Column in DM_TEXT_FIND_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DM_TEXT_FIND_CAT_ID | DM_TEXT_FIND_CAT | DM_TEXT_FIND_CAT_ID |
DM_TEXT_FIND_DATA_ID | DM_TEXT_FIND_DATA | DM_TEXT_FIND_DATA_ID | |
COMMENT_PRSNL_ID | PRSNL | PERSON_ID |