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