civicrm_entity_file

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

primary key

entity_table VARCHAR 64 null

physical tablename for entity being joined to file, e.g. civicrm_contact

entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

file_id INT UNSIGNED 10 null
civicrm_file.id FK_civicrm_entity_file_file_idR

FK to civicrm_file

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_entity_file_file_id Performance Asc file_id
index_entity Performance Asc/Asc entity_table + entity_id
index_entity_file_id Performance Asc/Asc/Asc entity_table + entity_id + file_id

Relationships