SBS_JOB_FILES

Details

Name	Columns
SBS_JOB_FILES_PK	JOB_FILE_ID

Name	Datatype	Length	Precision	Not-null	Comments
JOB_FILE_ID	NUMBER		18	Yes	System generated ID
JOB_REQUEST_ID	NUMBER		18	Yes	FK to SBS_JOB_REQUESTS
JOB_EXECUTION_ID	NUMBER		18	Yes	FK to SBS_JOB_EXECUTIONS
FILE_TYPE	VARCHAR2	30		Yes	Example values: 'LOG', 'OUTPUT_TEXT', 'OUTPUT_BINARY'
FILE_NAME	VARCHAR2	100		Yes	Name of the file
FILE_PATH	VARCHAR2	2000			Path of the file
FILE_METADATA	BLOB				Column to store the file metadata such as Bucket name, file location and etc
FILE_EXPIRY_DATE	TIMESTAMP				Column to store the file expiry date
FILE_STORAGE_OPTION	VARCHAR2	30		Yes	Sample values: FA-DB, SBS_OS, ESS, SERVICE_OS, CUSTOMER_OS
JOB_SUBMITTER	VARCHAR2	128			Job submitter user name
VIRUS_SCAN_STATUS	VARCHAR2	30		Yes	Indicates the virus scanning status of the file
VIRUS_SCAN_RETRY_NUMBER	NUMBER		9	Yes	Represents the number of retries that have been done, starting from 0
VIRUS_SCAN_DETAILS	BLOB				Stores the virus scan result and its associated metadata
ZIP_FILE_ID	NUMBER		18		FK representing the .zip file that includes the given file
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Index	Uniqueness	Tablespace	Columns	Status
SBS_JOB_FILES_N1	Non Unique	Default	JOB_REQUEST_ID
SBS_JOB_FILES_N2	Non Unique	Default	JOB_EXECUTION_ID
SBS_JOB_FILES_N3	Non Unique	Default	FILE_NAME, FILE_PATH	Obsolete
SBS_JOB_FILES_N4	Non Unique	Default	FILE_TYPE, VIRUS_SCAN_STATUS	Obsolete
SBS_JOB_FILES_U1	Unique	Default	JOB_FILE_ID
SBS_JOB_FILES_U2	Unique	Default	JOB_EXECUTION_ID, FILE_NAME