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