Membership Software Database Table Details

adminpageaccess
File Access. Specifies which members or memberships are able to access a file. If no record exists for a page then only the admin is able to view the page.

adminsettings
Settings for the website. DO NOT update directly.

contactfields
Contact fields (variables).

contactgroupassign
Assigns a contact to a contact group.

contactgroups
Contact groups. Used for sorting contacts and autoresponder messages.

contactnotes
Notes that members add to a contact.

contactnotify
New contact notification email that is sent to the member.

contactpointlogs
A log of points a contact has earned. Contact points are displayed on the contact scoreboard and increase the contact's score.

contactpointsettings
Contact point amounts that are added to the contact's score when they perform specific actions.

contacts
Contacts (leads) belonging to members.

contactsync
For tracking changes to contacts for synchronizing 3rd party apps (like a mobile app, or downloaded desktop app).

contentgroupassign
Assign content (pages, banners, etc) to a specific content group.

contentgroups
Content groups that content (pages, banners, etc) can be added to.

cprequiredfields
Capture page required fields (name, email, etc).

doccategories
Document Categories

documents
Documents are html pages that are used for a wide range of items such as training section, grouping quizzes, and more.

documentsubcat
Sub-Categories that documents can be assigned to.

domainassign
Assigns a web page to a domain.

domains
Domains that a member has either purchased from the site or imported. By default domains are hosted with the site.

doubleoptinsettings
Double optin settings for each member that specifies if new contacts (optins) must click a confirmation link to confirm their email before becoming active.

editablecontent
Used for storing text/html content that is used throughout the members area or used for notification emails.

files
Files uploaded by members to tasks or designs or other entities that allow members to upload files for internal purposes.

freesignups
A list of emails that can join without making payment.

ipblocks
IPs that are blocked from viewing the site.

languageassign
Assigns a word/phrase to a specific page in the member's area.

languages
A list of available languages for the member's area.

languagevalues
Translation values for specific words/phrases for each language.

login
Login records for members.

memberemails
Additional emails to send notification messages to.

membernotes
Member notes added by the admin and only seen by the admin.

membernotifyemails
Email notification for member

members
Member (Affiliate)

membershipassign
Assign a piece of content to a specific membership so only members of that membership can see it.

membershipbumps
Membership bump to automatically upgrade a member to a higher membership for referring other members.

membershipgroups
group packages

membershipnotify
The notification email a member is sent when they join under a specific membership.

membershipqualifications
package qualify

memberships
Memberships that members can belong to. A member can only belong to one membership at a time.

membervars
Member variables. A list of all the types of member variables.

membervarvalues
Member variable. The values of the member variables that each member has stored.

menuitems
An item in the navigation menu in the member's area.

mobileoptinbuttons
Mobile Optin Buttons Creator

notes
Internal notes left by members on entities (exa: task notes).

notifications
type=1=Join Notification (to new member) typeid=membership type=2=New Contact Notification (to member) typeid=contactgroup type=3=To Other typeid=unique type=4=To Contact typeid=unique type=5=To Member typeid=unique type=6=Custom typeid=unique type=7=Purchase to Purchaser typeid=billing type=8=Payment to Purchaser typeid=billing type=9=Purchase to Parent typeid=billing type=10=Payment to Paid typeid=billing type=11=Payment Approved typeid=billing type=12=Awaiting Approval typeid=billing type=13=Matrix Cycle typeid=matrix type=14=Cancellation typeid=billing

pagecontents
A section of editable content on a page.

pagedynamic
A dynamic page (meaning not having it's own php file).

pages
A page for the site (capture page or landing page. Not members area pages). This is the primary table for pages and all tables that start with the title capurepage are related to this one.

primarypages
A member's primary page seen when visiting domain.com/username

privacypolicies
A custom privacy policy page for a member.

resourcecategories
Resource categories for grouping resources.

resources
Resources (member's area pages).

restore
Restoration details for items that have been deleted (like a trash can). Items over 3 days old are purged nightly.

signups
Statistics of optins (visitors that have filled out a capture page form).

sms
SMS notification settings for each member.

stats
Statistics of page views.

thirdpartyautoresponders
Third party autoresponders (such as Aweber, GetResponse, etc).

usernamechanges
A que of username changes that is processed by the server to update email accounts. Each member has an email account on the domain on the site that matches their username.

visit
Visit

affprogram
Affiliate/member Tier and payment

commissionholdings
holding payments to members

commissions
Commissions earned by members.

commissiontiers
Commission tiers (levels).

membershipbonuses
Membership Bonuses

payouts
A log of payouts of commission earned made to members.

showcase
A member showcase.

affiliateprograms
Affiliate programs. A list of all the affiliate programs.

affiliateprogramvalues
Affiliate program. The values of the affiliate programs that each member has stored.

news
A news item for news for members. Also used for a RSS feed.

externalgenealogy
Member genealogy (referral information) for a specific external billing product.

externalproductprice
The reseller/distributor's price of an external billing product.

externalproducts
external products

externalpromocode
external promocode

externaltiers
Commission tiers for an external billing product.

externalvars
external vars

externalvarvalues
external var values

productpackage
Assigns an external billing product to a package. A package is an external billing product that has many products assigned to it so when paying the one price for the product all the other products assigned to it are included with it.

chatmessages
Chat messages between contacts and members in a live chat.

chatsettings
Live chat settings for a specific member.

smsaccounts
SMS Accounts

smsar
SMS/Voice autoresponder.

smscredits
SMS/Voice credits used when sending an SMS message or voice message to a contact's phone.

smsque
A que of SMS/Voice messages to be sent.

smsusage
A history of SMS/Voice messages sent by a member to a contact.

facebookvideo
Facebook Video Plugin

googlecalendar
Google Calendar

socialapisettings
Global settings for the importer/inviter (social) inviter plugin.

socialconnect
Social Connect

socialconnections
Social Connections

socialcontacts
Social Contacts

socialcontent
Social Content

socialcontentassign
Assign social content to a social account

socialcontenttypes
Social Content Types

socialprofile
Social Profile

socialprofiletypes
Social Profile Types

socialprofilevars
Social Profile Variables

socialque
Social content que

socialsites
Social Sites

socialstats
Social Stats

socialvarstemplate
Social Variables Template

socialvarstemplatevar
Social Template variables

formtemplate
An optin form template.

formtemplatecustom
An editable section of a form template that members can customize.

funnelactivity
Funnel activity

funnelpages
Assigns a page to a marketing funnel.

funnels
A marketing funnel (funnel of pages visited in a specific order).

blog
Blogs created by members.

blogcomments
Comments by visitors that are assigned to a blog entry.

blogentry
A blog entry.

blogtemplates
blog templates

blogvar
Blog Variable

blogvars
Blog Variables

slider
Settings for an image slider that rotates between images.

sliderimage
Images that are assigned to an image slider.

adcoops
An ad coop that members can purchase shares of.

adcoopshares
An ad coop share that is assigned to a member.

survey
Survey

surveyanswers
Answer choices for a survey.

surveyquestions
Questions assigned to a survey.

surveyresult
Answers given by survey takers.

surveyuser
Assigns a contact as having taken a specific survey.

forumauth
forum auth

forumposts
forum posts

forums
forums

forumthreads
forumthreads

sportgames
A match between 2 teams.

sportleagues
Sport Leagues

sportleagueteams
Assigns a sports team to a league/season.

sportpositions
Sport positions that players belong to (exa: forward, guard, etc).

sportstats
Game statistics for players.

sportstattypes
Types of sports stats (exa: Foul, Rebound, Assist, etc)

sportteamplayer
Assigns a member as a player of a specific team (sportsleagueteam).

sportteams
Sport teams that can be assigned to leagues/seasons.

legalcontracts
Legal Contracts

legalcontractsign
Sign Legal Contracts

bannercreatorfields
Banner Creator Fields

bannercreatortemplates
Banner Creater Template

slidebanners
Slide Banner

slidebannerstyles
Slide Banner Style

urlshortnerstats
Statistics of visits through a URL shortner.

videolibraryratings
A rating by a member of a video in a video library.

documentqna
Assigns a question to a specific document. Used for grouping questions in the knowledge base as well as for creating quizzes.

questionaccess
Questions and Answers Access

questioncategories
Questions and Answers Categories

questionkeywordassign
Assigns a keyword to a question.

questionkeywords
Keywords for questions and answers.

questions
Questions and Answers

questionsearches
A history of searches of the question knowledge base or where people have asked a new question.

event
Events or reservations for services, products, rentals, etc. Basically, anything where a purchase or RSVP is made for something for a specific date (hotel reservation, concert ticket, car rental, etc.)

eventprice
The price of a ticket to attend an event.

eventsettings
Global event settings for events where tickets are sold to the event.

eventticket
A ticket that has been purchased for a specific event.

eventtypes
A type of event (exa: concert, game, etc).

designnotes
Notes added to a design by a member indicating revision requests.

designphotos
Photos selected by members for their design.

designrevisions
Revisions to a design.

designs
A design purchased by a member.

designtemplates
Design templates for specifying what information to collect from a member to use for the copy for their design when they purchase this type of design.

designtypes
Types of designs available for sale.

quiz
A quiz question that a member or contact can take.

quizanswers
Possible answers of a quiz question.

quizque
Questions in que for a member/contact to answer.

quizresponse
An answer given by a contact or member to a quiz question.

articlesites
Article sites used by the submission tool.

seodata
SEO metadata for a site.

supportrequest
Support requests awaiting approval.

taskclientrating
A rating by a member on how well the task was performed by an employee.

taskissues
Issues with a task (items not complete or done wrong by the worker). For internal use, not seen by non employees.

taskskills
Assigns skills (employee skills) to a task.

tasktimesheet
A timesheet of time spent working on a specific task.

68expensecategories

68expenses

68moneyaccountbalances

68moneyaccountfiles
A file (pdf or image) that is attached to a money account (exa: A bank statement).

68moneyaccounts
Money accounts, such as cash, checking accounts, PayPal, foreign currency, etc.

68moneyprojects

68moneytransferother

68moneytransfers

68vendors

employeebonus
Bonuses given to employees.

employees
Additional metadata for members that are employees.

managerscores
Scores of client managers generated hourly based off open tasks, emails, and other indicators of their performance.

monitorimage
A history of screenshots taken of an employee's screen (monitor) while they are timed in.

nudge
A short, high priority message sent to an employee.

skillassign
Assigns a skill to a member.

skills
Skills that can be assigned to employees.

timesheet
A history of when an employee worked.

dictionary
Dictionary of language definitions for increasing vocabulary.

documentdict
Assigns a dictionary item (for vocabulary) to a document.

mymath
Math ranking scores for members used for the math quiz.

studyhistory
A history of items that a member has read or used the memorize tool with.

studylesson
A study lesson which is a collection of assignments for a member or contact to complete.

studylessonassign
An assignment for a study lesson.

studylessondone
A log of study lesson assignments completed by members or contacts.

vocabulary
Vocabulary items for reference and that can be used with the vocabulary quiz.

billing
Billing options for being a member of the site.

cancellations
Cancellation requests by members cancelling their membership.

nextbill
The next date that a member will be billed for their membership. Only used under certain circumstances. Typically billing is handled by the payment processor.

payment
Payments made by members for their membership to the site.

paymentprocessorsetup
A record of a member setting up a payment processor. Used by the paymentprocessorvars table where the member puts their details for the payment processor.

paymentprocessorvariables
A list of variables that exist for a payment processor that a member will enter when setting it up (exa: Security Key).

paymentprocessorvars
Member's variables for a specific payment processor setup (exa: "Security Key" value).

rankassign
Assigns a member to a rank.

rankbadgeassign
Assigns a rank badge to a member.

rankbadges
Badges that members can earn.

ranklock
Assigns content that is unlocked by this rank.

rankpoints
Experience points earned by members by performing actions.

rankpointtypes
Types of experience points that members are able to earn.

rankqualify
Specifies qualifications a member needs to be assigned to a specific rank.

ranks
Ranks that members can belong to.

emailautoresponders
Email autoresponder messages.

emailbroadcastque
A que of broadcast emails to be sent.

emaillinkclicks
History of each time a contact clicks on a link in an email.

emaillogs
A record of all emails that have been sent.

emailque
A que of emails to be sent. All follow up and broadcast messages are sent through emailque.

emailtemplates
Email templates which can be used when sending emails or creating autoresponder messages.

removear
Disables an autoresponder message for a specific member.

signatures
A member's signature (name, phone, etc) that will appear at the bottom of every email they send.

downloads
Downloads that can be downloaded from the members area (secure downloads) or can be made public for anyone to download.

banners
Banners for promoting the site.

mobilecredits
Credits assigned to members that they can use to convert web pages to mobile friendly pages.

mobileusage
A history of usage where members converted a web page (or set of pages) to mobile friendly pages.

pagecurl
A notification that is sent to a URL when someone opts into the specified page.

pageexitpopups
Page exit popup seen when someone tries to leave the page.

pageforms
Capture page form fields. Each record is a field in the form.

pageformsettings
capture page form settings

pagepasswords
Password protection for a page

pagerecommend
A recommendation by a member of a page that was created by that member asking the admin to include the page in the site for all members to be able to use.

scheduledvars
Scheduled variables that can have multiple time triggered values (content) assigned to it.

scheduledvarvalues
Scheduled values (content) belonging to a scheduled variable.

tracking
Tracking campaigns for tracking page performance and split testing.

trackingassign
Assigns a page to a specific tracking campaign.

wizard
Wizard

wizardsettings
Wizard Settings

calendars
Member Calendar

meetingattendees
Assigns members as attendees of specific meetings.

meetingchats
Messages sent by a member inside of a meeting.

meetings
Meetings

invoice
An invoice.

invoiceitems
A line item assigned to an invoice.

shoppingcart
Items in a member's shopping cart.