MentaMorph Schema

Tables (7)

Assignments (assignment)

  • Community ID (community) — SERIAL — Foreign key → Communities.Community ID — NOT NULL
  • Scenario ID (scenario) — SERIAL — Foreign key → Scenarios.Scenario ID — NOT NULL
  • Assigned at (assigned_at) — TIMESTAMP

Communities (community)

  • Community ID (id) — SERIAL — Primary key — NOT NULL
  • Instructor (instructor) — SERIAL — Foreign key → Staffs.Staff ID — NOT NULL
  • Name (name) — TEXT
  • Join Code (code) — TEXT
  • Opening Date (opening_date) — DATE
  • Closing Date (closing_date) — DATE

Game History (history)

  • History ID (id) — SERIAL — Primary key — NOT NULL
  • User ID (user) — SERIAL — Foreign key → Users.User ID — NOT NULL
  • Scenario ID (scenario) — SERIAL — Foreign key → Scenarios.Scenario ID — NOT NULL
  • Classroom ID (classroom) — SERIAL — Foreign key → Communities.Community ID — NOT NULL
  • Started at (started_at) — TIMESTAMP
  • Completed at (completed_at) — TIMESTAMP
  • Rounds (rounds) — INTEGER
  • Actions (action) — ACTION[]

Joined (joined)

  • Classroom ID (classroom) — SERIAL — Foreign key → Communities.Community ID — NOT NULL
  • User ID (user) — TEXT — Foreign key → Users.User ID — NOT NULL
  • Joined at (joined_at) — TIMESTAMP

Scenarios (scenario)

  • Scenario ID (id) — SERIAL — Primary key — NOT NULL
  • Name (name) — TEXT
  • Theme (theme) — TEXT
  • Level (level) — INTEGER
  • Role (role) — TEXT
  • Rounds (rounds) — INTEGER
  • Scenario Intro (scenario_intro) — DIALOGUE[]
  • Round Intro (round_intro) — DIALOGUE[]
  • Round Outro (round_outro) — DIALOGUE[]
  • Inflow (inflow) — CATEGORY[]
  • Outflow (outflow) — CATEGORY[]
  • Assets (asset) — CATEGORY[]
  • Liabilities (liability) — CATEGORY[]
  • Events (event) — CATEGORY[]

Staffs (staff)

  • Staff ID (id) — SERIAL — Primary key — NOT NULL
  • Name (name) — TEXT — NOT NULL
  • Username (username) — TEXT
  • Hashed Password (hash) — TEXT
  • Salt of Password (salt) — TEXT
  • Is Admin (is_admin) — BOOLEAN

Users (user)

  • User ID (id) — TEXT — Primary key — NOT NULL
  • Name (name) — TEXT
  • Birthday (birthday) — TIMESTAMP
  • Gender (gender) — BOOLEAN
  • Email (email) — TEXT