test
Tables (17)
Dates
- date_id — timestamp — Primary key — NOT NULL
call_logs
- call_log_id — INT — Primary key — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
country
- country_id — INT — Primary key — NOT NULL
- national_flag_url — VARCHAR(512)
date_sentences
- sentence_id — INT — Primary key — NOT NULL
- language_level_id — CHAR(2) — Foreign key → language_levels.language_level_id — NOT NULL
- language_id — CHAR(2) — Foreign key → languages.language_id — NOT NULL
- date_id — timestamp — Foreign key → Dates.date_id — NOT NULL
- sentence — VARCHAR(255)
language_levels
- language_level_id — CHAR(2) — Primary key — NOT NULL
languages
- language_id — CHAR(2) — Primary key — NOT NULL
tags
- tag_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
user_bookmark_sentences
- user_bookmark_sentence_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- user_date_sentence_id — INT — Foreign key → user_date_sentences.user_date_sentence_id — NOT NULL
- bookmark_yn — TINYINT(1)
user_date_sentences
- user_date_sentence_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- date_sentence_id — INT — Foreign key → date_sentences.sentence_id — NOT NULL
- like_count — INT
- bookmark_count — INT
- url — VARCHAR(512)
user_expressions
- expression_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- call_log_id — INT
- original_text — VARCHAR(255) — NOT NULL
- translated_text — VARCHAR(255)
- created_at — DATETIME — NOT NULL
user_language_levels
- user_language_level_id — INT — Primary key — NOT NULL
- language_level_id — CHAR(2) — Foreign key → language_levels.language_level_id — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- language_id — CHAR(2) — Foreign key → languages.language_id — NOT NULL
user_like_sentences
- user_like_sentence_id — INT — Primary key — NOT NULL
- id — INT — Foreign key → users.user_id — NOT NULL
- user_date_sentence_id — INT — Foreign key → user_date_sentences.user_date_sentence_id — NOT NULL
- like_yn — TINYINT(1)
user_notes
- user_note_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- date_id — timestamp — NOT NULL
- native_language_id — CHAR(2) — NOT NULL
- interest_language_id — CHAR(2) — NOT NULL
- native_note — VARCHAR(255)
- interest_note — VARCHAR(255)
- created_at — TIMESTAMP
user_profiles
- user_id — INT — Foreign key → users.user_id — NOT NULL
- country_id — INT — NOT NULL
- native_language_id — CHAR(2) — NOT NULL
- interest_language_id — CHAR(2) — NOT NULL
- gender — ENUM('M', 'F')
- profile_image_url — VARCHAR(512)
- nickname — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_tags
- user_tag_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- tag_id — INT — Foreign key → tags.tag_id — NOT NULL
users
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- google_id — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
voice_records
- record_id — BIGINT — Primary key — NOT NULL
- call_log_id — INT — Foreign key → call_logs.call_log_id — NOT NULL
- audio_url — VARCHAR(255) — NOT NULL
- stt_text — TEXT
- created_at — TIMESTAMP — NOT NULL