Table d47civi_0z3xa.civicrm_volunteer_project_contact 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  √ 
project_id int unsigned 10
civicrm_volunteer_project.id FK_civicrm_volunteer_project_contact_project_id C
Foreign key to the Volunteer Project for this record
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_volunteer_project_contact_contact_id C
Foreign key to the Contact for this record
relationship_type_id int unsigned 10 Nature of the contact's relationship to the Volunteer Project (e.g., Beneficiary). See option group volunteer_project_relationship.

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_volunteer_project_contact_contact_id
project_id + contact_id + relationship_type_id Must be unique Asc/Asc/Asc UI_project_contact_rel

Close relationships  within of separation: