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

SurvLoop Installs: Database Design Specs

Installations
(Inst)

SurvLoop Installations

This represents each website or system which is currently powered by SurvLoop.
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

Installations Unique ID

InstID
Number, Indexed, Primary Key

System Name

Indicates the plain name of the system which is powered by SurvLoop.
InstName
Text

System Description

Describes the system which is powered by SurvLoop.
InstDesc
Text-Long

System URL

Indicates the URL of the system which is powered by SurvLoop.
InstURL
Text

Logo Image URL

Indicates the URL of this SurvLoop Installation's public location on the internet.
InstLogoUrl
Text

User ID

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

IP Address

Encrypted IP address of the current user.
InstIPaddy
Text

Experience Node Progress

Indicates the unique Node ID number of the last Experience Node loaded during this User's Experience.
InstSubmissionProgress
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.
InstVersionAB
Text

Tree Version Number

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

Unique String For Record

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

Using Mobile Device

Indicates whether or not the current user is interacting via a mobile deviced.
InstIsMobile
Text
InstallStats
(InstStat)

Install Stats

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

InstallStats Unique ID

InstStatID
Number, Indexed, Primary Key

Installation ID

Indicates the unique Installation ID number of the SurvLoop Installation associated with the statistics in this record.
InstStatInstallID
Number
SurvLoop Installations(1,1)-(0,N)

Log Date

Indicates the date when these statistics were logged, important for seeing trends over time.
InstStatDate
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.
InstStatDbTables
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.
InstStatDbFields
Number

Survey Count

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

Survey Nodes Count

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

Survey Nodes Multiple Choice Count

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

Survey Nodes Open-Ended Count

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

Survey Nodes Numeric Count

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

Pages Count

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

Page Nodes Count

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

User Count

Indicates the total number of full Users in the SurvLoop Installation.
InstStatUsers
Number

Survey 1: Completed

Indicated the total number of completed responses for the Installation's Primary Survey.
InstStatSurvey1Complete
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.
InstStatCodeLinesControllers
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.
InstStatCodeLinesViews
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.
InstStatBytesControllers
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.
InstStatBytesDatabase
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.
InstStatBytesViews
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.
InstStatBytesUploads
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.
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

ReqID
Number, Indexed, Primary Key

Title of Database Concept

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

Description of Database Concept

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

Are You A Coder?

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

Email Address for Updates

Indicates the email address of the user, if they want updates on the progress of SurvLoop.
ReqEmail
Text

Using Mobile Device

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

User ID

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

Unique String For Record

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

Tree Version Number

^
Stores the current version number of this User Experience, important for tracking bugs.
ReqTreeVersion
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.
ReqVersionAB
Text

IP Address

^
Encrypted IP address of the current user.
ReqIPaddy
Text
RequestSkills
(ReqSkl)

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

RequestSkills Unique ID

ReqSklID
Number, Indexed, Primary Key

Request ID

Indicates the unique Open Data Request ID number associated with the skill stored in this record.
ReqSklRequestID
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)
ReqSklSkill
Number
users
()

Users

This represents the Laravel Users table, but will not actually be implemented by SurvLoop as part of the database installation.
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