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