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.

adminpagecontents
Displays HTML content added to admin pages using the wizard

adminpagesettings
Admin page settings as set while logged in as admin

adminsettings
Settings for the website. DO NOT update directly.

apiactions
Set the actions for an API

apikeylogs
API Logs

apikeypermissions
Add/show permissions for API Keys

apikeys
a table to set/show API keys

blockedemails
Block email addresses to prevent them from receiving emails or optin

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.

contactpoints
The settings showing number of points a contact can earn for different actions. 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.

cookieapprovals
GDPR Cookie approvals including IP and visit info

countrycodes
Country codes for phone numbers

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

cronlogs
a table contains logs for the setup cron jobs

deleteque
A que to delete records with restore query

doccategories
Document Categories

documentfolders
Documents parent folders (categories). Used to categorize the documents.

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.

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

emailaddresses
Members/Contacts email addresses

emailassign
Assign email address to a contact/member

errors
Debug and errors reports and details.

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.

ips
Members/contacts and visitors IPs.

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.

menus
The navigation menus in the member's area.

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

notificationoffassign
Assign notifications to members

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.

phoneassign
Assign phone number to a member/contact

phonenumbers
Members/contacts phone numbers

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

privacypolicies
A custom privacy policy page for a member.

reports
Error reports

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.

smscarriers
SMS carriers for phone SMS notifications

smtpaccounts
SMTP accounts

stats
Statistics of page views.

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

thirdpartyautorespondervalues
Third Party Autoresponder setup settings

useragents
Details about page views browser user agents

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.

visitors
A table contains visitors details like contact id/member id , referrer etc

visitreferrers
Visit Referrers URL

visits
A table contains all visits to pages including details like visit IP, monitor size, referrer... etc

warnings
System error warnings (debug warnings)

webapplinks
Web application links URls

webappshortcuts
Web applications shortcuts

commissionholdings
holding payments to members

commissions
Commissions earned by members.

commissiontierrollups
Roll up commission Settings

commissiontiers
Commission tiers (levels).

membershipbonuses
Membership Bonuses

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

showcases
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.

newssettings
News settings

productcategories
Categorize products to different categories

productcategoryassign
Assign products to product categories

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

productimages
Images uploaded to products as feature images

productpackages
Assigns an 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.

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

products
Products (External products) details

productvars
Product variables which people can select from to apply to the checkout. like color or size etc

productvarvalues
Product variable values

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

chatsettings
Live chat settings for a specific member.

smsaccountextensions
SMS account extensions

smsaccounts
SMS Accounts

smsar
SMS/Voice autoresponder.

smsautoresponders
SMS Autoresponder follow up messages

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

smsfailures
SMS failure logs

smsinbox
SMS inbox

smskeywords
SMS Keywords to send automatic replies

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

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

facebookvideo
Facebook Video Plugin

googlecalendar
Connects Google Calendar to system 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

socialprofiles
Social Profile

socialprofiletypes
Social Profile Types

socialprofilevars
Social Profile Variables

socialque
Social content que

socialsettings
Social Settings

socialsites
Social Sites

socialstats
Social Stats

socialvars
Social variables

socialvartemplates
Social Variables Template

socialvartemplatevars
Social Template variables

formtemplates
An optin form template.

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

funnelactivity
Funnel activity stats details

funnelpages
Assigns a page to a marketing funnel.

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

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

blogentries
A blog entry.

blogs
Blogs created by members.

blogtemplates
blog templates layout and style

blogvar
Blog Variable

slideshowimages
Images that are assigned to an image slider.

slideshows
Settings for an image slider that rotates between images.

adcoops
An ad coop that members can purchase shares of.

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

surveyanswers
Answer choices for a survey.

surveyquestions
Questions assigned to a survey.

surveyresults
Answers given by survey takers.

surveys
Survey

surveyusers
Assigns a contact as having taken a specific survey.

forumauth
Form Access details

forumpostlikes
Statistics for forum post likes

forumposts
Forum posts

forums
Forums created by members to share their threads with people

forumthreads
Forum threads

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)

sportteamplayers
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

bannercreators
Banner Creater

slidebanners
Slide Banner

slidebannerstyles
Slide Banner Style

urlshortnerstats
Statistics of visits through a URL shortner.

videocomments
Visitor comments to the videos shared by members/admin

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

videos
Allows members to share videos with other members in the members area

videostats
statistics for a video shared in videos tool

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

documentquestionassign
Assign a document to question

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.)

eventdiscounts
Event discounts on mass amounts

eventextras
Event extras prices and details

eventprices
The price of a ticket to attend an event.

eventrecurremove
Remove event recur log

eventrecurs
Recur events (the repeated events every X amount of days)

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

eventtickets
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.

quizanswers
Possible answers of a quiz question.

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

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

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

articlesites
Article sites used by the submission tool.

seodata
SEO metadata for a site.

skillassign
Assigns a skill to a member.

skills
Skills that can be assigned to employees.

supportrequests
Support requests awaiting approval.

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

taskgroups
Task groups

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

tasklevels
Set rate for different task levels

taskrecurs
recur tasks (repeat tasks) every X amount of time

tasksettings
Custom Task settings

taskskills
Assigns skills (employee skills) to a task.

tasktemplates
Pre-saved task templates to select from when creating a task

tasktimesheets
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

employeebonuses
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.

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

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

timesheet
A history of when an employee worked.

timesheets
Employee working / time-in on task timesheet

dictionary
Dictionary of language definitions for increasing vocabulary.

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

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

lessonassignments
An assignment for a study lesson.

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

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.

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

billing
Billing options for being a member of the site.

billingagreementpayments
Billing agreement payments

billingagreements
Billing Agreements

billingpaymentexceptions
Billing payment exceptions like rollup

billingpayments
Billing payments

billingrequirements
Billing requirements

blockioaddresses
Block.io payment processor settings

btctransactions
BTC payment processors transactions

cancellations
Cancellation requests by members cancelling their membership.

creditcardtokens
Credit card tokens

currencyexchange
Currency exchange details

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.

passups
Billing passup settings

paymentprocessors
Payment Processors

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.

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

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

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

promocodes
Promo codes details

squarecheckoutids
Square payment processor settings

squarelocationids
Square payment processor location id settings

stripecustomers
Stripe payment processor customer details

stripeplans
Stripe payment processor plans for recur payments

rankassign
Assigns a member to a rank.

rankbadgeassign
Assigns a rank badge to a member.

rankbadges
Badges that members can earn.

ranklocks
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.

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.

emailautoresponders
Email autoresponder messages.

emailbroadcasts
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.

bannerstats
Promoting site/URL banners stats

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

pagerecommendations
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.

wizards
Wizard

wizardsettings
Wizard Settings

calendars
Member Calendar

matrixcyclebonuses
Bonus applied to matrix once a cycle completed.

matrixdirectpaypassups
Direct pay passups for matrix payments.

matrixes
Allows admin to create/ manage matrix compensation plans

matrixnextspots
Placeholder for matrix next step when using payments which require time to get approved

matrixque
Matrix que to assign members to matrix spots

matrixspots
Matrix spots details including level, added and completed status

albumaccess
Album access settings for different types of users

albumassign
Assign songs to albums

albums
Music albums

musiclinks
The links to play the music

playlists
Music playlists created by members

songaccess
Song access settings for different type of memberships/members

songplaylogs
Log for all stats for song play by members

songs
Music songs

photocategories
Uploaded photos categories

photos
Uploaded photos to site by members

placecategories
Directory items categories

placecategoryassign
Assign category to a place item

placedetails
Place (directory item) details

placedetailtypes
Place details type as text or textarea or other format

placephotos
Place(directory) photos

placeratingcomments
Place (directory item) comments

placeratinglikes
Place (directory item) likes by visitors/members

placeratings
Directory(place) ratings

places
Directory creator

placetypes
Place(directory item) types

scheduletemplates
Schedule templates

scheduledcontents
Schedule content to show to the pages in the future date.

scheduledcontentvalues
Schedule content to show to the pages in the future date.

pushnotificationkeys
Push notification key

pushnotifications
Push Notifications to members

offerstats
Offer statistics (visits and actions)

offertemplates
Offer templates

chatbotepisodes
Chat bot Episodes

chatbotlogs
Chat bot logs

chatbots
Chat bots created by members

chatbotsteps
Chat bot steps

appointmentrequests
Member appointment requests by other members or visitors

banneradcredits
Assign banner ads credits to members

bannerads
Members banner ads to show in members area

banneradstats
Banner ads statistics including clicks and visits

loginadcredits
Assign login ad credits to members.

loginads
Advertisement banners showing on member login

loginadstats
Login ad statistics

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

memberstepactions
Actions when clicking member step buttons

memberstepcomplete
Mark a member step as complete

membersteps
Editable member steps by admin that allowed members to follow number of steps to reach a target

mobileoptinbuttons
Mobile Optin Buttons Creator

meetingattendees
Assigns members as attendees of specific meetings.

meetingchats
Messages sent by a member inside of a meeting.

meetings
Meeting (chat panel) between members.

invoicecart
Shopping cart invoice

invoiceitems
A line item assigned to an invoice.

invoices
An invoice.

productreviews
Product review and rating

shoppingcarts
Items in a member's shopping cart.