
by Wiki World Order under the Creative Commons Attribution-ShareAlike License, 2021.
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
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
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
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
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 IDid
Number, Indexed, Primary Key |
Usernamename
Text |
Email Addressemail
Text |