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