Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • G GoSurvey
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 3
    • Issues 3
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Container Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Metrics
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Mathias Haimerl
  • GoSurvey
  • Wiki
  • Database

Database · Changes

Page history
Create Database authored May 24, 2021 by Mathias Haimerl's avatar Mathias Haimerl
Hide whitespace changes
Inline Side-by-side
Database.md 0 → 100644
View page @ 3f748636
___GoSurvey___ makes extensive use of the [JSON(B)](https://www.postgresql.org/docs/current/datatype-json.html) field types to allow for arbitary surveys to be stored centrally while proividing the possibility for cross-correlations of differently structured surveys.
```plantuml
@startuml
entity Surveys {
SurveyID : uuid
[Timestamps]
--
Name : character varying(255)
}
entity Consents {
ConsentID : uuid
[Timestamps]
SurveyID : uuid <<FK>>
--
data : json NOT NULL,
consent : boolean NOT NULL,
privacy : boolean NOT NULL
}
entity Answers {
AnswerID : uuid
[Timestamps]
SurveyID : uuid <<FK>>
--
data : json NOT NULL,
consent : boolean NOT NULL,
privacy : boolean NOT NULL
}
entity Users {
UserID : uuid
[Timestamps]
--
role : smallint
}
entity Formulas {
FormulaID : uuid
[Timestamps]
--
name : character varying(255) <<Index>>
}
entity Suites {
SuiteID : uuid
[Timestamps]
SurveyID : uuid <<FK>>
--
name : character varying(255) <<Index>>
mappings : json
}
Surveys ||..|{ Consents
Surveys ||..|{ Answers
Surveys ||..|{ Suites
Suites ||..|{ Formulas
Users }|..|{ Surveys
@enduml
```
\ No newline at end of file
Clone repository
  • Architecture
  • Database
  • R Integration
  • Use cases
  • User & Role Management
  • Home