Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2024.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

Creative Commons Attribution-ShareAlike License All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2023.

Survloop: Database Design Specs

subscription_changes
(chng_)

User Subscription Changes
Group: Users
Type: Data
8 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_changes Unique ID

chng_id
Number, Indexed, Primary Key

User ID#

chng_user_id

Users(1,1)-(0,N)

Previous Subscription Level

chng_lev_from

User Subscription Levels(0,1)-(0,N)

New Subscription Level

chng_lev_to

User Subscription Levels(0,1)-(0,N)

Subscription Notes

chng_notes

Previous Paid Through Date

chng_paid_from

New Paid Through Date

chng_paid_to

Previous Subscription Period

chng_period_from

New Subscription Period

chng_period_to
subscription_pay_redir
(paid_)

User Subscription Paid Redirects
Group: Users
Type: Data
7 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_pay_redir Unique ID

paid_id
Number, Indexed, Primary Key

User ID#

paid_user_id

Users(0,N)-(0,N)

Subscription Level Slug (redirect parameter)

paid_lev_slug

Chargebee Subscription ID (redirect parameter)

paid_sub_id

Chargebee Invoice ID (redirect parameter)

paid_invoice_id

Chargebee Redirect ID Parameter

paid_param_id

Chargebee Payment State (redirect parameter)

paid_state

Site Session ID#

paid_sess_site_id

Site Session(1,1)-(0,N)
subscription_users
(sub_usr_)

User Subscriptions
Incoming: User Subscriptions(0,N)-(1,1)
1 Table with Foreign Key
Group: Users
Type: Data
11 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_users Unique ID

sub_usr_id
Number, Indexed, Primary Key

User ID#

sub_usr_user_id

Users(1,1)-(0,1)

Subscription Level ID#

sub_usr_level_id

User Subscriptions(1,1)-(0,N)

Paid Through Date

sub_usr_paid_through

Subscription Period

'M' for Monthly, or 'Y' for Yearly
Values: M ; Y ( default value: M )
sub_usr_period

Subscribed Since

sub_usr_subscribed_since

Overall User Activity Score

( default value: 0 )
sub_usr_activity

Last Login

sub_usr_last_login

First Name

sub_usr_first_name

Last Name

sub_usr_last_name

Company

sub_usr_company

Phone Number

sub_usr_phone
subscription_payments
(pay_)

User Subscription Payments
Group: Users
Type: Data
6 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_payments Unique ID

pay_id
Number, Indexed, Primary Key

User ID#

pay_user_id

Users(1,1)-(0,N)

Date of Payment

pay_date

Payment Method

pay_method

Payment Amount

pay_amount

Invoice ID#

pay_invoice_id

Payment Notes

pay_notes
subscription_levels
(lev_)

User Subscription Levels
Tracks different subscription levels/categories for users.
Incoming: User Subscription Changes(0,N)-(0,1), User Subscription Changes(0,N)-(0,1)
2 Tables with Foreign Keys
Group: Users
Type: Data
12 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_levels Unique ID

lev_id
Number, Indexed, Primary Key

Subscription Level Name

lev_name

Subscription Level Description

lev_desc

Monthly User Cost ($)

lev_cost_monthly

Yearly User Cost ($)

lev_cost_yearly

Active Users Count

( default value: 0 )
lev_cnt_active_users

URL to Checkout with Monthly Subscription

lev_url_checkout_monthly

URL to Checkout with Yearly Subscription

lev_url_checkout_yearly

Subscription Level Slug

lev_slug

Is Active/Public

lev_is_active

Icon

lev_icon

Color (hex)

lev_color

Payment Thank You Message

lev_paid_thanks
subscription_stats
(stat_)

User Subscription Stats
Track various metrics related to system subscribers.
Group: Users
Type: Data
8 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

subscription_stats Unique ID

stat_id
Number, Indexed, Primary Key

Date of Stats Snapshot

stat_date

Active Monthly Subscribers

stat_active_monthly_cnt

Active Yearly Subscribers

stat_active_yearly_cnt

Inactive Monthly Subscribers

stat_inactive_monthly_cnt

Inactive Yearly Subscribers

stat_inactive_yearly_cnt

Active Monthly Payments

stat_active_monthly_pay

Active Yearly Payments

stat_active_yearly_pay

Subscription Level Breakdowns

JSON data dump
stat_level_breakdowns
users
()

Users

This represents the Laravel Users table, but will not actually be implemented by Survloop as part of the database installation.
Incoming: Databases(0,N)-(0,11), Trees(0,N)-(0,11), User Session(0,N)-(11,11), User Roles(0,N)-(0,N), User Activity(0,N)-(11,11), Log Actions(0,N)-(11,11), Design Tweaks(11,11)-(11,11), Session Emojis(0,N)-(0,1), Tokens(0,N)-(0,1), Emailings(0,N)-(0,0), Emailings(0,N)-(0,1), Gallery Images(0,N)-(0,1), Discussion Comments(0,N)-(1,1), Discussion Thread Followers(0,N)-(1,1), Discussion Comment Likes(0,N)-(1,1), User Subscriptions(0,1)-(1,1), User Subscription Payments(0,N)-(1,1), Errors(0,N)-(0,1), User Subscription Changes(0,N)-(1,1), Contact Form(0,N)-(0,1), Contact Form(0,N)-(0,1), User Subscription Paid Redirects(0,N)-(0,N)
22 Tables with Foreign Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

Users Unique ID

id
Number, Indexed, Primary Key

Username

name
Text

Email Address

email
Text
users_roles
(role_user_)

User Roles
Each record represents one linkage between a Laravel system User and a User Role as defined by it's unique ID in the Definitions table.
Group: Users
Type: Linking
2 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

users_roles Unique ID

role_user_id
Number, Indexed, Primary Key

User ID

Indicates the unique User ID related to the User being granted permissions in this record.
role_user_uid

Users(0,N)-(0,N)

Role ID

Indicates the unique Definition ID related to a User Role being granted in this record.
role_user_rid
emails
(email_)

Email Templates
Each record represents one Email Template which can be used throughout Survloop.
Incoming: Emailings(0,N)-(1,1)
1 Table with Foreign Key
Group: Users
Type: Data
7 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

emails Unique ID

email_id
Number, Indexed, Primary Key

Tree ID

Indicates the unique Tree ID related to the home Tree of this Email Template.
email_tree

Trees(0,1)-(0,N)

Type

Indicates the general type of Email Template being stored here.
email_type

Template Name

Indicates the name of this Email Template, as it will be referred to internally within the system.
email_name

Default Subject Line

Indicates the default subject line of emails sent out using this template.
email_subject

Default Email Body

Indicates the default main content of emails sent out using this template.
email_body

Options

Indicates any options necessary to accurately define the properties of this Email Template.
( default value: 1 )
email_opts

Total Emails Sent

Indicates the total number of individual Emails sent using this Email Template.
( default value: 0 )
email_tot_sent
emailed
(emailed_)

Emailings
Each record represents one individual Email Template Mailing, including a copy of the auto-generated (then optionally customized) body of the sent email.
Group: Users
Type: Data
10 Fields Total
4 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

emailed Unique ID

emailed_id
Number, Indexed, Primary Key

Tree ID

Indicates the unique Tree ID which sent this email.
emailed_tree

Trees(0,1)-(0,N)

Core Record ID

Indicates the unique Record ID of the core table of the Tree sending this email.
emailed_rec_id

Email Template ID

Indicates the unique Email Template ID which is being sent.
emailed_email_id

Email Templates(1,1)-(0,N)

Recipient Email Address

The email address this message is being sent to.
emailed_to

Recipient User ID

Indicates the unique User ID of the User this email is being sent to.
emailed_to_user

Users(0,0)-(0,N)

Sender User ID

Indicates the unique User ID of the User initiating this emailing.
emailed_from_user

Users(0,1)-(0,N)

Subject Line

Indicates the subject line of this specific email, even if it is different than the default, auto-generated version from the Email Template.
emailed_subject

Email Body

Indicates the body of this specific email, even if it is different than the default, auto-generated version from the Email Template.
emailed_body

Options

Indicates the options or flags stored with this emailing.
( default value: 1 )
emailed_opts

Attachment

emailed_attach
tokens
(tok_)

Tokens
Each record one security token, of various types, which can be sent to a user to confirms some action or grant some access with greater security.
Group: Users
Type: Data
5 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

tokens Unique ID

tok_id
Number, Indexed, Primary Key

Token Type

Indicates which type of Token has been created and stored here.
Values: Confirm Email ; Sensitive ; MFA
tok_type

User ID

Indicates the unique User ID number whose token is logged in this row.
tok_user_id

Users(0,1)-(0,N)

Tree ID

Indicates the unique Tree ID number to which this token relates.
tok_tree_id

Trees(0,1)-(0,N)

Submission Record ID

