default.schema - respencer/ChurchCRM GitHub Wiki

default schema

Database Structure Diagram

Table of Contents

  1. autopayment_aut
  2. canvassdata_can
  3. config_cfg
  4. deposit_dep
  5. donateditem_di
  6. donationfund_fun
  7. egive_egv
  8. email_message_pending_emp
  9. email_recipient_pending_erp
  10. event_attend
  11. event_types
  12. eventcountnames_evctnm
  13. eventcounts_evtcnt
  14. events_event
  15. family_custom
  16. family_custom_master
  17. family_fam
  18. fundraiser_fr
  19. group_grp
  20. groupprop_master
  21. kioskassginment_kasm
  22. kioskdevice_kdev
  23. list_lst
  24. menuconfig_mcf
  25. note_nte
  26. person2group2role_p2g2r
  27. person2volunteeropp_p2vo
  28. person_custom
  29. person_custom_master
  30. person_per
  31. pledge_plg
  32. property_pro
  33. propertytype_prt
  34. queryparameters_qrp
  35. record2property_r2p
  36. tokens
  37. user_usr
  38. userconfig_ucfg
  39. version_ver
  40. volunteeropportunity_vol
  41. whycame_why

Table: autopayment_aut

Table of Contents

Description:

This contains information for automatic electronic donations or payments for events

Columns:

Column Name PHP Name PK/FK Format Length Description
aut_ID Id [PK] SMALLINT 9
aut_FamID Familyid SMALLINT 9
aut_EnableBankDraft EnableBankDraft BOOLEAN 1
aut_EnableCreditCard EnableCreditCard BOOLEAN 1
aut_NextPayDate NextPayDate DATE
aut_FYID Fyid SMALLINT 9
aut_Amount Amount DECIMAL 6
aut_Interval Interval TINYINT 3
aut_Fund Fund SMALLINT 6
aut_FirstName FirstName VARCHAR 50
aut_LastName LastName VARCHAR 50
aut_Address1 Address1 VARCHAR 255
aut_Address2 Address2 VARCHAR 255
aut_City City VARCHAR 50
aut_State State VARCHAR 50
aut_Zip Zip VARCHAR 50
aut_Country Country VARCHAR 50
aut_Phone Phone VARCHAR 30
aut_Email Email VARCHAR 100
aut_CreditCard CreditCard VARCHAR 50
aut_ExpMonth ExpMonth VARCHAR 2
aut_ExpYear ExpYear VARCHAR 4
aut_BankName BankName VARCHAR 50
aut_Route Route VARCHAR 30
aut_Account Account VARCHAR 30
aut_DateLastEdited DateLastEdited TIMESTAMP
aut_EditedBy Editedby SMALLINT 5
aut_Serial Serial SMALLINT 9
aut_CreditCardVanco Creditcardvanco VARCHAR 50
aut_AccountVanco AccountVanco VARCHAR 50

Table: canvassdata_can

Table of Contents

Description:

this contains information about the results of canvassing families

Columns:

Column Name PHP Name PK/FK Format Length Description
can_ID Id [PK] SMALLINT 9
can_famID FamilyId SMALLINT 9
can_Canvasser Canvasser SMALLINT 9
can_FYID Fyid SMALLINT 9
can_date Date DATE
can_Positive Positive LONGVARCHAR
can_Critical Critical LONGVARCHAR
can_Insightful Insightful LONGVARCHAR
can_Financial Financial LONGVARCHAR
can_Suggestion Suggestion LONGVARCHAR
can_NotInterested NotInterested BOOLEAN 1
can_WhyNotInterested WhyNotInterested LONGVARCHAR

Table: config_cfg

Table of Contents

Description:

This table contains all non-default configuration parameter names and values

Columns:

Column Name PHP Name PK/FK Format Length Description
cfg_id Id [PK] INTEGER
cfg_name Name VARCHAR 50
cfg_value Value LONGVARCHAR

Table: deposit_dep

Table of Contents

Description:

This records deposits / payments

Columns:

Column Name PHP Name PK/FK Format Length Description
dep_ID Id [PK] SMALLINT 9
dep_Date Date DATE
dep_Comment Comment LONGVARCHAR
dep_EnteredBy Enteredby SMALLINT 9
dep_Closed Closed BOOLEAN 1
dep_Type Type CHAR

Table: donateditem_di

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
di_ID Id [PK] SMALLINT 9
di_item Item VARCHAR 32
di_FR_ID FrId SMALLINT 9
di_donor_ID DonorId SMALLINT 9
di_buyer_ID BuyerId SMALLINT 9
di_multibuy Multibuy SMALLINT 1
di_title Title VARCHAR 128
di_description Description LONGVARCHAR
di_sellprice Sellprice DECIMAL 8
di_estprice Estprice DECIMAL 8
di_minimum Minimum DECIMAL 8
di_materialvalue MaterialValue DECIMAL 8
di_EnteredBy Enteredby SMALLINT 5
di_EnteredDate Entereddate DATE
di_picture Picture LONGVARCHAR

Table: donationfund_fun

Table of Contents

Description:

This contains the defined donation funds

Columns:

Column Name PHP Name PK/FK Format Length Description
fun_ID Id [PK] TINYINT 3
fun_Active Active CHAR
fun_Name Name VARCHAR 30
fun_Description Description VARCHAR 100

Table: egive_egv

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
egv_egiveID EgiveId VARCHAR 16
egv_famID FamilyId INTEGER
egv_DateEntered DateEntered TIMESTAMP
egv_DateLastEdited DateLastEdited TIMESTAMP
egv_EnteredBy EnteredBy SMALLINT
egv_EditedBy EditedBy SMALLINT

Table: email_message_pending_emp

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
emp_usr_id UsrId SMALLINT 9
emp_to_send ToSend SMALLINT 5
emp_subject Subject VARCHAR 128
emp_message Message LONGVARCHAR
emp_attach_name AttachName LONGVARCHAR
emp_attach Attach BOOLEAN 1

Table: email_recipient_pending_erp

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
erp_id Id SMALLINT 5
erp_usr_id UsrId SMALLINT 9
erp_num_attempt NumAttempt SMALLINT 5
erp_failed_time FailedTime TIMESTAMP
erp_email_address EmailAddress VARCHAR 50

Table: event_attend

Table of Contents

Description:

this indicates which people attended which events

Columns:

Column Name PHP Name PK/FK Format Length Description
attend_id AttendId [PK] INTEGER
event_id EventId [FK] events_event INTEGER
person_id PersonId [FK] person_per INTEGER
checkin_date CheckinDate TIMESTAMP
checkin_id CheckinId INTEGER
checkout_date CheckoutDate TIMESTAMP
checkout_id CheckoutId INTEGER

Table: event_types

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
type_id Id [PK] INTEGER
type_name Name VARCHAR 255
type_defstarttime DefStartTime TIME
type_defrecurtype DefRecurType CHAR
type_defrecurDOW DefRecurDOW CHAR
type_defrecurDOM DefRecurDOM CHAR 2
type_defrecurDOY DefRecurDOY DATE
type_active Active INTEGER 1
type_grpid GroupId [FK] group_grp INTEGER

Table: eventcountnames_evctnm

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
evctnm_countid Id INTEGER 5
evctnm_eventtypeid TypeId SMALLINT 5
evctnm_countname Name VARCHAR 20
evctnm_notes Notes VARCHAR 20

Table: eventcounts_evtcnt

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
evtcnt_eventid EvtcntEventid [PK] INTEGER 5
evtcnt_countid EvtcntCountid [PK] INTEGER 5
evtcnt_countname EvtcntCountname VARCHAR 20
evtcnt_countcount EvtcntCountcount INTEGER 6
evtcnt_notes EvtcntNotes VARCHAR 20

Table: events_event

Table of Contents

Description:

This contains events

Columns:

Column Name PHP Name PK/FK Format Length Description
event_id Id [PK] INTEGER
event_type Type INTEGER
event_title Title VARCHAR 255
event_desc Desc VARCHAR 255
event_text Text LONGVARCHAR
event_start Start TIMESTAMP
event_end End TIMESTAMP
inactive InActive INTEGER 1
event_typename TypeName VARCHAR 40
event_grpid GroupId [FK] group_grp INTEGER

Table: family_custom

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
fam_ID FamId [PK] SMALLINT 9

