attmnt_name

STRING 240

Specifies the attachment name.

created_by

UUID

ca_contact::uuid

Specifies who created this attachment.

created_dt

LOCAL_TIME

Specifies when the attachments was created.

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

description

STRING 500

Specifies the textual description of this attachment.

exec_cmd

STRING 12

Remote_Ref::code

Specifies the unix exec string (not currently used).

file_date

LOCAL_TIME

Specifies the date of the file.

file_name

STRING 240

Specifies the server attachment filename.

file_size

INTEGER

Specifies the size of the file.

file_type

STRING 12

Specifies the file extension (not currently used).

folder_id

INTEGER

attmnt_folder::id

Specifies the folder id.

folder_path_ids

STRING 255

Specifies the folder path ids.

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

inherit_ permission_id

INTEGER

Specifies the folder ID where pgroup permissions come from.

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

link_only

INTEGER

Boolean_Table ::enum

link_type

String

If embedded image = EMBD_IMG, otherwise NULL

orig_file_name

STRING 240

original file name, URL or UNC

persid

STRING 30

Persistent ID (SystemObjectName:id)

read_pgroup

INTEGER

P_GROUPS::id

Specifies the group of groups eligible to read the document.

rel_file_path

STRING 512

Specifies the relative path to the file.

repository

SREL

Document_ Repository::persid

Specifies the repository.

status

STRING 12

Specifies the attachment status (INSTALLED, INSTALL_FAILED, LINK_ONLY).

write_pgroup

INTEGER

P_GROUPS::id

Specifies the group of groups eligible to update the document.

zip_flag

INTEGER

Specifies if the file is zipped.