Synapse
Tables (6)
answer
- answer_id — BIGINT
- review_question_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- evaluation_result — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
categories
- category_id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- color — VARCHAR(7) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review_card
- review_card_id — BIGINT
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- importance — INT — NOT NULL
- review_cycle — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- review_count — INT — NOT NULL
- success_rate — DOUBLE
- url — VARCHAR(500)
- task_type — VARCHAR(50) — NOT NULL
- task_field — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review_question
- review_question_id — BIGINT
- review_card_id — BIGINT — NOT NULL
- question_text — TEXT — NOT NULL
- success_count — INT — NOT NULL
- fail_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
user_activity
- activity_id — BIGINT
- user_id — BIGINT — NOT NULL
- activity_date — DATE — NOT NULL
- review_cards_completed — INT — NOT NULL
- questions_answered — INT — NOT NULL
- study_time_minutes — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_user_activity_date
users
- id — BIGINT
- clerk_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- first_name — VARCHAR(255)
- last_name — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL