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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

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

Survloop Installs: Database Design Specs

installations
(inst_)

Survloop Installations
This represents each website or system which is currently powered by Survloop.
Incoming: Install Stats(0,N)-(1,1)
1 Table with Foreign Key
Group: Survloop Installations
Type: Data
13 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

installations Unique ID

inst_id
Number, Indexed, Primary Key

System Name

Indicates the plain name of the system which is powered by Survloop.
inst_name

System Description

Describes the system which is powered by Survloop.
inst_desc

System URL

Indicates the URL of the system which is powered by Survloop.
inst_url

Logo Image URL

Indicates the URL of this Survloop Installation's public location on the internet.
inst_logo_url

User ID

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

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

IP Address

Encrypted IP address of the current user.
inst_ip_addy

Experience Node Progress

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

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

Tree Version Number

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

Unique String For Record

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

Using Mobile Device

Indicates whether or not the current user is interacting via a mobile deviced.
inst_is_mobile

GitHub URL

Indicates the installations GitHub package, if one exists.
inst_on_github

Icon URL

Indicates the URL of the installation's icon.
inst_icon_url
install_stats
(inst_stat_)

Install Stats
Each record preserves a snapshot of various statistics tracked for this Survloop installation.
Group: Survloop Installations
Type: Data
20 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

install_stats Unique ID

inst_stat_id
Number, Indexed, Primary Key

Installation ID

Indicates the unique Installation ID number of the Survloop Installation associated with the statistics in this record.
inst_stat_install_id

Survloop Installations(1,1)-(0,N)

Log Date

Indicates the date when these statistics were logged, important for seeing trends over time.
inst_stat_date

Database Count: Tables

Indicates the total number of database tables designed within this Installation's package. This count indicates a relative quantity of database structures and complexity.
inst_stat_db_tables

Database Count: Fields

Indicates the total number of database fields designed within this Installation's package. This count indicates a relative span of the database.
inst_stat_db_fields

Database Count: Links

Indicates the total number of database links designed within this Installation's package. This count indicates a relative interconnection of the database.
inst_stat_db_links

Survey Count

Indicates the total number of surveys designed within this Installation's package.
inst_stat_surveys

Survey Nodes Count

Indicates the total number of survey nodes designed within this Installation's package.
inst_stat_survey_nodes

Survey Nodes Multiple Choice Count

Indicates the total number of survey nodes designed with multiple choice responses within this Installation's package.
inst_stat_survey_nodes_mult

Survey Nodes Open-Ended Count

Indicates the total number of survey nodes designed with open-ended responses within this Installation's package.
inst_stat_survey_nodes_open

Survey Nodes Numeric Count

Indicates the total number of survey nodes designed with numeric/quantitative responses within this Installation's package.
inst_stat_survey_nodes_numb

Pages Count

Indicates the total number of pages designed within this Installation's package.
inst_stat_pages

Page Nodes Count

Indicates the total number of page nodes designed within this Installation's package.
inst_stat_page_nodes

User Count

Indicates the total number of full Users in the Survloop Installation.
inst_stat_users

Survey 1: Completed

Indicated the total number of completed responses for the Installation's Primary Survey.
inst_stat_survey1_complete

Code Base Line Count: Controllers

Indicates the total number of lines of codes in the Controllers folder for this Installation's package. This count indicates a relative quantity of largely PHP code, database queries and data processing.
inst_stat_lines_controllers

Code Base Line Count: Views

Indicates the total number of lines of codes in the Controllers folder for this Installation's package. This count indicates a relative quantity of largely HTML, Javascript, and CSS code, with targeted PHP variables echoed.
inst_stat_lines_views

Code Base Bytes: Controllers

Indicates the total bytes for the codes in the Controllers folder for this Installation's package. This count indicates a relative quantity of largely PHP code, database queries, input, and data processing.
inst_stat_bytes_controllers

Code Base Bytes: Database

Indicates the total bytes for the codes in the Database folder for this Installation's package. This count indicates a relative quantity of Laravel-specific PHP code, initializing database tables.
inst_stat_bytes_database

Code Base Bytes: Views

Indicates the total bytes for the codes in the Uploads folder for this Installation's package. This count indicates a relative quantity of largely HTML, Javascript, and CSS code, with targeted PHP variables echoed.
inst_stat_bytes_views

Code Base Bytes: Uploads

Indicates the total bytes for the codes in the Uploads folder for this Installation's package. This count indicates a relative quantity of various types of other uploaded files, largely images.
inst_stat_bytes_uploads
requests
(req_)

Open Data Requests
Each record represents a site visitor's request for some open data to be collected and shared with the world.
Incoming: Open Data Request Skills(0,N)-(1,1)
1 Table with Foreign Key
Group: Survloop Installations
Type: Data
11 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

requests Unique ID

req_id
Number, Indexed, Primary Key

Title of Database Concept

Indicates the title the user gives to this database they are conceptualizing.
req_title

Description of Database Concept

Indicates the user's fuller description of this concept database.
req_description

Are You A Coder?

Indicates whether or not the user requesting this open data has coding skills.
Values: 0 ; 1
req_is_coder

Email Address for Updates

Indicates the email address of the user, if they want updates on the progress of Survloop.
req_email

Using Mobile Device

^
Indicates whether or not the current user is interacting via a mobile deviced.
req_is_mobile

User ID

^
Indicates the unique User ID number of the User owning the data stored in this record for this Experience.
req_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.
req_submission_progress

Unique String For Record

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

Tree Version Number

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

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

IP Address

^
Encrypted IP address of the current user.
req_ip_addy
request_skills
(req_skl_)

Open Data Request Skills
Each record associates one programming skill with one user who requested the open data. This allows many skills to be linked to one request.
Group: Survloop Installations
Type: Subset
2 Fields Total
1 Outgoing Key
Field Name (in English), Description, Notes, Value Options
Field Name (in Database), Data Type, Key Info

request_skills Unique ID

req_skl_id
Number, Indexed, Primary Key

Request ID

Indicates the unique Open Data Request ID number associated with the skill stored in this record.
req_skl_request_id

Open Data Requests(1,1)-(0,N)

Coding Skill

Indicates some area of web development in which the user has some proficiency.
Values: Survloop Coder Skills (Definitions)
req_skl_skill
users
()

Users

This represents the Laravel Users table, but will not actually be implemented by Survloop as part of the database installation.
Incoming: Survloop Installations(0,N)-(0,1), Open Data Requests(11,11)-(11,11)
2 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