Table: family_custom_master

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
fam_custom_Order CustomOrder SMALLINT
fam_custom_Field CustomField VARCHAR 5
fam_custom_Name CustomName VARCHAR 40
fam_custom_Special CustomSpecial SMALLINT 8
fam_custom_Side CustomSide CHAR
fam_custom_FieldSec CustomFieldSec TINYINT
type_ID TypeId TINYINT

Table: family_fam

Table of Contents

Description:

This contains the main family data, including family name, family addresses, and family phone numbers

Columns:

Column Name PHP Name PK/FK Format Length Description
fam_ID Id [PK] SMALLINT 9
fam_Name Name VARCHAR 50
fam_Address1 Address1 VARCHAR 255
fam_Address2 Address2 VARCHAR 255
fam_City City VARCHAR 50
fam_State State VARCHAR 50
fam_Zip Zip VARCHAR 50
fam_Country Country VARCHAR 50
fam_HomePhone HomePhone VARCHAR 30
fam_WorkPhone WorkPhone VARCHAR 30
fam_CellPhone CellPhone VARCHAR 30
fam_Email Email VARCHAR 100
fam_WeddingDate Weddingdate DATE
fam_DateEntered DateEntered TIMESTAMP
fam_DateLastEdited DateLastEdited TIMESTAMP
fam_EnteredBy EnteredBy SMALLINT 5
fam_EditedBy EditedBy SMALLINT 5
fam_scanCheck ScanCheck LONGVARCHAR
fam_scanCredit ScanCredit LONGVARCHAR
fam_SendNewsLetter SendNewsletter CHAR
fam_DateDeactivated DateDeactivated DATE
fam_OkToCanvass OkToCanvass CHAR
fam_Canvasser Canvasser SMALLINT 5
fam_Latitude Latitude DOUBLE
fam_Longitude Longitude DOUBLE
fam_Envelope Envelope SMALLINT 9

Table: fundraiser_fr

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
fr_ID Id [PK] SMALLINT 9
fr_date Date DATE
fr_title Title VARCHAR 128
fr_description Description LONGVARCHAR
fr_EnteredBy EnteredBy SMALLINT 5
fr_EnteredDate EnteredDate DATE

Table: group_grp

Table of Contents

Description:

This contains the name and description for each group, as well as foreign keys to the list of group roles

Columns:

Column Name PHP Name PK/FK Format Length Description
grp_ID Id [PK] SMALLINT 8
grp_Type Type [FK] list_lst TINYINT The group type. This is defined in list_lst.OptionId where lst_ID=3
grp_RoleListID RoleListId [FK] list_lst SMALLINT 8 The lst_ID containing the names of the roles for this group
grp_DefaultRole DefaultRole SMALLINT 9 The ID of the default role in this group's RoleList
grp_Name Name VARCHAR 50
grp_Description Description LONGVARCHAR
grp_hasSpecialProps HasSpecialProps BOOLEAN 1
grp_active Active BOOLEAN 1
grp_include_email_export IncludeInEmailExport BOOLEAN 1 Should members of this group be included in MailChimp Export

Table: groupprop_master

Table of Contents

Description:

This contains definitions for the group-specific fields

Columns:

Column Name PHP Name PK/FK Format Length Description
grp_ID Id SMALLINT 9
prop_ID Id TINYINT 3
prop_Field Field VARCHAR 5
prop_Name Name VARCHAR 40
prop_Description Description VARCHAR 60
type_ID TypeId SMALLINT 5
prop_Special Special SMALLINT 9
prop_PersonDisplay PersonDisplay CHAR

Table: kioskassginment_kasm

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
kasm_ID Id [PK] INTEGER 9
kasm_kdevId KioskId [FK] kioskdevice_kdev INTEGER 9
kasm_AssignmentType AssignmentType INTEGER 9 The kiosk's current role.
kasm_EventId EventId [FK] events_event INTEGER 9 Optional. If the current role is for event check-in, populate this value

Table: kioskdevice_kdev

Table of Contents

Description:

This contains a list of all (un)registered kiosk devices

Columns:

Column Name PHP Name PK/FK Format Length Description
kdev_ID Id [PK] INTEGER 9
kdev_GUIDHash GUIDHash VARCHAR 36 SHA256 Hash of the GUID stored in the kiosk's cookie
kdev_Name Name VARCHAR 50 Name of the kiosk
kdev_deviceType DeviceType LONGVARCHAR Kiosk device type
kdev_lastHeartbeat LastHeartbeat LONGVARCHAR Last time the kiosk sent a heartbeat
kdev_Accepted Accepted BOOLEAN 1 Has the admin accepted the kiosk after initial registration?
kdev_PendingCommands PendingCommands LONGVARCHAR Commands waiting to be sent to the kiosk

Table: list_lst

Table of Contents

Description:

This table stores the options for most of the drop down lists in churchCRM, including person classifications, family roles, group types, group roles, group-specific property types, and custom field value lists.

Columns:

Column Name PHP Name PK/FK Format Length Description
lst_ID Id [PK] SMALLINT 8 The ID of the list. Since this is a composite primary key, there may be multiple List IDs
lst_OptionID OptionId [PK] SMALLINT 8 The ID of the option in this list. List ID + List Option ID must be unique
lst_OptionSequence OptionSequence TINYINT 3 The order in which to display items in this list
lst_OptionName OptionName VARCHAR 50 The actual value for this list option

Table: menuconfig_mcf

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
mid Id [PK] INTEGER
name Name VARCHAR 20
parent Parent VARCHAR 20
ismenu Menu BOOLEAN 1
content_english ContentEnglish VARCHAR 100
content Content VARCHAR 100
uri URI VARCHAR 255
statustext Status VARCHAR 255
security_grp SecurityGroup VARCHAR 50
session_var SessionVar VARCHAR 50
session_var_in_text SessionVarInText BOOLEAN 1
session_var_in_uri SessionVarInURI BOOLEAN 1
url_parm_name URLParmName VARCHAR 50
active Active BOOLEAN 1
sortorder SortOrder TINYINT 3
icon Icon VARCHAR 50

Table: note_nte

Table of Contents

Description:

Contains all person and family notes, including the date, time, and person who entered the note

Columns:

Column Name PHP Name PK/FK Format Length Description
nte_ID Id [PK] SMALLINT 8
nte_per_ID PerId [FK] person_per SMALLINT 8
nte_fam_ID FamId [FK] family_fam SMALLINT 8
nte_Private Private SMALLINT 8
nte_Text Text LONGVARCHAR
nte_DateEntered DateEntered TIMESTAMP
nte_DateLastEdited DateLastEdited TIMESTAMP
nte_EnteredBy EnteredBy SMALLINT 8
nte_EditedBy EditedBy SMALLINT 8
nte_Type Type VARCHAR 50

Table: person2group2role_p2g2r

Table of Contents

Description:

This table stores the information of which people are in which groups, and what group role each person holds in that group

Columns:

Column Name PHP Name PK/FK Format Length Description
p2g2r_per_ID PersonId [FK] person_per SMALLINT 8
p2g2r_grp_ID GroupId [FK] group_grp SMALLINT 8
p2g2r_rle_ID RoleId SMALLINT 8

Table: person2volunteeropp_p2vo

Table of Contents

Description:

This table indicates which people are tied to which volunteer opportunities

Columns:

Column Name PHP Name PK/FK Format Length Description
p2vo_ID Id [PK] SMALLINT 9
p2vo_per_ID PersonId SMALLINT 9
p2vo_vol_ID VolunteerOpportunityId SMALLINT 9

Table: person_custom

Table of Contents

Description:

Person custom fields

Columns:

Column Name PHP Name PK/FK Format Length Description
per_ID PerId [PK] SMALLINT 9

Table: person_custom_master

Table of Contents

Description:

This contains definitions for the custom person fields

Columns:

Column Name PHP Name PK/FK Format Length Description
custom_Order CustomOrder SMALLINT
custom_Field CustomField VARCHAR 5
custom_Name CustomName VARCHAR 40
custom_Special CustomSpecial SMALLINT 8
custom_Side CustomSide CHAR
custom_FieldSec CustomFieldSec TINYINT
type_ID TypeId TINYINT

Table: person_per

Table of Contents

Description:

This contains the main person data, including person names, person addresses, person phone numbers, and foreign keys to the family table

Columns:

Column Name PHP Name PK/FK Format Length Description
per_ID Id [PK] SMALLINT 9
per_Title Title VARCHAR 50
per_FirstName FirstName VARCHAR 50
per_MiddleName MiddleName VARCHAR 50
per_LastName LastName VARCHAR 50
per_Suffix Suffix VARCHAR 50
per_Address1 Address1 VARCHAR 50
per_Address2 Address2 VARCHAR 50
per_City City VARCHAR 50
per_State State VARCHAR 50
per_Zip Zip VARCHAR 50
per_Country Country VARCHAR 50
per_HomePhone HomePhone VARCHAR 30
per_WorkPhone WorkPhone VARCHAR 30
per_CellPhone CellPhone VARCHAR 30
per_Email Email VARCHAR 50
per_WorkEmail WorkEmail VARCHAR 50
per_BirthMonth BirthMonth TINYINT 3
per_BirthDay BirthDay TINYINT 3
per_BirthYear BirthYear INTEGER 4
per_MembershipDate MembershipDate DATE
per_Gender Gender TINYINT 1
per_fmr_ID FmrId TINYINT 3
per_cls_ID ClsId TINYINT 3
per_fam_ID FamId [FK] family_fam SMALLINT 5
per_Envelope Envelope SMALLINT 5
per_DateLastEdited DateLastEdited TIMESTAMP
per_DateEntered DateEntered TIMESTAMP
per_EnteredBy EnteredBy SMALLINT 5
per_EditedBy EditedBy SMALLINT 5
per_FriendDate FriendDate DATE
per_Flags Flags SMALLINT 9

Table: pledge_plg

Table of Contents

Description:

This contains all payment/pledge information

Columns:

Column Name PHP Name PK/FK Format Length Description
plg_plgID Id [PK] SMALLINT 9
plg_FamID FamId [FK] family_fam SMALLINT 9
plg_FYID Fyid SMALLINT 9
plg_date Date DATE
plg_amount Amount DECIMAL 8
plg_schedule Schedule CHAR
plg_method Method CHAR
plg_comment Comment LONGVARCHAR
plg_DateLastEdited Datelastedited DATE
plg_EditedBy Editedby SMALLINT 9
plg_PledgeOrPayment Pledgeorpayment CHAR
plg_fundID Fundid [FK] donationfund_fun TINYINT 3
plg_depID Depid [FK] deposit_dep SMALLINT 9
plg_CheckNo Checkno BIGINT 16
plg_Problem Problem BOOLEAN 1
plg_scanString Scanstring LONGVARCHAR
plg_aut_ID AutId SMALLINT 9
plg_aut_Cleared AutCleared BOOLEAN 1
plg_aut_ResultID AutResultid SMALLINT 9
plg_NonDeductible Nondeductible DECIMAL 8
plg_GroupKey Groupkey VARCHAR 64

Table: property_pro

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
pro_ID ProId [PK] SMALLINT 8
pro_Class ProClass VARCHAR 10
pro_prt_ID ProPrtId [FK] propertytype_prt SMALLINT 8
pro_Name ProName VARCHAR 200
pro_Description ProDescription LONGVARCHAR
pro_Prompt ProPrompt VARCHAR 255

Table: propertytype_prt

Table of Contents

Description:

This contains all the defined property types

Columns:

Column Name PHP Name PK/FK Format Length Description
prt_ID PrtId [PK] SMALLINT 9
prt_Class PrtClass VARCHAR 10
prt_Name PrtName VARCHAR 50
prt_Description PrtDescription LONGVARCHAR

Table: queryparameters_qrp

Table of Contents

Description:

defines the parameters for each query

Columns:

Column Name PHP Name PK/FK Format Length Description
qrp_ID Id [PK] SMALLINT 8
qrp_qry_ID QryId SMALLINT 8
qrp_Type Type TINYINT 3
qrp_OptionSQL OptionSQL LONGVARCHAR
qrp_Name Name VARCHAR 25
qrp_Description Description LONGVARCHAR
qrp_Alias Alias VARCHAR 25
qrp_Default Default VARCHAR 25
qrp_Required Required TINYINT 3
qrp_InputBoxSize InputBoxSize TINYINT 3
qrp_Validation Validation VARCHAR 5
qrp_NumericMax NumericMax INTEGER
qrp_NumericMin NumericMin INTEGER
qrp_AlphaMinLength AlphaMinLength INTEGER
qrp_AlphaMaxLength AlphaMaxLength INTEGER

Table: record2property_r2p

Table of Contents

Description:

This table indicates which persons, families, or groups are assigned specific properties and what the values of those properties are.

Columns:

Column Name PHP Name PK/FK Format Length Description
r2p_pro_ID PropertyId [FK] property_pro SMALLINT 8
r2p_record_ID PersonId [FK] person_per SMALLINT 8
r2p_Value PropertyValue LONGVARCHAR

Table: tokens

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
token Token [PK] VARCHAR 255
type Type VARCHAR 255
valid_until_date ValidUntilDate DATE
reference_id ReferenceId INTEGER
remainingUses RemainingUses INTEGER

Table: user_usr

Table of Contents

Description:

This contains the login information and specific settings for each ChurchCRM user

Columns:

Column Name PHP Name PK/FK Format Length Description
usr_per_ID PersonId [FK] person_per SMALLINT 9
usr_Password Password VARCHAR 500
usr_NeedPasswordChange NeedPasswordChange BOOLEAN 1
usr_LastLogin LastLogin TIMESTAMP
usr_LoginCount LoginCount SMALLINT 5
usr_FailedLogins FailedLogins TINYINT 3
usr_AddRecords AddRecords BOOLEAN 1
usr_EditRecords EditRecords BOOLEAN 1
usr_DeleteRecords DeleteRecords BOOLEAN 1
usr_MenuOptions MenuOptions BOOLEAN 1
usr_ManageGroups ManageGroups BOOLEAN 1
usr_Finance Finance BOOLEAN 1
usr_Notes Notes BOOLEAN 1
usr_Admin Admin BOOLEAN 1
usr_SearchLimit SearchLimit TINYINT
usr_Style Style VARCHAR 50
usr_showPledges ShowPledges BOOLEAN 1
usr_showPayments ShowPayments BOOLEAN 1
usr_showSince ShowSince DATE
usr_defaultFY DefaultFY SMALLINT 9
usr_currentDeposit CurrentDeposit SMALLINT 9
usr_UserName UserName VARCHAR 32
usr_EditSelf EditSelf BOOLEAN 1
usr_CalStart CalStart DATE
usr_CalEnd CalEnd DATE
usr_CalNoSchool1 CalNoSchool1 DATE
usr_CalNoSchool2 CalNoSchool2 DATE
usr_CalNoSchool3 CalNoSchool3 DATE
usr_CalNoSchool4 CalNoSchool4 DATE
usr_CalNoSchool5 CalNoSchool5 DATE
usr_CalNoSchool6 CalNoSchool6 DATE
usr_CalNoSchool7 CalNoSchool7 DATE
usr_CalNoSchool8 CalNoSchool8 DATE
usr_SearchFamily Searchfamily TINYINT 3
usr_Canvasser Canvasser BOOLEAN 1

Table: userconfig_ucfg

Table of Contents

Columns:

Column Name PHP Name PK/FK Format Length Description
ucfg_per_id PeronId [FK] user_usr SMALLINT 9
ucfg_id Id [PK] INTEGER
ucfg_name Name VARCHAR 50
ucfg_value Value LONGVARCHAR
ucfg_type Type CHAR
ucfg_tooltip Tooltip LONGVARCHAR
ucfg_permission Permission CHAR
ucfg_cat Cat VARCHAR 20

Table: version_ver

Table of Contents

Description:

History of all version upgrades applied to this database

Columns:

Column Name PHP Name PK/FK Format Length Description
ver_ID Id [PK] SMALLINT 9
ver_version Version VARCHAR 50
ver_update_start UpdateStart TIMESTAMP
ver_update_end UpdateEnd TIMESTAMP

Table: volunteeropportunity_vol

Table of Contents

Description:

This contains the names and descriptions of volunteer opportunities

Columns:

Column Name PHP Name PK/FK Format Length Description
vol_ID Id [PK] INTEGER 3
vol_Order Order INTEGER 3
vol_Active Active CHAR
vol_Name Name VARCHAR 30
vol_Description Description VARCHAR 100

Table: whycame_why

Table of Contents

Description:

This contains the comments related to why people came

Columns:

Column Name PHP Name PK/FK Format Length Description
why_ID Id [PK] SMALLINT 9
why_per_ID PerId [FK] person_per SMALLINT 9
why_join Join LONGVARCHAR
why_come Come LONGVARCHAR
why_suggest Suggest LONGVARCHAR
why_hearOfUs HearOfUs LONGVARCHAR