Indicates the unique record ID number of the completed submission to which this Token relates.
tok_core_id

Generated Token

Indicates the randomly generated string which is stored as a Token for a User's specific interaction with the database.
tok_tok_token
contact
(cont_)

Contact Form
Each record represents one complete submission of the default Contact Form.
Group: Users
Type: Data
9 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

contact Unique ID

cont_id
Number, Indexed, Primary Key

Contact Type

Indicates which type of contact the site visitor is making with us.
cont_type

Flag

Indicates the current internal status of this Contact submission, important for organizing contact records which need attention by system administrators.
Values: Unread ; Read ; Trash ( default value: Unread )
cont_flag

Email Address

Indicates the email address of the site visitor who completed the Contact Form, important for responding to them.
cont_email

Message Subject Line

Indicates the subject line (or title) of the site visitor's Contact Form submission. This is important for more quickly identifying and classifying the nature of the request.
cont_subject

Message Body

Indicates the main body of the site visitor's Contact Form submission, providing all the rest of the details of their request. This also includes a dump of any other fields which may have been built into the Contact Form.
cont_body

From User ID#

cont_from_user_id

Users(0,1)-(0,N)

To User ID#

cont_to_user_id

Users(0,1)-(0,N)

Core Table ID#

cont_core_tbl

Database Tables(0,1)-(0,N)

Core Record ID#

cont_rec_id
databases
(db_)

Databases
Each record represents one Database being designed in Survloop, a collection of Tables, Fields, Definitions, and Business Rules often owned by a User. Information stored here can define core system settings.
Incoming: Database Tables(0,N)-(11,11), Database Fields(0,N)-(11,11), Business Rules(0,N)-(11,11), Definitions(0,N)-(11,11), Trees(0,N)-(11,11), Conditions(0,N)-(11,11), Log Actions(0,N)-(11,11), Gallery Images(0,N)-(1,1)
8 Tables with Foreign Keys
Group: Databases
Type: Data
8 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

databases Unique ID

db_id
Number, Indexed, Primary Key

Database Owner User ID

Indicates the unique User ID number belonging to the owner of this Database.
db_user

Users(0,11)-(0,N)

Database Prefix

Indicates the short abbreviation which is used to start each Table Name within this Database. This is important for successfully creating and accessing all Database Tables.
db_prefix

Database Name

Indicates the main, casual, name of the Database in English.
db_name

Database Description

Indicates the short tagline which is used to describe this Database. This is generally related to Search Engine Optimization.
db_desc

Database Mission

Indicates the desired goals to be accomplished with this Database. This is important for reminding Users why they are using this system.
db_mission

Database Options

Indicates the multiple of various prime numbers which mark specific qualities of this Database.
Notes: %3 Simple Field Specifications
( default value: 1 )
db_opts

Total Tables

Indicates the cached total number of Tables which make up this Database.
( default value: 0 )
db_tables

Total Fields

Indicates the cached total number of Fields which make up this Database.
( default value: 0 )
db_fields
tables
(tbl_)

Database Tables
Each record represents one Table in the Database, which is a collection of any number of Fields.
Incoming: Database Tables(0,N)-(0,1), Database Fields(0,N)-(0,11), Database Fields(0,N)-(0,11), Trees(0,N)-(0,11), Conditions(0,N)-(0,N), Data Linkage Tables(0,N)-(11,11), Log Actions(0,N)-(11,11), Contact Form(0,N)-(0,1)
8 Tables with Foreign Keys
Group: Databases
Type: Data
14 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

tables Unique ID

tbl_id
Number, Indexed, Primary Key

Table Database ID

Indicates the unique Database ID number which this Table belongs to.
tbl_database

Databases(11,11)-(0,N)

Table Prefix

Indicates the short abbreviation which is used to start each Field Name within this Table. This is important for successfully creating and accessing all Table Fields.
tbl_abbr

Table Name (in Database)

Indicates the shorter Table Name without spaces or special characters which is used to technically identify this Table when accessing its records in the Database. During system use, the Database's Prefix will be added to the start of the Table Name in this record.
tbl_name

Table Name (in English)

Indicates the main, casual, name of the Database Table in English.
tbl_eng

Table Description

Indicates the full description of this Database Table. This should generally be a sentence or two describing what information is stored in a Table, why it is important, and perhaps why this information is being organized in the form of this Table.
tbl_desc

Table Internal Notes

Indicates the any important Notes related to this Database Table. This can be important for providing documentation or other internal comments about how or why this Table was designed in this way.
tbl_notes

Table Type

Indicates whether this Database Table stores Data, Subset data, data Linkages, or data Validation. This is important for internal organization and documentation of the Database Design.
Values: Data ; Subset ; Linking ; Validation ( default value: Data )
tbl_type

Table Group

Indicates which Group of Table this record belongs to. This can be important for visually organizing Tables, and works best if Tables in the same Table Group are all adjacent in the Table Order within the Database.
tbl_group

Table Sorting Order

Indicates the indexed order of this Table, relative to other Tables in the Database. This is only important for presenting the list of Tables to a Database Designer, and additional value can be added by using Table Groups.
( default value: 0 )
tbl_ord

Table Options

Indicates the multiple of various prime numbers which mark specific qualities of this Table.
Notes: %3 Table Has User-Defined Primary Key
( default value: 1 )
tbl_opts

Extension of Table

Indicates whether or not this Database Table is an extension of another Table. This means it inherits all of the other Table's fields, plus whatever you add here.
( default value: 0 )
tbl_extend

Database Tables(0,1)-(0,N)

Total Fields

Indicates the cached total number of Fields which make up this Table.
( default value: 0 )
tbl_num_fields

Total Foreign Keys Outgoing

Indicates the cached total number of Foreign Fields in this Table which point to other Database Tables.
( default value: 0 )
tbl_num_foreign_keys

Total Foreign Keys Incoming

Indicates the cached total number of Foreign Fields in other Tables which point to this Database Table.
( default value: 0 )
tbl_num_foreign_in
fields
(fld_)

Database Fields
Each record represents one data Field where specific information will be stored in the completed Database.
Incoming: Uploads(0,N)-(0,1), Database Fields(0,N)-(0,N), Conditions(0,N)-(0,N), Log Actions(0,N)-(0,11)
4 Tables with Foreign Keys
Group: Databases
Type: Data
39 Fields Total
4 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

fields Unique ID

fld_id
Number, Indexed, Primary Key

Field Database ID

Indicates the unique Database ID number which this Field belongs to. This is important to track for generic fields which are not related to a specific Database Table.
fld_database

Databases(11,11)-(0,N)

Field Table ID

Indicates the unique Table ID number which this Field belongs to.
Notes: The parent table where this field is used. Only Generic fields have no table assigned. (Hernandez p.279)
fld_table

Database Tables(0,11)-(0,N)

Field Sorting Order in Table

Indicates the indexed order of this Field, relative to other Fields within their Database Table. This is only important for presenting the list of Fields to a Database Designer.
( default value: 0 )
fld_ord

Field Specification Type

Indicates whether this Database Field specification is Unique Field to this Table's instance, or is a Replica Field of a Generic Field shared by multiple Tables, or is itself a Generic Field. This can be important for documenting which Fields might need to maintain parallel changes in their specifications.
Notes: Unique - any kind of field that will appear only once within the entire database or a primary key; Generic - a field that serves as a template for other fields within the database; Replica - a field that you base on a given generic field or a foreign key; (Hernandez p.279)
Values: Unique ; Generic ; Replica ( default value: Unique )
fld_spec_type

Field Spec Generic Source

If this record specification type indicates that it stores a Replica Field, then this information represents the unique Field ID of related the Generic Field.
Notes: If this field is a Replica, the Specification Source is set to the Generic field which it mimics. To turn this field into a Replica, select a Generic field from the dropdown and click the Load link. To save a copy of this field as a Generic for future reuse, click the Save As Generic link. (Hernandez p.281)
( default value: -3 )
fld_spec_source

Database Fields(0,N)-(0,N)

Field Name (in Database)

Indicates the shorter Field Name without spaces or special characters which is used to technically identify this Field when accessing its stored values in the Database. During system use, the Table's Prefix will be added to the start of the Field Name in this record.
Notes: Absolute minimal words that uniquely identifies this field, following database requirements (like probably no spaces). The table abbreviation name will be tacked on to the beginning. (Hernandez p.277)
fld_name

Field Name (in English)

Indicates the main, casual, name of the Database Field in English.
Notes: This label is an alternate name by which you can identify the field within an end-user application interface. Something readable. (Hernandez p.279)
fld_eng

Field Alias(es)

Indicates any other names this specific Field might be known as.
Notes: A name (or set of names) that you use for the field in very rare circumstances. This must be used if there are two occurrences of this field in the same table. (Hernandez p.281)
fld_alias

Field Description

Indicates the full description of this Database Field. This should generally be a sentence or two describing what information is stored in this Field, and why it is important.
Notes: A complete interpretation of the field. Write a clear and succinct statement that accurately identifies the field and clearly states its purpose within the table. Avoid technical jargon, acronyms, abbreviations, and implementation-specific information. (Hernandez p.283)
fld_desc

Field Internal Notes

Indicates the any important Notes related to this Database Field. This can be important for providing documentation or other internal comments about how or why this Field was designed in this way, or where a list of potentially stored values came from.
Notes: Extra space for internal notes, often reserved for implementation-specific information, or planning in progress.
fld_notes

Foreign Key Table ID

If this Field is a Foreign Key pointing to another Database Table, then this is where that unique Table ID is stored. This is important for tracking data linkages through the Database Design.
( default value: -3 )
fld_foreign_table

Database Tables(0,11)-(0,N)

Degree of Participation: Outgoing Min

If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of this Table's records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database.
( default value: 1 )
fld_foreign_min

Degree of Participation: Outgoing Max

If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of this Table's records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database.
( default value: 1 )
fld_foreign_max

Degree of Participation: Incoming Min

If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of a Foreign Table's records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database.
( default value: 1 )
fld_foreign2_min

Degree of Participation: Incoming Max

If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of a Foreign Table's records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database.
( default value: 1 )
fld_foreign2_max

Field Values

Storing information here indicates that this Database Field can only be set to a specified range of values, separated by semi-colons. (* This field needs to be replaced by a helper table which stores each value as its own record, or perhaps preferably using the Definitions table. *)
Notes: Specifies every possible valid value for a field. You can optionally select a pre-definined value set which is common among various fields. (Hernandez p.294)
fld_values

Default Value

Indicates the default value for this specific Field, when a new Table record is first created.
Notes: A value that a user can into a field when a more appropriate value is not yet available, nulls not allowed. Use a default value ONLY if it is meaningful. (Hernandez p.294)
fld_default

Is Indexed

Indicates whether or not this Field is to be indexed by the Database for faster searching of this specific field. This is important for ideal Database creation.
Notes: When this project is finished, will this field be searched or sorted very very often? A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. (NOT Hernandez approved planning.)
Values: 0 ; 1 ( default value: 0 )
fld_is_index

MySQL Data Type

Indicates which basic MySQL type of data will be stored with this Database Field. This is important for determining how to export the database or otherwise install it to MySQL-based environments.
Notes: MySQL implementation-specific field type, needed for one-click database structure export. (NOT Hernandez approved planning.)
( default value: VARCHAR )
fld_type

Basic Data Type

Indicates the most basic nature of the data being stored by this Field, whether .
Notes: The most basic nature of the data that this field stores (not implementation-specific). (Hernandez p.286)
Values: Alphanumeric ; Numeric ; DateTime ( default value: Alphanumeric )
fld_data_type

Data Length

Indicates the total number of characters or digits that a user can enter for any stored value in this Database Field. This is important for ideal Database creation.
Notes: The total number of characters or digits that a user can enter for any given value of this field. If otherwise unimportant, this can be set to the maximum length for the best implementation-specific data type. (Hernandez p.289)
fld_data_length

Data Decimal Places

If this Field's basic data type is numeric, then this denotes the number of digits to the right of the decimal point in real numbers which can be stored in this Database Field.
Notes: If this field is Numeric, this denotes the number of digits to the right of the decimal point in a real number (eg. MySQL DOUBLE). (Hernandez p.289)
( default value: 0 )
fld_data_decimals

Character Support

Indicates the type of characters that a user can enter as a value for this Database Field. (* Multiple character types are currently stored as comma separated strings, but this should probably be some cleaner method. *)
Notes: The type of characters that a user can enter as a value for this field. Setting and enforcing this helps you ensure that the user cannot introduce meaningless data into the field, enhancing field-level integrity. Letters include foreign language letters. (Hernandez p.289)
Values: Letters ; Numbers ; Keyboard ; Special ( default value: ,Letters,Numbers,Keyboard,Special, )
fld_char_support

Input Mask

Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD
Notes: Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD (Hernandez p.290)
fld_input_mask

Display Format

Indicates the appearance of this Database Field's value when it is displayed on a screen or printed within a document.
Notes: The appearance of this field's value when it is displayed on a screen or printed within a document. (Hernandez p.291)
fld_display_format

Key Type

Indicates whether or not this Field is some kind of Key in its parent Database Table, including Foreign Keys, Primary Keys, or Alternate Keys. By default, all Survloop Tables will automatically generate a Unique, Primary Key if no such Field is specified by the Database Designer. (* Multiple key types are currently stored as comma separated strings, but this should probably be some cleaner method. *)
Notes: Designates this field's role within a table. (Hernandez p.292)
Values: Non ; Foreign ; Primary ; Alternate ( default value: ,Non, )
fld_key_type

Key Structure

If this Database Field is a Primary Key, then this indicates whether it is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key.
Notes: Denotes whether this field designated as a primary key is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key. (Hernandez p.292)
Values: Simple ; Composite
fld_key_struct

Edit Rule

Indicates whether or not a Field's data can or must be store at the Table record's creation, and whether or not it can it be edited by Users later.
Notes: Enter Now - user must enter a value when creating a new table record; Enter Later - user has the option of entering value when creating table record; Edits Allowed - user can edit the value at any time; Edits Not Allowed - after entering a value, user cannot edit it at any time; (Hernandez p.295)
Values: NowAllowed ; LateAllow ; NowNot ; LateNot ; NotDeterm ( default value: LateAllow )
fld_edit_rule

Has Unique Value

Indicates whether this Database Field's values are unique across all Table records.
Notes: Indicates whether this field's values are unique (always for primary keys, rarely for everything else). (Hernandez p.292)
Values: 0 ; 1 ( default value: 0 )
fld_unique

Has NULL Support

Indicates whether or not this Database Field accepts NULL values to be stored, which should represent missing or unknown information.
Notes: Whether this field accepts null values (not allowed for primary keys). Null values should represent missing or unknown values. (Hernandez p.293)
Values: 0 ; 1 ( default value: 1 )
fld_null_support

Values Entered By

Indicates whether a User or the System enter information into this Database Field.
Notes: The source of this field's value. Either a user will enter values into the field manually or a database application program will enter them automatically. (Hernandez p.293)
Values: User ; System ( default value: User )
fld_values_entered_by

Is Required

Indicates whether or not a User is required to enter a value for this Database Field.
Notes: Whether a user is required to enter a value for this field. No for most non-primary-key fields. (Hernandez p.294)
Values: 0 ; 1 ( default value: 0 )
fld_required

Compare Same Field Value

Indicates the types of comparisons can be applied to a given field value when retrieving information from the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)
( default value: 1 )
fld_compare_same

Compare Other Field Value

Indicates the types of comparisons can be applied to a given field value when retrieving information from the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)
( default value: 1 )
fld_compare_other

Compare Other Values

Indicates the types of comparisons can be applied to a given field value when retrieving information from the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)
( default value: 1 )
fld_compare_value

Operate with Same Field Value

Indicates the types of operations which can be applied to a given Field value with the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298)
( default value: 1 )
fld_operate_same

Operate with Other Field Value

Indicates the types of operations which can be applied to a given Field value with the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298)
( default value: 1 )
fld_operate_other

Operate with Other Value

Indicates the types of operations which can be applied to a given Field value with the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.
Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298)
( default value: 1 )
fld_operate_value

Field Options

Indicates the multiple of various prime numbers which mark other specific qualities of this Field.
Notes: %3 Field Is Auto-Managed by Survloop; | %1 XML Public Data; %7 XML Private Data; %11 XML Sensitive Data; %13 XML Internal Use Data;
( default value: 1 )
fld_opts
definitions
(def_)

Definitions
Includes lists of possible ranges of values for various data Fields throughout the database, and other system settings. This is important for providing dynamic storage for key system terminology which may infrequently change.
Incoming: Uploads(0,N)-(1,1), Session Emojis(0,N)-(1,1)
2 Tables with Foreign Keys
Group: Databases
Type: Data
7 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

definitions Unique ID

def_id
Number, Indexed, Primary Key

Definition Database ID

Indicates the unique Database ID number which this Definition belongs to.
def_database

Databases(11,11)-(0,N)

Set

This is a label for a set of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system definitions.
Notes: Potential for multiple languages in the future?
Values: Survloop Definition Types (Definitions) ( default value: Value Ranges )
def_set

Subset

This is a label for a subset of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system Definitions.
def_subset

Sorting Order in Subset

Indicates the indexed order of this Definition, relative to other Definitions within their Set and Subset of categorization. This is particularly important for providing order to the range of potential response values presented to Users.
( default value: 0 )
def_order

Is Active

Indicates whether or not this Database Definition is currently active in the system. This is important for disabling Definitions from the system without deleting them, either temporarily or permanently.
Values: 0 ; 1 ( default value: 1 )
def_is_active

Value

The dynamically stored text or value which Administrators can manage with a programmer. In the case of Value Ranges, this value is what a User will see, but the unique Definition ID will be stored as the User's response.
def_value

Description

The optional descriptive notes providing a deeper explanation of this specific Definition. For Value Ranges, this could also provide references and sources regarding the decision to include this Definition. Important for internal documentation and possibly User education.
def_description
bus_rules
(rule_)

Business Rules
Each record represents one Business Rule which specifies certain requirements to be maintained in the Database. Implementing the Rules defined here is important for maintaining data integrity.
Group: Databases
Type: Data
12 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

bus_rules Unique ID

rule_id
Number, Indexed, Primary Key

Rule Database ID

Indicates the unique Database ID number which this Business Rule belongs to.
rule_database

Databases(11,11)-(0,N)

Rule Statement

Indicates the text of the business rule itself, clear, succinct, and convey the required constraints in simple English.
Notes: The text of the business rule itself, clear, succinct, and convey the required constraints. (Hernandez p.409)
rule_statement

Rule Constraint

Indicates how the constraint specifically applies to the Database Tables and Fields, intended for a more technical audience.
Notes: A brief explanation of how the constraint applies to the tables and fields. (Hernandez p.409)
rule_constraint

Rule Tables

Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. *)
Notes: Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410)
( default value: , )
rule_tables

Rule Fields

Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. *)
Notes: Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410)
( default value: , )
rule_fields

Is Implemented In Application

Indicates whether or not this Business Rule can be directly implemented within the logical design of the database (Database-Oriented). Application-Oriented Rules will have to be implemented with custom coding, outside the scope of Survloop's automation.
Notes: Database-Oriented: impose constraints that you can establish within the logical design of the database; Application-Oriented: impose constraints that you cannot establish within the logical design of the database. (Hernandez p.397)
Values: 0 ; 1 ( default value: 1 )
rule_is_app_orient

Is Relationship-Specific

Indicates whether or not this Business Rule provides additional specifications to a Database Field in isolation, or to a Relationship multiple Fields or Tables.
Notes: Field-Specific and Relationship-Specific rules can be established in field specifications, but more details may be provided here if needed. (Hernandez p.399)
Values: 0 ; 1 ( default value: 1 )
rule_is_relation

Test Rule On

Indicates when the imposed Rule should be tested, whether upon inserting a new Table record, deleting a record, or updating a Field's value.
Notes: The constraint imposed should be tested when you attempt to perform: Inserting a record into the table or an entry into a field, Deleting a record from the table or a value within a field, or Updating a field's value. (Hernandez p.408)
Values: Insert ; Update ; Delete ( default value: Insert )
rule_test_on

Physical Elements Affected

Indicates the multiple of various prime numbers which represent physical data specifications related to this Rule, including Data Type, Length, Decimal Places, Character Support, Input Mask, and Display Format.
Notes: %2 Data Type, %3 Length, %5 Decimal Places, %7 Character Support, %11 Input Mask, %13 Display Format
( default value: 1 )
rule_phys

Logical Elements Affected

Indicates the multiple of various prime numbers which represent logical data specifications related to this Rule, including Key Type, Key Structure, Uniqueness, Null Support, Values Entered By, Required Value, Default Value, Range of Values, Comparisons Allowed, Operations Allowed, and Edit Rule.
Notes: %2 Key Type, %3 Key Structure, %5 Uniqueness, %7 Null Support, %11 Values Entered By, %13 Required Value, %17 Default Value, %19 Range of Values, %23 Comparisons Allowed, %29 Operations Allowed, %31 Edit Rule
( default value: 1 )
rule_logic

Relationship Characteristics Affected

Indicates the multiple of various prime numbers which represent data relation specifications related to this Rule, including Deletion Rule, Type of Participation, Degree of Participation.
Notes: %2 Deletion Rule, %3 Type of Participation, %5 Degree of Participation
( default value: 1 )
rule_rel

Action Taken

Indicates what actions have been taken, or need to be taken, to implement and enforce this Business Rule.
Notes: Indicate the modifications made to field specifications, etc, as clearly as possible. (Hernandez p.)
rule_action
errors
(err_)

Errors
Group: Infrastructure
Type: Data
5 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

errors Unique ID

err_id
Number, Indexed, Primary Key

User ID#

err_user_id

Users(0,1)-(0,N)

Error Description

err_desc

Error Stack Track

err_trace

Resolved

Values: 0 ; 1 ( default value: 0 )
err_resolved

Date & Time Logged

err_date
tree
(tree_)

Trees
Each Tree represents one collection of Nodes which one specific survey process, page of content, navigation menu, etc. Nodes are connected to each other to form a branching Tree which define all the details.
Incoming: Uploads(0,N)-(1,1), Tree Nodes(0,N)-(11,11), Data Loops(0,N)-(11,11), Data Subset Tables(0,N)-(11,11), Data Helper Tables(0,N)-(11,11), Data Linkage Tables(0,N)-(11,11), User Session(0,N)-(11,11), Searchable Record Dump(0,1)-(0,1), Session Emojis(0,N)-(1,1), Tokens(0,N)-(0,1), Emailings(0,N)-(0,1), Email Templates(0,N)-(0,1), Caches(0,N)-(0,N)
13 Tables with Foreign Keys
Group: Trees
Type: Data
11 Fields Total
6 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

tree Unique ID

tree_id
Number, Indexed, Primary Key

Primary Database ID

Indicates the unique Database ID number which this User Experience primarily belongs to.
tree_database

Databases(11,11)-(0,N)

Tree Owner User ID

Indicates the unique User ID number belonging to the owner of this User Experience or Tree.
tree_user

Users(0,11)-(0,N)

Tree Type

Indicates whether this Tree (collection of Nodes) indeed maps out a User Experience, or if it provides a map of the Database Design for the creating XML documents automatically-generated by Survloop.
Values: Primary Public ; Primary Public XML ( default value: Primary Public )
tree_type

Tree Name

Indicates the most succinct and clear name internally used to refer to this specific Tree.
tree_name

Tree Description

Documents a longer description of the purpose, use, and importance of this specific Tree.
tree_desc

Tree URL

Indicates the URL for the starting page of this Tree.
tree_slug

Root Node ID

Indicates the unique Experience Node ID of the first, Root Node of this entire User Experience. All other Nodes within this Tree are descendants of the Root Node.
tree_root

Tree Nodes(11,11)-(0,11)

First Page Node ID

Stores a cache of the unique Experience Node ID of this Tree's first Node which is a Page. This helps to quickly identify the URL of the first Page the user will experience.
tree_first_page

Tree Nodes(11,11)-(0,11)

Last Page Node ID

Stores a cache of the unique Experience Node ID of this Tree's last Node which is a Page. This helps to quickly identify the URL of the final Page the user will experience.
tree_last_page

Tree Nodes(11,11)-(0,11)

Tree Core Data Table

Indicates the unique Table ID which acts as the backbone for all data collected throughout this entire Tree.
tree_core_table

Database Tables(0,11)-(0,N)

Tree Options

Indicates the multiple of various prime numbers which mark specific other qualities of this Node.
Notes: %3 Admin-Only; %5 Tree That Is One Big Survloop; %7 Area Home Page (for Public, Admin, or Volun); %11 Record Edits Not Allowed (except by Admins); %13 Report for Survey (linked and shares core table); %17 Volunteers Access (& Admin); %19 Contact Form (Auto Page); %23 Page Is Skinny; %29 Page Not [Yet] Simple Enough To Be Cached; %31 Search Bar Results Page (for Public, Admin, or Volun); %37 Survey Navigation Menu Bottom; %41 Partners Member Access; %43 Staff Access; %47 Uses Public ID#; %53 Has Page Form; %59 Survey Navigation Menu Top; %61 Survey Progress Line
( default value: 1 )
tree_opts
nodes
(node_)

Tree Nodes
Each record represents one Node in the branching Tree, defining the critical details of each survey, page, etc. Each Node could represent the start of a new branch of the Tree, a new question asked of a User, or a new page which will ask multiple questions.
Incoming: Trees(0,11)-(11,11), Trees(0,11)-(11,11), Trees(0,11)-(11,11), Tree Nodes(0,N)-(0,N), Node Responses(0,N)-(11,11), Data Loops(0,N)-(11,11), User Session(0,N)-(11,11), User Session(0,N)-(0,11), User Session(0,N)-(0,11), Node Saves(0,N)-(11,11), Page Saves(0,N)-(11,11), Design Tweaks(11,11)-(11,11), Gallery Images(0,N)-(0,1)
13 Tables with Foreign Keys
Group: Trees
Type: Data
17 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

nodes Unique ID

node_id
Number, Indexed, Primary Key

Node Tree ID

Indicates the unique Tree ID number which this Tree Node belongs to.
node_tree

Trees(11,11)-(0,N)

