Table Layouts - GolfWithMe/Master GitHub Wiki

New tables

_gwm_courses

  • Table of golf courses.

_gwm_event

  • Holds the details of each new GWM request.

_gwm_event_invites

  • Holds the list of invitees for each event.

_gwm_event_responses

  • Holds the list of responses from the invitees.

_gwm_event_times

  • Holds the list of times that the requester has added to the available selection list.

_gwm_favorite_courses

  • This is a table that holds the favorite courses for each member.

_gwm_group_membership

  • This table holds all of the information about who has paid to be a member of which groups, the renewal information, did someone else pay for the membership, who pays at renewal, etc.

_gwm_group_options

  • This table holds additional options for each group. New options are added in here instead of in the joomla table so that future changes to JomSocial will not affect these other options.

_gwm_lists

  • This is a list of the lists of values

_gwm_list_values

  • This is the values for the different lists.

_gwm_member_blacklist

  • This is a table that holds other golfers that a member does not want to play with again.

_gwm_member_ratings

  • This table holds ratings of golfers by golfers they have played with.

_gwm_notifications

  • This table holds the public golf with me request notifications for golfers that were matched.

_gwm_pay_history

  • This tables holds a history of all payments made, the amount, who paid, etc.

_gwm_profiles

  • The user profile for the GWM features. This data is used for alerting and doing auto public matching.

_gwm_zipcodes

  • The table holds a list of zip codes. We store the latitude and longitude of each zip code, when the golf courses for this zip code were last downloaded.

New tables added by developer

_gwm_group_schedule_member

_gwm_group_schedule

_gwm_group_schedule_date

_gwm_group_schedule_accept

_gwm_golfers_schedule

_gwm_golfers_schedule_date

_gwm_golfers_schedule_accept

_gwm_golfers_schedule_member

Modified Tables