Stores all the information related to an uploaded
file.
Column Descriptions:
| Name | Type | Description |
| UPLOADFILE_ID | BIGINT NOT NULL | Generated primary key. |
| MEMBER_ID | BIGINT | The identifier of the user that uploaded the
file. |
| STORE_ID | INTEGER | The store to which the uploaded file
belongs. |
| OBJECTID | VARCHAR (64) | The identifier of the object associated with the
uploaded file. |
| UPLOADTYPE | VARCHAR (32) | The type of upload such as CatalogImport. |
| PROPERTIES | VARCHAR (1000) | Some extra name value pairs such as catalogId and
workspace related context data. |
| UPLOADTIME | TIMESTAMP | The time the file is uploaded to the server. |
| FILEPATH | VARCHAR (254) | The full path of the uploaded file on the
server. |
| FILENAME | VARCHAR (254) | The name of the file uploaded. |
| FILESIZE | BIGINT | The size of the uploaded file in bytes. |
| FILEENCODING | VARCHAR (128) | The file encoding such as UTF8 and
ISO8859-1. |
| FILECONTENT | BLOB (300000000) | The content of the file. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | UPLOADFILE_ID | Primary Key |
| I0001308 | UPLOADTYPE+STORE_ID+OBJECTID | Non-Unique Index |
| I0001309 | MEMBER_ID | Non-Unique Index |
| I0001310 | STORE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3599 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
| F_3600 | STORE_ID | STORE | STORE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3602 | UPLOADFILE_ID | FILEPROCREL | UPLOADFILE_ID | Cascade |