Fiterview
Tables (4)
feedbacks
- report_id — INTEGER — Foreign key → reports.id — NOT NULL
- score — INT — NOT NULL
- strength — TEXT
- improvement — TEXT
questions
- id — SERIAL — Primary key — NOT NULL
- question — TEXT
- sample_answer — TEXT
- user_answer — TEXT
- report_id — INTEGER — Foreign key → reports.id — NOT NULL
- recording — TEXT
reports
- id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ
- status — VARCHAR(20) — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- reflection — TEXT
users
- id — SERIAL — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL