Database Table: FILEUPLOAD

This table contains the information of uploaded files.

Column Name Column Type Column Description
FILEENCODING VARCHAR (128)
NULL
The file encoding. For example, UTF8, ISO8859-1, and so on.
FILENAME VARCHAR (254)
NULL
File name.
FILEPATH VARCHAR (254)
NOT NULL
File path.
FILESIZE BIGINT
NULL
File size.
FILETYPE CHARACTER (50)
NULL
Reserved for IBM internal use.
FILEUPLOAD_ID BIGINT
NOT NULL
Generated key.
HOSTNAME CHARACTER (50)
NULL
The host name the file is uploaded to. It is used by the scheduler in the horizontal cloning environment, only the scheduler on this machine will process the uploaded file.
MEMBER_ID BIGINT
NULL
The ID of the member who uploads the file.
SCCJOBREFNUM BIGINT
NULL
The scheduler job which processes the file.
STATUS INTEGER
NOT NULL, DEFAULT 0
The file process status:
0 = New,
1 = Processing,
2 = Processed,
3 = Failed,
4 = Cancelled.
STORE_ID INTEGER
NULL
The store which the uploaded file belongs to.
UPLOADTIME TIMESTAMP
NULL
Time when the file uploaded.
VERSION INTEGER
NOT NULL
The version of uploaded file. The same file can be uploaded more than once.
Indexes:
Index Name Indexed Column Names Index Type
I0000295 FILEPATH, VERSION Unique Index
I0000296 STORE_ID Non-Unique Index
SQL030416034928670 FILEUPLOAD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_984 MEMBER_ID MEMBER MEMBER_ID Cascade
F_985 SCCJOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade
F_986 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable