language_study_app

Tables (15)

FEEDBACK (CopyOfUntitled14)

  • feedback_id (PK) — Primary key — NOT NULL
  • user_id (PK2) — Foreign key → USER.user_id — NOT NULL
  • sentence_id (PK3) — Foreign key → SENTENCE.sentence_id — NOT NULL
  • script_id (FK) — Foreign key → SENTENCE.script_id — NOT NULL
  • pattern_id (PK22) — Foreign key → SENTENCE.pattern_id — NOT NULL
  • situation_id (PK32) — Foreign key → SENTENCE.situation_id — NOT NULL
  • new_topic_id (PK4) — Foreign key → SENTENCE.new_topic_id — NOT NULL
  • language_id (pk) — INT — Foreign key → SENTENCE.language_id — NOT NULL
  • file_meta_id (PK5) — Foreign key → SENTENCE.video_id — NOT NULL
  • feeback_type (Field)
  • comment (Field2)
  • created_at (Field3)

FILE_META (Untitled14)

  • file_meta_id (PK) — Primary key — NOT NULL
  • file_type (Field)
  • file_name (Field2)
  • local_path (Field3)
  • cloud_url (Field4)
  • storage_status (Field5)
  • created_at (Field6)
  • metadata (Field7)

LANGUAGE (언어정보)

  • language_id (pk) — INT — Primary key — NOT NULL
  • code (Field) — VARCHAR(10)
  • name (Field2) — VARCHAR(50)

NEWS_TOPIC (Untitled11)

  • new_topic_id (PK) — Primary key — NOT NULL
  • title (Field)
  • summary (Field2)
  • keywords (Field3)
  • file_path (Field4)
  • source_url (Field5)
  • collected_at (Field6)

PATTERN (패턴)

  • pattern_id (PK) — Primary key — NOT NULL
  • pattern_text (Field)
  • description (Field2)
  • level (Field3)

PATTERN_TRANSLATION (패턴 번역)

  • pattern_translation_id (PK) — Primary key — NOT NULL
  • pattern_id (FK) — Foreign key → PATTERN.pattern_id — NOT NULL
  • language_id (pk) — Foreign key → LANGUAGE.language_id — NOT NULL
  • example_sentence (Field)
  • explanation (Field2)
  • audio_id (Field3)

SCRIPT (Untitled4)

  • script_id (PK) — BIGINT — Primary key — NOT NULL
  • language_id (pk) — INT — Foreign key → LANGUAGE.language_id — NOT NULL
  • title (Field) — VARCHAR(200)
  • type (Field2) — ENUM('movie','news')
  • file_path (Field3) — TEXT
  • cloud_url (Field4) — TEXT
  • summary (Field5) — TEXT
  • token_count (Field6) — INT

SENTENCE (원문 스크립트)

  • sentence_id (PK) — BIGINT — Primary key — NOT NULL
  • script_id (FK) — Foreign key → SCRIPT.script_id — NOT NULL
  • pattern_id (PK2) — Foreign key → PATTERN.pattern_id — NOT NULL
  • situation_id (PK3) — Foreign key → SITUATION.situation_id — NOT NULL
  • new_topic_id (PK4) — Foreign key → NEWS_TOPIC.new_topic_id — NOT NULL
  • language_id (pk) — INT — Foreign key → SCRIPT.language_id — NOT NULL
  • video_id (PK5) — FILE_META.file_meta_id — Foreign key → FILE_META.file_meta_id — NOT NULL
  • concept_tag (Field4)
  • created_at (Field5) — TIMESTAMP
  • pattern_type (Field) — ENUM('pattern','situation','news')
  • parent_id (Field2) — BIGINT

SENTENCE_TRANSLATION (Untitled6)

  • sentence_translation_id (PK) — Primary key — NOT NULL
  • sentence_id (FK2) — Foreign key → SENTENCE.sentence_id — NOT NULL
  • script_id (FK) — Foreign key → SENTENCE.script_id — NOT NULL
  • pattern_id (PK2) — Foreign key → SENTENCE.pattern_id — NOT NULL
  • situation_id (PK3) — Foreign key → SENTENCE.situation_id — NOT NULL
  • new_topic_id (PK4) — Foreign key → SENTENCE.new_topic_id — NOT NULL
  • language_id (pk) — INT — Foreign key → SENTENCE.language_id — NOT NULL
  • file_meta_id (PK5) — Foreign key → SENTENCE.video_id — NOT NULL

SITUATION (Untitled9)

  • situation_id (PK) — Primary key — NOT NULL
  • name (Field)
  • category (Field2)
  • description (Field3)
  • example_conversations (Field4)

SITUATION_TRANSLATION (Untitled10)

  • situation_translation_id (PK) — Primary key — NOT NULL
  • situation_id (FK) — Foreign key → SITUATION.situation_id — NOT NULL
  • language_id (pk) — Foreign key → LANGUAGE.language_id — NOT NULL
  • example_conversition (Field)
  • audio_id (Field2)

USER (사용자)

  • user_id (PK) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(100)
  • nickname (Field2) — VARCHAR(50)
  • level (Field3) — ENUM('beginner','intermediate','advanced')
  • created_at (Field4) — TIMESTAMP

USER_PROGRESS (학습 진행)

  • user_progress_id (PK) — BIGINT — Primary key — NOT NULL
  • user_id (FK) — Foreign key → USER.user_id — NOT NULL
  • study_date (Field2) — DATE
  • is_studied (Field3) — BOOLEAN
  • level (Field) — ENUM('beginner','intermediate','advanced')
  • content_type (Field4) — ENUM('pattern','sentence','word')
  • content_id (Field5) — BIGINT

WORD (Untitled12)

  • word_id (PK) — Primary key — NOT NULL
  • sentence_id (PK2) — Foreign key → SENTENCE.sentence_id — NOT NULL
  • script_id (FK) — Foreign key → SENTENCE.script_id — NOT NULL
  • pattern_id (PK22) — Foreign key → SENTENCE.pattern_id — NOT NULL
  • situation_id (PK3) — Foreign key → SENTENCE.situation_id — NOT NULL
  • new_topic_id (PK4) — Foreign key → SENTENCE.new_topic_id — NOT NULL
  • language_id (pk) — INT — Foreign key → SENTENCE.language_id — NOT NULL
  • file_meta_id (PK5) — Foreign key → SENTENCE.video_id — NOT NULL
  • concept_key (Field)
  • created_at (Field2)

WORD_TRANSLATION (Untitled13)

  • word_translation_id (PK) — Primary key — NOT NULL
  • word_id (PK2) — Foreign key → WORD.word_id — NOT NULL
  • sentence_id (PK22) — Foreign key → WORD.sentence_id — NOT NULL
  • script_id (FK) — Foreign key → WORD.script_id — NOT NULL
  • language_id (pk) — Foreign key → LANGUAGE.language_id — NOT NULL
  • pattern_id (PK222) — Foreign key → WORD.pattern_id — NOT NULL
  • situation_id (PK3) — Foreign key → WORD.situation_id — NOT NULL
  • new_topic_id (PK4) — Foreign key → WORD.new_topic_id — NOT NULL
  • language_id (pk2) — INT — Foreign key → WORD.language_id — NOT NULL
  • file_meta_id (PK5) — Foreign key → WORD.file_meta_id — NOT NULL
  • word_text (Field)
  • meaning (Field2)
  • example_sentence (Field3)