SurvLoop - All Our Data Are Belong [To Us]

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

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.

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

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

SurvLoop Installs: Database Design Specs

Installations(Inst)

SurvLoop Installations

This represents each website or system which is currently powered by SurvLoop.

Installations Unique ID

System Name

System Description

System URL

Logo Image URL

User ID

IP Address

Experience Node Progress

A/B Testing Version

Tree Version Number

Unique String For Record

Using Mobile Device

InstallStats(InstStat)

Install Stats

Each record preserves a snapshot of various statistics tracked for this SurvLoop installation.

InstallStats Unique ID

Installation ID

Log Date

Database Count: Tables

Database Count: Fields

Survey Count

Survey Nodes Count

Survey Nodes Multiple Choice Count

Survey Nodes Open-Ended Count

Survey Nodes Numeric Count

Pages Count

Page Nodes Count

User Count

Survey 1: Completed

Code Base Line Count: Controllers

Code Base Line Count: Views

Code Base Bytes: Controllers

Code Base Bytes: Database

Code Base Bytes: Views

Code Base 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.

Requests Unique ID

Title of Database Concept

Description of Database Concept

Are You A Coder?

Email Address for Updates

Using Mobile Device

User ID

Experience Node Progress

Unique String For Record

Tree Version Number

A/B Testing Version

IP Address

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.

RequestSkills Unique ID

Request ID

Coding Skill

users()

Users

This represents the Laravel Users table, but will not actually be implemented by SurvLoop as part of the database installation.

Users Unique ID

Username

Email Address

Installations
(Inst)

InstallStats
(InstStat)

Requests
(Req)

RequestSkills
(ReqSkl)

users
()