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)