Attachments

The Attachments (md_attachment) table stores files for meta tables. You can use the view to query attachments to meta table, and delete the files attached to records of tables from the meta application.

The following list defines every field available in the attachments (md_attachment) table in alphabetical order:

• Attachment - this field is not maintainable. An extension column used to display the file name as a hyperlink, thereby allowing the user to download it once clicked.

• Attachment ID - this field is not maintainable. A serial identifier used as the primary key.

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Database Name - this field is not maintainable. The database name of the owner record.

• File Comments - comments related to the attachment.

• File Context Data - an expression column providing context information to provide download capabilities. It is hidden by default but always needs to be personalized in the search results and the details of any business view created off the attachments table.

• File Extension - this field is not maintainable. The extension extracted from the file name once uploaded (when applicable).

• File Name - this field is not maintainable. The name of the file that has been uploaded by the user (including the extension when applicable).

• File Size - this field is not maintainable. The size of the file in bytes.
  • Note: The size of a file attachment must be greater than zero bytes.

• Internet Media Type Code - this field is not maintainable. The type of the file based on RFC-4288 from the IETF. It was previously known as MIME types.
  • The internet media type code is inferred when the file is uploaded.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Owner Record - this field is not maintainable. The unique identifier of a table record to which the file is attached.
  • The value consists of primary key values of the owner record table appended using pipes as delimiters.

• Size - an expression column to provide a human-readable version of the file size. The expression finds the most readable unit.

• Table Name - this field is not maintainable. The table name of the owner record.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.