Table d45civi_b72v5.civicrm_file Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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 at Wed Nov 11 17:12 EST 2015

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

Close relationships: