View HLPDTEST.STATEGPS.TEST_CASE_STEP_LOG_VW Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TEST_CASE_STEP_LOG_ID undefined 0  √  null
CASE_ID undefined 0  √  null
STEP_ID undefined 0  √  null
ENTERED_DATE undefined 0  √  null
ENTERED_BY undefined 0  √  null
CHANGE_TEXT undefined 0  √  null
LANGUAGE_CODE undefined 0  √  null
TRANSLATED_FLAG undefined 0  √  null
CREATED_BY undefined 0  √  null
LAST_UPDATED_BY undefined 0  √  null
CREATED_DATE undefined 0  √  null
LAST_UPDATED_DATE undefined 0  √  null
ERROR_SCRIPT_LINE undefined 0  √  null
ERROR_REASON undefined 0  √  null
ERROR_SCREENSHOT undefined 0  √  null
ERROR_LINE_NO undefined 0  √  null
ERROR_SCREENSHOT_NAME undefined 0  √  null
TESTCASE_LOG_ID undefined 0  √  null
STEP_NAME undefined 0  √  null
STEP_SEQUENCE undefined 0  √  null
NAVIGATION_PATH undefined 0  √  null
ACTUAL_OUTPUT undefined 0  √  null
BA_NUMBER undefined 0  √  null
ACTUAL_INPUTS undefined 0  √  null
ACTUAL_TIME_TAKEN undefined 0  √  null
EXPECTED_INPUT undefined 0  √  null
EXPECTED_OUTPUT undefined 0  √  null
EXPECTED_TIME undefined 0  √  null
BSM_ID undefined 0  √  null
BSM_NUMBER undefined 0  √  null
BA_ID undefined 0  √  null
BA_SEQUENCE_NUMBER undefined 0  √  null
SCENARIO_INPUT_ID undefined 0  √  null
SUB_PROCESS_NUMBER undefined 0  √  null
AVERAGE_TRANSACTION_TIME undefined 0  √  null
INPUT_TYPE undefined 0  √  null
TESTING_SCRIPT_NAME undefined 0  √  null
REPLAY_FLAG undefined 0  √  null
TEST_SCRIPT_PATH undefined 0  √  null
RECORD_TIME undefined 0  √  null
REPLAY_TIME undefined 0  √  null
OVERRIDE_CREDENTIALS_FLAG undefined 0  √  null
STEP_REPLAY_INSTANCE_NAME undefined 0  √  null
STEP_REPLAY_INSTANCE_URL undefined 0  √  null
REPLAY_INST_ID undefined 0  √  null
STATUS undefined 0  √  null
PREDECESSOR undefined 0  √  null
ACTIVE_FLAG undefined 0  √  null
DESCRIPTION undefined 0  √  null
STEP_RESULT undefined 0  √  null
REPLAY_URL undefined 0  √  null
USERNAME undefined 0  √  null
REPLAY_INSTANCE undefined 0  √  null
LAST_UPDATED_BY_NAME undefined 0  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT TEST_CASE_STEP_LOG.TEST_CASE_STEP_LOG_ID , TEST_CASE_STEP_LOG.CASE_ID , TEST_CASE_STEP_LOG.STEP_ID , TEST_CASE_STEP_LOG.ENTERED_DATE , TEST_CASE_STEP_LOG.ENTERED_BY , TEST_CASE_STEP_LOG.CHANGE_TEXT , TEST_CASE_STEP_LOG.LANGUAGE_CODE , TEST_CASE_STEP_LOG.TRANSLATED_FLAG , TEST_CASE_STEP_LOG.CREATED_BY , TEST_CASE_STEP_LOG.LAST_UPDATED_BY , TEST_CASE_STEP_LOG.CREATED_DATE , TEST_CASE_STEP_LOG.LAST_UPDATED_DATE , TEST_CASE_STEP_LOG.ERROR_SCRIPT_LINE , TEST_CASE_STEP_LOG.ERROR_REASON , TEST_CASE_STEP_LOG.ERROR_SCREENSHOT , TEST_CASE_STEP_LOG.ERROR_LINE_NO , TEST_CASE_STEP_LOG.ERROR_SCREENSHOT_NAME , TEST_CASE_STEP_LOG.TESTCASE_LOG_ID , TEST_CASE_STEP_LOG.STEP_NAME , TEST_CASE_STEP_LOG.STEP_SEQUENCE , TEST_CASE_STEP_LOG.NAVIGATION_PATH , TEST_CASE_STEP_LOG.ACTUAL_OUTPUT , TEST_CASE_STEP_LOG.BA_NUMBER , TEST_CASE_STEP_LOG.ACTUAL_INPUTS , TEST_CASE_STEP_LOG.ACTUAL_TIME_TAKEN , TEST_CASE_STEP_LOG.EXPECTED_INPUT , TEST_CASE_STEP_LOG.EXPECTED_OUTPUT , TEST_CASE_STEP_LOG.EXPECTED_TIME , TEST_CASE_STEP_LOG.BSM_ID , TEST_CASE_STEP_LOG.BSM_NUMBER , TEST_CASE_STEP_LOG.BA_ID , TEST_CASE_STEP_LOG.BA_SEQUENCE_NUMBER , TEST_CASE_STEP_LOG.SCENARIO_INPUT_ID , TEST_CASE_STEP_LOG.SUB_PROCESS_NUMBER , TEST_CASE_STEP_LOG.AVERAGE_TRANSACTION_TIME , TEST_CASE_STEP_LOG.INPUT_TYPE , TEST_CASE_STEP_LOG.TESTING_SCRIPT_NAME , TEST_CASE_STEP_LOG.REPLAY_FLAG , TEST_CASE_STEP_LOG.TEST_SCRIPT_PATH , TEST_CASE_STEP_LOG.RECORD_TIME , TEST_CASE_STEP_LOG.REPLAY_TIME , TEST_CASE_STEP_LOG.OVERRIDE_CREDENTIALS_FLAG , TEST_CASE_STEP_LOG.STEP_REPLAY_INSTANCE_NAME , TEST_CASE_STEP_LOG.STEP_REPLAY_INSTANCE_URL , TEST_CASE_STEP_LOG.REPLAY_INST_ID , TEST_CASE_STEP_LOG.STATUS , TEST_CASE_STEP_LOG.PREDECESSOR , TEST_CASE_STEP_LOG.ACTIVE_FLAG , TEST_CASE_STEP_LOG.DESCRIPTION , TEST_CASE_STEP_LOG.STEP_RESULT , TEST_CASE_STEP_LOG.REPLAY_URL , TEST_CASE_STEP_LOG.USERNAME , REPLAY_INSTANCE_NAMES.REPLAY_INSTANCE, USERS2.FIRST_NAME ||' ' || USERS2.LAST_NAME LAST_UPDATED_BY_NAME FROM TRI2GPS_DEV.TEST_CASE_STEP_LOG TEST_CASE_STEP_LOG, REPLAY_INSTANCE_NAMES, TAS.T_USERS USERS2 WHERE USERS2.USER_ID(+) = TEST_CASE_STEP_LOG.LAST_UPDATED_BY AND TEST_CASE_STEP_LOG.REPLAY_URL = REPLAY_INSTANCE_NAMES.REPLAY_INSTANCE_URL ( + ) ORDER BY TEST_CASE_STEP_LOG.TEST_CASE_STEP_LOG_ID DESC