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)