Parent Node ID

Indicates the unique Experience Node ID of this Node's parent Node. This linkage is the thread which connect all Nodes as branches of the entire Experience Tree.
( default value: -3 )
node_parent_id

Tree Nodes(0,N)-(0,N)

Sibling Node Sorting Order

Indicates the indexed order of this Experience Node, relative to sibling Nodes which share the same Parent Node. This is how the branches of the entire Experience Tree stay sorted.
( default value: 0 )
node_parent_order

Node Type

Indicates whether this Experience Node represents either a branch (for navigation), a specific question to the User, a collection of questions as one page, a loop of many pages, or a specific manipulation of previously stored data. Question Nodes include Instructions, Radio, Checkbox, Drop Down, Text, Long Text, Text:Number, Email, Password, Date, Date Picker, Date Time, Time, Gender, Gender Not Sure, Feet Inches, U.S. States, Hidden Field, Spambot Honey Pot, Uploads, and Other/Custom. Nodes which are part of Trees which map XML output are of a separate XML Type.
Values: Page ; Branch Title ; Loop Root ; Data Manip: New ; Data Manip: Update ; Data Manip: Wrap ; Instructions ; Radio ; Checkbox ; Drop Down ; Text ; Long Text ; Text:Number ; Email ; Password ; Date ; Date Picker ; Date Time ; Time ; Gender ; Gender Not Sure ; Feet Inches ; U.S. States ; Hidden Field ; Spambot Honey Pot ; Uploads ; Other/Custom ; XML
node_type

Node Question/Prompt To User

Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores a title or name. For XML Nodes, this fields stores the name of the Database Table included in the mapped.
node_prompt_text

Node Side-Notes To User

Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores the Node's URL slug. For XML Nodes, this fields stores the unique Table ID of the Database Table included in the mapped.
node_prompt_notes

Extra HTML After Node Response

Stores any extra HTML, CSS, or Javascript which a Database Designer wants to appear directly after the User's opportunity to Respond to a Node's Prompt.
node_prompt_after

Internal Notes

Stores any internal notes which Experience Designers want to share.
node_internal_notes

User Response Set

Indicates the range of options the User will be provided for Node which ask some kind of multiple-choice question. This includes "Definition::{DefSubset}", "LoopItems::{LoopName}", or "[Set:{TableName};;HideIf:1]", but most Question Nodes have Response Options stored in the Node Responses table.
node_response_set

Default Response Value

Indicates if any of the Response options should be pre-selected when this Node loads for the User.
node_default

Node Data Branch

Indicates the name of the Database Table as a point of reference for this Node's data interactions, and all of its descendants.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
node_data_branch

Node Data Field

Indicates the Database Table and Field where the User's Response will actually be stored.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
node_data_store

Response Text Suggest

Indicates an optional setting to suggest a response or instruction within this Node's open-ended form field.
node_text_suggest

Response Character Limit

Indicates the maximum number of characters a User may enter in Response to this Node's prompt.
( default value: 0 )
node_char_limit

Node Likes

For some systems, this indicates how many Users responded to this Node with "a like".
( default value: 0 )
node_likes

Node Dislikes

For some systems, this indicates how many Users responded to this Node with "a dislike".
( default value: 0 )
node_dislikes

Node Options

Indicates the multiple of various prime numbers which mark specific other qualities of this Node.
Notes: For XML Nodes... %5 Include members with parent, without table wrap; %7 Min 1 Record; %11 Max 1 Record; | For Other Nodes... %2 Customize Layout; %13 'Required' Displayed On Separate Line; %29 Exit Page; %31 Show Word Count; %37 Wrap In Jumbotron Style; %41 Echo Response Edits To Div; %43 Toggle Child Nodes On Click; %47 Limit Word Count; %53 Dropdown Tagger; %59 Hide Progress Bar; %61 Responses In Columns; %67 Skinny Content Width; %71 Content Block Background; %73 Leave Existing Rows' Records; %79 After Response Selected, Hide Other Options; %83 Show After Pressing Info Button; %89 Wrap in Card Element; %97 Defer Loading of Node Contents
( default value: 1 )
node_opts
node_responses
(node_res_)

Node Responses
Each record represents one Response presented to the User when prompted by a specific Node.
Group: Trees
Type: Subset
6 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

node_responses Unique ID

node_res_id
Number, Indexed, Primary Key

Response Node ID

Indicates the unique Experience Node ID number which this Node Response belongs to.
node_res_node

Tree Nodes(11,11)-(0,N)

Response Sorting Order

Indicates the indexed order of this Node Response, relative to other Response options for this Experience Node.
( default value: 0 )
node_res_ord

Response Description

Describes this Node Response option clearly in English for the User.
node_res_eng

Response Stored Value

Indicates how a User selection of this Node Response option should be stored in the Database.
node_res_value

Show Child Node If Selected

Indicates whether or not child Nodes should be revealed to the User upon selecting this specific Node Response option.
( default value: 0 )
node_res_show_kids

Response Is Mutually Exclusive

Indicates whether or not this response option is mutually exclusive with all the other responses to this question (Node).
( default value: 0 )
node_res_mut_ex
conditions
(cond_)

Conditions
Each record represents one specific Condition used to filter Database submissions. These are important for determining which Nodes to include during a User's Experience, and which finished submissions to include in public queries.
Incoming: Condition Values(0,N)-(11,11), Condition Nodes(0,N)-(0,N)
2 Tables with Foreign Keys
Group: Trees
Type: Data
9 Fields Total
4 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

conditions Unique ID

cond_id
Number, Indexed, Primary Key

Condition Database ID

Indicates the unique Database ID number which this Condition can be applied to.
cond_database

Databases(11,11)-(0,N)

Condition Tag/Name

Indicates the short name, like a hashtag on social media, which is used both internally and publicly to easily identify this Condition/Filter.
cond_tag

Condition Description

Describes this Condition/Filter in English, as accurately and succinctly as possible, for both internal and public use.
cond_desc

Condition Operator

Indicates what type of testing to do as part of applying this Data Condition. This includes checking for User Responses within a specified range of values ( "{" ), outside a specified range of values ( "}" ), checking the number of records a Database Table has ( "EXISTS>" ), or "CUSTOM".
( default value: { )
cond_operator

Condition Operator Details

Indicates qualifying details to further specify this operator's requirements for this Condition. For "EXISTS>" Conditions, this stores the maximum number of Table records which can exist while passing this Condition as FALSE.
cond_oper_deet

Database Field ID

Indicates the unique Field ID number for the data being tested in this Database Condition.
cond_field

Database Fields(0,N)-(0,N)

Database Table ID

Indicates the unique Table ID number for the data being tested in this Database Condition.
cond_table

Database Tables(0,N)-(0,N)

Data Loop ID

Indicates the unique Data Loop ID number for the data being tested in this Database Condition.
cond_loop

Data Loops(0,N)-(0,N)

Condition Options

Indicates the multiple of various prime numbers which mark any other specific qualities of this Condition.
Notes: %2 For Public Use In Filter Defaults; %3 Is Linked With Article(s);
( default value: 1 )
cond_opts
conditions_vals
(cond_val_)

Condition Values
Each record represents one Value to be compared with a User's Response when testing a specific Condition. This is important for comparing among a range of values.
Group: Trees
Type: Subset
2 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

conditions_vals Unique ID

cond_val_id
Number, Indexed, Primary Key

Value Condition ID

Indicates the unique Condition ID number which this Value option relates to.
cond_val_cond_id

Conditions(11,11)-(0,N)

Value Description

Indicates the actual User Response Value, which would be stored in the Database, associated with the Condition related to this record.
cond_val_value
conditions_nodes
(cond_node_)

Condition Nodes
Each record represents a linkage between one Node or one Data Loop within this Experience.
Incoming: Condition Nodes(0,N)-(0,N)
1 Table with Foreign Key
Group: Trees
Type: Linking
3 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

conditions_nodes Unique ID

cond_node_id
Number, Indexed, Primary Key

Condition ID

Indicates the unique Condition ID number of the Condition being applied to an Experience Node or a Data Loop.
cond_node_cond_id

Conditions(0,N)-(0,N)

Experience Node ID

Indicates the unique Experience Node ID number which this Condition has been applied to.
cond_node_node_id

Condition Nodes(0,N)-(0,N)

Data Loop ID

Indicates the unique Data Loop ID number which this Condition has been applied to.
cond_node_loop_id

Data Loops(0,N)-(0,N)
conditions_articles
(article_)

Condition Articles
Each record represents one Article which provides more information regarding Experience submissions which meet a Condition's requirements. This is important for provident automated, educational information to Users and the public.
Incoming: Condition Articles(0,N)-(0,N)
1 Table with Foreign Key
Group: Trees
Type: Subset
3 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

conditions_articles Unique ID

article_id
Number, Indexed, Primary Key

Article Condition ID

Indicates the unique Condition ID number of the Condition being associated with complementary information.
article_cond_id

Condition Articles(0,N)-(0,N)

Article URL

Indicates the URL of an Article which provides more information for Users with completed submissions meeting this related Condition/Filter.
article_url

Article Title

Indicates an appropriate title for an Article which provides more information for Users with completed submissions meeting this related Condition/Filter.
article_title
data_loop
(data_loop_)

Data Loops
Each record represents one Data Loop's full details. This is important for automating data relations for related Experiences.
Incoming: Conditions(0,N)-(0,N), Condition Nodes(0,N)-(0,N)
2 Tables with Foreign Keys
Group: Trees
Type: Data
12 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

data_loop Unique ID

data_loop_id
Number, Indexed, Primary Key

Data Loop Experience ID

Indicates the unique Experience ID number of the User Experience for which this Data Loop is required.
data_loop_tree

Trees(11,11)-(0,N)

Root Node ID

Indicates the unique Node ID number of this Data Loop's Root Node. All of the descendants of this Data Loop's Root will be repeated until the User wants to continue past it, or Loop's constraints are exceeded.
data_loop_root

Tree Nodes(11,11)-(0,N)

Plural Name For Items In Loop

Indicates the way to describe multiple Items in this Data Loop (eg. "Witnesses"). This is also the primary name for this Data Loop, so its value should be unique within each Database.
data_loop_plural

Singular Name For Items In Loop

Indicates the way to describe multiple Items in this Data Loop (eg. "Witness").
data_loop_singular

Data Loop Core Table

Indicates the name of the Database Table whose records will either be looped through, or created during this Data Loop.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
data_loop_table

Data Sort Field

Indicates the full Database Field name ( "{TableAbbr}{FldName}" ) to be used for sorting Table records as Data Loop Items.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_loop_sort_fld

Loop Completed Field

Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) to be checked signifying that the User has successfully completed the Data Loop for a given Item.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_loop_done_fld

