Table d47civi_0z3xa.civicrm_volunteer_project 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_volunteer_need.project_id FK_civicrm_volunteer_need_project_id N
civicrm_volunteer_project_contact.project_id FK_civicrm_volunteer_project_contact_project_id C
Project Id
title varchar 255 The title of the Volunteer Project
description text 65535  √  null Full description of the Volunteer Project. Text and HTML allowed. Displayed on sign-up screens.
entity_table varchar 64  √  null
entity_id int 10  √  null
is_active tinyint 3 1 Is the project active. Enabling volunteering for an event or other project sets this TRUE.
loc_block_id int unsigned 10  √  null
civicrm_loc_block.id FK_civicrm_volunteer_project_loc_block_id N
FK to Location Block ID
campaign_id int unsigned 10  √  null
civicrm_campaign.id FK_civicrm_volunteer_project_campaign_id N
The campaign associated with this Volunteer Project.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
campaign_id Performance Asc FK_civicrm_volunteer_project_campaign_id
loc_block_id Performance Asc FK_civicrm_volunteer_project_loc_block_id

Close relationships  within of separation: