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