Maximum Loop Items

Indicates how many Data Loop Items/Records the User is allowed add.
( default value: 0 )
data_loop_max_limit

Warn Item Maximum

Indicates how many Data Loop Items/Records will trigger a warning to the User that they are approaching the maximum limit.
( default value: 0 )
data_loop_warn_limit

Minimum Loop Items

Indicates how many Data Loop Items/Records the User must add.
( default value: 0 )
data_loop_min_limit

Is Step-Loop

Indicates whether or not this Data Loop operates as a Step-Loop, meaning Table records are added to the Database before this Data Loops steps the User through adding information for one preexisting Loop Item at a time. Otherwise, Data Loops behave so that Users to can add Loop Items until the specified limits are reached.
Values: 0 ; 1 ( default value: 0 )
data_loop_is_step

Data Auto-Generates

If this is not a Step-Loop, this indicates whether or not this Data Loop should automatically create new Database Table records (and child data structures) when a User clicks to add another Loop Item.
Values: 0 ; 1 ( default value: 1 )
data_loop_auto_gen
data_subsets
(data_sub_)

Data Subset Tables
Each record represents one linkage between one Database Table and a Subset Table which pulls in one related secondary record of detailed information. This is important for automating data relations for related Experiences.
Group: Trees
Type: Linking
6 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

data_subsets Unique ID

data_sub_id
Number, Indexed, Primary Key

Data Link Experience ID

Indicates the unique Experience ID number of the User Experience for which this Data Subset is required.
data_sub_tree

Trees(11,11)-(0,N)

Primary Table

Indicates the name of the primary Database Table in this Data Subset relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
data_sub_tbl

Primary Table Linking Field

When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the primary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the secondary Table.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_sub_tbl_lnk

Secondary Table

Indicates the name of the secondary Database Table in this Data Subset relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
data_sub_sub_tbl

Secondary Table Linking Field

When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the primary Table.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_sub_sub_lnk

Secondary Records Auto-Generated

Indicates whether or not this Data Subset should enforce the auto-creation of secondary Table records, whenever the related primary Table record exists.
Values: 0 ; 1 ( default value: 0 )
data_sub_auto_gen
data_helpers
(data_help_)

Data Helper Tables
Each record represents one linkage between one Database Table and a Helper Table which can store multiple checkbox responses or relate many secondary records to the primary. This is important for automating data relations for related Experiences.
Group: Trees
Type: Linking
5 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

data_helpers Unique ID

data_help_id
Number, Indexed, Primary Key

Data Link Experience ID

Indicates the unique Experience ID number of the User Experience for which this Data Helper is required.
data_help_tree

Trees(11,11)-(0,N)

Primary Table

Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
data_help_parent_table

Secondary Table

Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data.
Notes: Yes, this should be changed to a Foreign Key to the Table ID.
data_help_table

Secondary Foreign Key

Indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the secondary Table.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_help_key_field

Secondary Storage Field

When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field which stores multiple checkbox Response Values from the User and associates them with the primary Database Table.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
data_help_value_field
data_links
(data_link_)

Data Linkage Tables
Each record represents one linkage between one Database Table and a second Table which don't require a hierarchical relationship. This is important for automating data relations for related Experiences.
Group: Trees
Type: Linking
2 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

data_links Unique ID

data_link_id
Number, Indexed, Primary Key

Data Link Experience ID

Indicates the unique Experience ID number of the User Experience for which this Data Link is required.
data_link_tree

Trees(11,11)-(0,N)

Database Linkage Table

Indicates the unique Table ID number for the many-to-many linkage table to be included when a User's Data is loaded for this User Experience.
data_link_table

Database Tables(11,11)-(0,N)
images
(img_)

Gallery Images
Each record represents one item in the Media Galleries managed by Survloop.
Group: Trees
Type: Data
13 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

images Unique ID

img_id
Number, Indexed, Primary Key

Database ID

Indicates the unique Database ID number which owns this media item.
img_database_id

Databases(1,1)-(0,N)

User ID

Indicates the unique User ID number who uploaded or owns this media item.
img_user_id

Users(0,1)-(0,N)

Original Filename

Indicates the original filename, as it was uploaded.
img_file_orig

Stored Filename

Indicates the filename as it was actually stored here on the server.
img_file_loc

Full File Location

Indicates the full path where this media file is actually stored here on the server (relative to the system app's root).
img_full_filename

Media Title

Indicates the title of this uploaded media, or a concise description of it. This is important as a label used internally throughout the system.
img_title

Media Credit (Legal)

Indicates any attribution required or appropriate to be shared alongside this media item.
img_credit

Media Credit URL (Legal)

Indicates an optional URL link for any attribution required or appropriate to be shared alongside this media item.
img_credit_url

Node ID

Indicates the unique Node ID number used to upload this media item.
img_node_id

Tree Nodes(0,1)-(0,N)

Media Type

Indicates which allowed type of media upload this record tracks.
Values: jpg ; png ; gif
img_type

Media File Size

Indicates this media file's size in bytes here on the server.
img_file_size

Media Width

Indicates the default width of this media item.
img_width

Media Height

Indicates the default height of this media item.
img_height
uploads
(up_)

Uploads
Each record stores details about a file uploaded by a user, especially with any survey process.
Group: Trees
Type: Data
13 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

uploads Unique ID

up_id
Number, Indexed, Primary Key

Tree ID

Indicates the unique Tree ID number which this Upload belongs to. This is important to track the journey to this upload.
up_tree_id

Trees(1,1)-(0,N)

Tree Node ID

Indicates the unique Node ID number (within the Tree) from which this file was uploaded. This is potentially important for tracking exactly when the user uploaded this.
up_node_id

Core Record ID

Indicates the unique ID number associated the Core Record for whichever Tree this Upload belongs to. This is important to track the journey to this upload.
up_core_id

Upload Type

Indicates the type of upload as defined by the unique Definition ID number from the Definitions set 'Value Ranges' and subset 'Upload Types'.
up_type

Definitions(1,1)-(0,N)

Privacy Setting

Indicates whether or not the user wants this uploaded file to be publicly published or for administrators' eyes only.
up_privacy

Title of File

Indicates a brief name by which this file can be referenced in English.
up_title

Description of File

Provides a longer description for this uploaded file, if needed.
up_desc

Filename as Uploaded

Indicates the original filename for this upload when it got to the server.
up_upload_file

Filename as Stored

Indicates the new filename for this upload as it is stored on the server.
up_stored_file

Video Link URL

Indicates the URL of a video being "uploaded". So far, only YouTube is supported for automatically embeded previews.
up_video_link

Video Duration

Indicates the duration of the video in seconds.
up_video_duration

Link Field ID

Indicates the unique Database Field ID which this uploaded file is related to.
up_link_fld_id

Database Fields(0,1)-(0,N)

Link Record ID

Indicates the unique Record ID from the Database Table owning the associated Field, if applicable.
up_link_rec_id
search_rec_dump
(sch_rec_dmp_)

Searchable Record Dump
Each record stores a cache of all data from a specific complex record, including English translations for Definition IDs, etc. This is very useful for running text searches across all Experience submissions.
Group: Trees
Type: Validation
4 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

search_rec_dump Unique ID

sch_rec_dmp_id
Number, Indexed, Primary Key

Tree ID

Indicates the unique Tree ID number which this record belongs to.
sch_rec_dmp_tree_id

Trees(0,1)-(0,1)

Submission Record ID

Indicates the unique record ID number whose data is being cached here.
sch_rec_dmp_rec_id

Full Record Dump

Stores a cache of all raw data from a specific submission record, including English translations for Definition IDs, etc.
sch_rec_dmp_dump

Permissions

Indicates this data cache's permissions.
sch_rec_dmp_perms
design_tweaks
(twk_)

Design Tweaks
Represents one modification to the existing database and user experience designs in Survloop. Information stored here is important for tracking history of changes and success of A/B testing in the user experience. This is the Core Data Table of Survloop's naked installation.
Incoming: User Session(0,N)-(11,11)
1 Table with Foreign Key
Group: Session Records
Type: Data
7 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

design_tweaks Unique ID

twk_id
Number, Indexed, Primary Key

User ID

Indicates the unique User ID number of the User owning the data stored in this record for this Experience.
twk_user_id

Users(11,11)-(11,11)

Experience Node Progress

Indicates the unique Node ID number of the last Experience Node loaded during this User's Experience.
twk_submission_progress

Tree Nodes(11,11)-(11,11)

A/B Testing Version

Stores a complex string reflecting all A/B Testing variations in effect at the time of this User's Experience of this Node.
twk_version_ab

IP Address

^
Encrypted IP address of the current user.
twk_ip_addy

Tree Version Number

^
Stores the current version number of this User Experience, important for tracking bugs.
twk_tree_version

Unique String For Record

^
This unique string is for cases when including the record ID number is not appropriate.
twk_unique_str

Using Mobile Device

^
Indicates whether or not the current user is interacting via a mobile deviced.
twk_is_mobile
sess
(sess_)

User Session
Each record represents one User's Session while going through an Experience. This is important for saving a User's progress if they have to complete an Experience over the course of multiple browser sessions.
Incoming: Session Loops(0,N)-(11,11), Node Saves(0,N)-(11,11), Page Saves(0,N)-(11,11)
3 Tables with Foreign Keys
Group: Session Records
Type: Data
10 Fields Total
6 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

sess Unique ID

sess_id
Number, Indexed, Primary Key

Session User ID

Indicates the unique User ID for the Database User logged in and using this Session record.
sess_user_id

Users(11,11)-(0,N)

Session Experience ID

Indicates the unique Experience ID number of the User Experience which this Session record is tracking.
sess_tree

Trees(11,11)-(0,N)

User's Core Table Record ID

Indicates the unique Table ID number for the User's record in this Experience's Core Data Table. This is important for saving update's in the User's progress.
sess_core_id

Design Tweaks(11,11)-(0,N)

Is Active

Indicates whether or not this session is currently active, or editable. This allows us to avoid permanently deleting these records valuable for audits.
Values: 0 ; 1
sess_is_active

Session Current Node ID

Indicates the unique Node ID number of the last Experience Node this User loaded.
sess_curr_node

Tree Nodes(11,11)-(0,N)

Just Left Loop Root ID

When appropriate, this Session data stores the unique Root Node ID for a Data Loop which has just been exited by the User.
sess_loop_root_just_left

Tree Nodes(0,11)-(0,N)

Jump From Node ID

When appropriate, this Session data stores the unique Node ID for an Experience Node the User has just used custom navigation to jump away from.
sess_after_jump_to

Tree Nodes(0,11)-(0,N)

Using Mobile Device

Indicates whether or not the User is currently using a mobile device (1 if yes).
Values: 0 ; 1
sess_is_mobile

Session Browser

Indicates the web browser used during this Session.
sess_browser

IP Address

Encrypted IP address of the current user.
sess_ip
sess_loops
(sess_loop_)

Session Loops
Each record represents one User's current Data Loop Item which they are editing, as related to their current Session. This is important for saving a User's progress if they have to complete an Experience over the course of multiple browser sessions.
Group: Session Records
Type: Subset
3 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

sess_loops Unique ID

sess_loop_id
Number, Indexed, Primary Key

User Session ID

Indicates the unique Session ID for the User Session whose Data Loop progress is stored in this record.
sess_loop_sess_id

User Session(11,11)-(0,N)

Data Loop Name

Indicates the name of the Data Loop with User progress to store in this record.
Notes: Yes, this should be changed to a Foreign Key to the Data Loop ID.
sess_loop_name

Data Loop Item ID

Indicates the unique ID number of the Data Loop Item which the User was last working on.
sess_loop_item_id
node_saves_page
(page_save_)

Page Saves
Each record represents one timestamp of a User's submission of a specific Page Node during a specific Session. This is important for quickly checking or reviewing the progress of Users through an Experience.
Group: Session Records
Type: Data
3 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

node_saves_page Unique ID

page_save_id
Number, Indexed, Primary Key

User Session ID

Indicates the unique Session ID for the User Session whose Page Node progress is stored in this record.
page_save_session

User Session(11,11)-(0,N)

Page Node ID

Indicates the unique Node ID for the Experience Page Node this Session has loaded.
page_save_node

Tree Nodes(11,11)-(0,N)

Data Loop Item ID

Indicates the unique ID number of the Data Loop Item which the User was working on for this Page Node.
page_save_loop_item_id
node_saves
(node_save_)

Node Saves
Each record represents one User's Response to a specific Node during a specific Session. Among other quality control, this is important for comparing the efficacy of various A/B testing in the user experience.
Group: Session Records
Type: Data
6 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

node_saves Unique ID

node_save_id
Number, Indexed, Primary Key

User Session ID

Indicates the unique Session ID for the User Session whose Node response is stored in this record.
node_save_session

User Session(11,11)-(0,N)

Data Loop Item ID

Indicates the unique ID number of the Data Loop Item which the User was working on for this Node Response.
node_save_loop_item_id

Save Node ID

Indicates the unique Node ID for the Experience Node whose User response is stored in this record.
node_save_node

Tree Nodes(11,11)-(0,N)

A/B Testing Version

Stores a complex string reflecting all A/B Testing variations in effect at the time of this User's Experience of this Node.
node_save_version_ab

Storage Data Field

Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) where this Node has decided to store the User's Response.
Notes: Yes, this should be changed to a Foreign Key to the Field ID.
node_save_tbl_fld

User Response

Indicates the stored User's Response Value, or a dump of related information.
node_save_new_val
sess_emojis
(sess_emo_)

Session Emojis
Each record stores one tag of one submission, by one user. This enables users to interact and provide feedback on completed Experience submissions, and to prevent users from tagging more than once.
Group: Session Records
Type: Linking
4 Fields Total
3 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

sess_emojis Unique ID

sess_emo_id
Number, Indexed, Primary Key

User ID

Indicates the unique User ID number whose interactions are being logged here. Important for ensuring that one User cannot tag someone's completed submission more than once.
sess_emo_user_id

Users(0,1)-(0,N)

Tree ID

Indicates the unique Tree ID number that the record being tagged belongs to. Vital for knowing which table the record ID refers to.
sess_emo_tree_id

Trees(1,1)-(0,N)

Submission Record ID

Indicates the unique record ID number which is being tagged with this row.
sess_emo_rec_id

Tag Definition ID

Indicates the unique Definition ID number belonging to the specific tag or interaction being logged in this row.
sess_emo_def_id

Definitions(1,1)-(0,N)
sess_site
(site_sess_)

Site Session
Each record represents one User's Site Session while browsing through the whole website, not just surveys. This is important for identifying any problems in the website use flow.
Incoming: Session Page Loads(0,N)-(1,1), Campaign Clicks(0,N)-(1,1), Discussion Comments(0,N)-(1,1), User Subscription Paid Redirects(0,N)-(1,1)
4 Tables with Foreign Keys
Group: Session Records
Type: Data
5 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

sess_site Unique ID

site_sess_id
Number, Indexed, Primary Key

IP Address

^
Encrypted IP address of the current user.
site_sess_ip_addy

Session User ID

Indicates the unique User ID for the Database User logged in and using this Site Session record.
site_sess_user_id

Using Mobile Device

Indicates whether or not the User is currently using a mobile device (1 if yes).
Values: 0 ; 1
site_sess_is_mobile

Session Browser

Indicates the web browser used during this Session.
site_sess_browser

Zoom Preference

Indicates the User's current preference of visual zoom of the page.
site_sess_zoom_pref
campaigns
(camp_)

Campaigns
Each record stores information about a specific promotional campaign.
Group: Session Records
Type: Data
1 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

campaigns Unique ID

