default.schema

Louis Bridgman edited this page Nov 29, 2017 · 2 revisions

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
Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.