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, 2020.

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
Text

System Description

Describes the system which is powered by Survloop.
inst_desc
Text-Long

System URL

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

Logo Image URL

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

User ID

Indicates the unique User ID number of the User owning the data stored in this record for this Experience.
inst_user_id
Number
Users(0,1)-(0,N)

IP Address

Encrypted IP address of the current user.
inst_ip_addy
Text

Experience Node Progress

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

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
Text

Tree Version Number

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

Unique String For Record

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

Using Mobile Device

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

GitHub URL

Indicates the installations GitHub package, if one exists.
inst_on_github
Text

Icon URL

Indicates the URL of the installation's icon.
inst_icon_url
Text
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
Number
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
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
Number

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
Number

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
Number

Survey Count

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

Survey Nodes Count

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

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
Number

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
Number

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
Number

Pages Count

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

Page Nodes Count

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

User Count

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

Survey 1: Completed

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

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
Number

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
Number

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
Number

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
Number

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
Number

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
Number
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
Text

Description of Database Concept

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

Are You A Coder?

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

Email Address for Updates

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

Using Mobile Device

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

User ID

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

Unique String For Record

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

Tree Version Number

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

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
Text

IP Address

^
Encrypted IP address of the current user.
req_ip_addy
Text
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
Number
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
Number
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