camp_id
Number, Indexed, Primary Key

Campaign Name

Indicates the best name for this marketing campaign, used to track referrals.
camp_name
campaign_clicks
(camp_clk_)

Campaign Clicks
Each record represents a click through to the site from a promotional campaign.
Group: Session Records
Type: Data
3 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

campaign_clicks Unique ID

camp_clk_id
Number, Indexed, Primary Key

Campaign ID

Indicates the unique Campaign ID number of this referral.
camp_clk_campaign_id

Site Session(1,1)-(0,N)

Click From URL

Indicates the URL where this site visitor came from to arrive at the site.
camp_clk_from_url

Click To URL

Indicates the URL on this site which this visitor is loading.
camp_clk_to_url
sess_page
(sess_page_)

Session Page Loads
Each record represents one page load, or server-side redirect, as related to their current Session. This is important for saving a User's path through the entire website.
Group: Session Records
Type: Data
2 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

sess_page Unique ID

sess_page_id
Number, Indexed, Primary Key

Session ID

Indicates the unique Session ID for the User Session who loaded this page.
sess_page_sess_id

Site Session(1,1)-(0,N)

URL Loaded

Indicates the URL which is currently being loaded, or redirected through on the server-side.
sess_page_url
threads
(thrd_)

Discussion Threads
Each row stores a bit of information about one Discussion Thread, which acts as the primary anchor for a branching tree of Discussion Comments.
Incoming: Discussion Comments(0,N)-(1,1)
1 Table with Foreign Key
Group: Community
Type: Data
3 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

threads Unique ID

thrd_id
Number, Indexed, Primary Key

Discussion Name/Title

Indicates the name or title for this Discussion Thread or comment spot.
thrd_name

Total Discussion Comments

Indicates the total number of Discussion Comments added to this Discussion. Important for knowing which Discussions have the most activity overall.
thrd_discuss_total

Last Discussion Comment

Indicates the date and time of the last comment added to this Discussion. Important for knowing which Discussions have the most recent activity.
thrd_discuss_last
thread_comments
(thrd_cmt_)

Discussion Comments
Each row represents a Comment added somewhere within a Discussion Thread.
Incoming: Discussion Comments(0,N)-(0,1), Discussion Comments(0,N)-(0,1), Discussion Thread Followers(0,N)-(1,1), Discussion Comment Likes(0,N)-(1,1)
4 Tables with Foreign Keys
Group: Community
Type: Data
8 Fields Total
5 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

thread_comments Unique ID

thrd_cmt_id
Number, Indexed, Primary Key

Discussion Thread ID

Indicates the unique Discussion Thread ID to which this Comment belongs.
thrd_cmt_thread_id

Discussion Threads(1,1)-(0,N)

User ID

Indicates the unique User ID who published this Comment.
thrd_cmt_user_id

Users(1,1)-(0,N)

User Session ID

Indicates the unique User Session ID to which this Comment belongs.
thrd_cmt_sess_id

Site Session(1,1)-(0,N)

Reply To Comment ID

Indicates the other unique Comment ID to which this Comment replies.
( default value: 0 )
thrd_cmt_reply_to

Discussion Comments(0,1)-(0,N)

Reply Root Comment ID

Indicates the other unique Comment ID which is the Root Comment of this reply.
( default value: 0 )
thrd_cmt_reply_root

Discussion Comments(0,1)-(0,N)

Depth Within Thread

Indicates how many sub-threads deep this comment lies, for convenient lookup.
( default value: 0 )
thrd_cmt_depth

Total Likes

Indicates the total number of Likes this Comment has received.
( default value: 0 )
thrd_cmt_tot_likes

Total Dislikes

Indicates the total number of Dislikes this Comment has received.
( default value: 0 )
thrd_cmt_tot_dislikes
thread_likes
(thrd_lik_)

Discussion Comment Likes
Each row represents one User voting up or down one specific Comment.
Group: Community
Type: Subset
3 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

thread_likes Unique ID

thrd_lik_id
Number, Indexed, Primary Key

Discussion Thread Comment ID

Indicates the unique Discussion Thread Comment ID which this User wants to Like or Dislike.
thrd_lik_comment_id

Discussion Comments(1,1)-(0,N)

User ID

Indicates the unique User ID who wants to Like or Dislike this Comment.
thrd_lik_user_id

Users(1,1)-(0,N)

Like/Dislike

Indicates whether this User Likes or Dislikes this specific Comment.
( default value: 0 )
thrd_lik_like
thread_follows
(thrd_flw_)

Discussion Thread Followers
Each row represents one User who wishes to be alerted to updates of one Discussion Thread.
Group: Community
Type: Linking
3 Fields Total
2 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

thread_follows Unique ID

thrd_flw_id
Number, Indexed, Primary Key

Discussion Thread Comment ID

Indicates the unique Discussion Thread Comment ID which this User wants to follow.
thrd_flw_comment_id

Discussion Comments(1,1)-(0,N)

User ID

Indicates the unique User ID who wants to follow this Comment and any of its sub-threads.
thrd_flw_user_id

Users(1,1)-(0,N)

Type of Discussion Following

Indicates what level of following the User wants for this Comment Thread.
( default value: 1 )
thrd_flw_follow_type
users_activity
(user_act_)

User Activity
Each record represents one log entry of a User's Activity, important for tracking system usage.
Group: Logs
Type: Validation
3 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

users_activity Unique ID

user_act_id
Number, Indexed, Primary Key

User ID

Indicates the unique User ID related to the User whose actions are being logged in this record.
user_act_user

Users(11,11)-(0,N)

Current URL

Indicates the URL of the system page where the User is taking the logged action.
user_act_curr_page

Action Value

Indicates any other value or dump of values which may need to be logged alongside the URL for adequate documentation.
user_act_val
log_actions
(log_)

Log Actions
Each record represents one detailed Log entry of an Administrator's database design changes, important for keeping a history for undoing mistakes.
Group: Logs
Type: Validation
7 Fields Total
4 Outgoing Keys
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

log_actions Unique ID

log_id
Number, Indexed, Primary Key

User ID

Indicates the unique User ID related to the User whose actions are being logged in this record.
log_user

Users(11,11)-(0,N)

Log Database ID

Indicates the unique Database ID number which this Logged Action was taken on.
log_database

Databases(11,11)-(0,N)

Log Table ID

Indicates the unique Table ID number which this Logged Action was taken on.
log_table

Database Tables(11,11)-(0,N)

Log Field ID

Indicates the unique Field ID number which this Logged Action was taken on.
log_field

Database Fields(0,11)-(0,N)

Type Of Action

Indicates what type of Action on the Database Design is being Logged.
Values: New ; Edit
log_action

Old Name

Indicates the old name of this Database Table or Field, to maintain a history of such important changes.
log_old_name

New Name

Indicates the new name of this Database Table or Field, to maintain a history of such important changes.
log_new_name
zips
(zip_)

Zip Codes
Each record represents one United States zip code to map it to state and counties.
Group: Lookups
Type: Linking
7 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

zips Unique ID

zip_id
Number, Indexed, Primary Key

Zip Code

Indicates the zip code (postal code) being mapped in this record.
zip_zip

Latitude

Indicates the Zip Code's latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface.
zip_lat

Longitude

Indicates the Zip Code's longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface.
zip_long

City

Indicates the city where this Zip Code is located.
zip_city

State

Indicates the state where this Zip Code is located.
zip_state

County

Indicates the county where this Zip Code is located.
zip_county

Country

Indicates the country where this Zip Code is located.
zip_country
addy_geo
(ady_geo_)

Address Geolocate
Each record represents one Address (all in one line) to map it to its latitude and longitude coordinates. This is important to reducing the number of geocoding requests sent to third parties.
Group: Lookups
Type: Data
3 Fields Total
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

addy_geo Unique ID

ady_geo_id
Number, Indexed, Primary Key

Full Address

Indicates the full address, in one line, which is being linked with latitude and longitude coordinates.
ady_geo_address

Latitude

Indicates the Address's latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface.
ady_geo_lat

Longitude

Indicates the Address's longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface.
ady_geo_long
caches
(cach_)

Caches
Each record represents one cache of content, whether HTML, JS, or CSS.
Group: Optimization
Type: Data
7 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

caches Unique ID

cach_id
Number, Indexed, Primary Key

Cache Type

Indicates which type of cache record this is.
cach_type

Tree ID

Indicates the unique Tree ID number which generated this cache.
cach_tree_id

Trees(0,N)-(0,N)

Core Record ID

Indicates the unique Core Record ID number which generated this cache.
cach_rec_id

Cache Key String

Indicates the unique key string used to locate this cached content.
cach_key

Cache Content Value

Indicates the actual value of the cached content.
cach_value

Cache Content CSS

Indicates CSS needed for the cached content.
cach_css

Cache Content JS

Indicates JS needed for the cached content.
cach_js