Object Attachments. (r5.0 version)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| description | nvarchar(500) | with null | Textual description of this Attachment |
| orig_file_name | nvarchar(240) | with null | Original file name, URL or UNC |
| attmnt_name | nvarchar(240) | with null | Attachment name |
| file_name | nvarchar(240) | with null | Server attachment filename |
| file_date | integer | with null | Date of the file. |
| file_size | integer | with null | Size of the file |
| file_type | nvarchar(12) | with null | File extention (not currently used) |
| folder_id | integer | with null | Folder id |
| folder_path_ids | nvarchar(255) | with null | Folder path ids |
| inherit_permission_id | integer | with null | The folder ID where pgroup permissions come from |
| read_pgroup | integer | with null | Read p Group permissions of the attachment |
| write_pgroup | integer | with null | Write p Group permissions of the attachment |
| rel_file_path | nvarchar(512) | with null | Relative path to file |
| zip_flag | integer | with null | If the file is zipped |
| last_mod_by | byte(16) | with null | Specifies the uuid of the contact who last modified this record |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| created_by | byte(16) | with null | Who created this attachment |
| created_dt | integer | with null | When was this created |
| repository | nvarchar(30) | with null | Which repository |
| exec_cmd | nvarchar(12) | with null | Unix exec string (not currently used) |
| status | nvarchar(12) | with null | Status of Attachment (INSTALLED, INSTALL_FAILED, LINK_ONLY) |
| link_only | integer | with null | Did we only create a link? |
Product Name: Unicenter Service Desk
Table Type: Table