capstone

Tables (7)

chat_messages

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → chat_sessions.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • turn_number — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_sessions

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • study_topic_id — BIGINT — Foreign key → study_topics.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

evaluation_questions

  • id — BIGSERIAL
  • evaluation_id — BIGINT — Foreign key → evaluations.id — NOT NULL
  • question_order — INT — NOT NULL
  • question — TEXT — NOT NULL
  • model_answer — TEXT — NOT NULL
  • user_answer — TEXT
  • next_review_date — DATE
  • review_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

evaluations

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • study_topic_id — BIGINT — Foreign key → study_topics.id — NOT NULL
  • chat_session_id — BIGINT — Foreign key → chat_sessions.id
  • score — INT
  • feedback — TEXT
  • created_at — TIMESTAMP — NOT NULL

notifications

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • message — TEXT — NOT NULL
  • link — VARCHAR(255)
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

study_topics

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • outline — JSONB
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • uuid — UUID — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL