Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_entity_file.file_id FK_civicrm_entity_file_file_id R

Unique ID

file_type_id INT UNSIGNED 10 null

Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value.

mime_type VARCHAR 255 null

mime type of the document

uri VARCHAR 255 null

uri of the file on disk

document MEDIUMBLOB 16777215 null

contents of the document

description VARCHAR 255 null

Additional descriptive text regarding this attachment (optional).

upload_date DATETIME 19 null

Date and time that this attachment was uploaded or written to server.

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id