Table d47civi_0z3xa.civicrm_volunteer_need 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  √  Need Id
project_id int unsigned 10  √  null
civicrm_volunteer_project.id FK_civicrm_volunteer_need_project_id N
FK to civicrm_volunteer_project table which contains entity_table + entity for each volunteer project (initially civicrm_event + eventID).
start_time datetime 19  √  null
end_time datetime 19  √  null Used for specifying fuzzy dates, e.g., I have a need for 3 hours of volunteer work to be completed between 12/01/2015 and 12/31/2015.
duration int 10  √  null Length in minutes of this volunteer time slot.
is_flexible tinyint 3 0 Boolean indicating whether or not the time and role are flexible. Activities linked to a flexible need indicate that the volunteer is generally available.
quantity int 10  √  null Number of volunteers required for this need.
visibility_id int unsigned 10  √  null Implicit FK to option_value row in visibility option_group. Indicates whether this need is offered on public volunteer signup forms.
role_id int 10  √  null Implicit FK to option_value row in volunteer_role option_group.
is_active tinyint 3 1 Is this need enabled?

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
project_id Performance Asc FK_civicrm_volunteer_need_project_id
id Must be unique Asc UI_id

Close relationships  within of separation: