Contains file url information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| created_date* | DATETIME | Date of creation of the record |
| file_id* | INT | File ID related to a case |
| id* | VARCHAR (50) | Unique alphanumeric identifier of the file url |
| item_id* | INT | Case identifier related to the attachments consulted |
| type_id* | INT | Case Type Identifier |
| user_id* | INT | Identifier of the user who queries attachments for a case |
Primary Key
| PK_ASDK_FILEREPOSITORY |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| file_id* | Bod. AFW_DOCUMENT | docu_id | FK03_ASDK_FILEREPOSITORY |
| type_id* | dbo.ASMS_TYPES | id | FK02_ASDK_FILEREPOSITORY |
| user_id* | dbo.AFW_USERS | user_id | FK01_ASDK_FILEREPOSITORY |