flashcard

Tables (7)

Card (cards)

  • card_id — int — Primary key — NOT NULL
  • deck_id — int — Foreign key → Deck.deck_id — NOT NULL
  • expression_id — int — Foreign key → Expression.expression_id — NOT NULL
  • front_text — var(30)
  • back_text — var(50)
  • example_text — var(50)

CardAudio (card_audios)

  • card_audio_id — nt — Primary key — NOT NULL
  • card_id — int — Foreign key → Card.card_id — NOT NULL
  • file_path
  • voice_model
  • input_text
  • input_hash
  • engine_version

CardSchedule (card_schedules)

  • card_schedule_id — int — Primary key — NOT NULL
  • card_id — int — Foreign key → Card.card_id — NOT NULL
  • due_at — date
  • interval_days
  • repetitions
  • lapses
  • difficulty
  • stability

Deck (decks)

  • deck_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL
  • name — var(20)
  • description — text

Expression (expressions)

  • expression_id — int — Primary key — NOT NULL
  • original_text — var(30)
  • nomalized_text — var(30)
  • context — var(50)
  • readingr (reading) — var(50)
  • analysis_source — var(10)

ReviewLog (review_logs)

  • review_log_id — int — Primary key — NOT NULL
  • card_id — int — Foreign key → Card.card_id — NOT NULL
  • rating
  • reviewed_at
  • previous_interval
  • next_interval
  • response_time — int

User (users)

  • user_id — int — Primary key — NOT NULL
  • email — var(20)
  • password — var(15)
  • nickname — var(10)