open_lang

Tables (20)

Copy Of Copy Of Untitled2 (audio_words_ko)

  • Key (audio_id) — bigint(10) — Primary key — NOT NULL
  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime

Copy Of Untitled (sentences_ja)

  • Key (sentence_id) — BIGINT(10) — Primary key — NOT NULL
  • Field (word_id) — BINARY(16)
  • Field (sentence) — varchar(255) — NOT NULL
  • Field (source) — VARCHAR(255) — NOT NULL

Copy Of Untitled2 (audio_words_ja)

  • Key (audio_id) — bigint(10) — Primary key — NOT NULL
  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime

Copy Of Untitled3 (audio_sentences_ja)

  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Key (sentence_id) — BIGINT(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (audio_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime — NOT NULL

Copy Of Untitled4 (audio_sentences_ko)

  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Key (sentence_id) — BIGINT(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (audio_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime — NOT NULL

Copy Of Untitled5 (u1234124221koja)

  • Key (id) — int — Primary key — NOT NULL
  • Field (word1) — varchar(50) — NOT NULL
  • Field (word1_spe) — bigint(10)
  • Field (word2) — varchar(50) — NOT NULL
  • Field (word2_spe) — bigint(20)

Untitled (u1212324331enko)

  • Key (id) — int — Primary key — NOT NULL
  • Field (word1) — varchar(50) — NOT NULL
  • Field (word1_spe) — bigint(10)
  • Field (word2) — varchar(50) — NOT NULL
  • Field (word2_spe) — bigint(20)

Untitled (studyhistory)

  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Key (wordbook_id) — BIGINT(10)) — Foreign key → Untitled.Key — NOT NULL
  • Field (last_learned) — datetime — NOT NULL

Untitled (user_role)

  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Key (role_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (role)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (version) — bigint(20)
  • Field (authority) — varchar(255) — NOT NULL

Untitled (country)

  • Key (countrycode) — char(3) — Primary key — NOT NULL
  • Field (countryname) — varchar(100) — NOT NULL
  • Field (code) — char(2)

Untitled (wordbooks)

  • Key (wordbook_id) — BIGINT(10)) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (lang) — varchar(5) — NOT NULL
  • Field (opened) — big(1) — NOT NULL
  • Field (description) — varchar(255)

Untitled (sentences_ko)

  • Key (sentence_id) — BIGINT(10) — Primary key — NOT NULL
  • Field (word_id) — BINARY(16)
  • Field (sentence) — varchar(255) — NOT NULL
  • Field (source) — VARCHAR(255) — NOT NULL

Untitled (word_ko)

  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (word) — varchar(50) — NOT NULL

Untitled (word_ja)

  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (word) — varchar(50) — NOT NULL

Untitled (audio_sentences_en)

  • Key (audio_id) — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • Key (sentence_id) — BIGINT(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime — NOT NULL

Untitled (audio_words_en)

  • Key (audio_id) — bigint(10) — Primary key — NOT NULL
  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (filename) — varchar(50) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_updated) — datetime

Untitled (sentences_en)

  • Key (sentence_id) — BIGINT(10) — Primary key — NOT NULL
  • Key (word_id) — BINARY(16) — Foreign key → Untitled.Key — NOT NULL
  • Field (sentence_en) — varchar(255) — NOT NULL
  • Field (source) — VARCHAR(255) — NOT NULL

Untitled (word_en)

  • Key (word_id) — BINARY(16) — Primary key — NOT NULL
  • Field (word_en) — varchar(50) — NOT NULL
  • Field (word_type) — tinyint — NOT NULL

User (user)

  • user_id — bigint(20) — Primary key — NOT NULL
  • Key (countrycode) — char(3) — Foreign key → Untitled.Key — NOT NULL
  • Field2 (avatar_id) — bigint(20) — NOT NULL
  • username — varchar(15) — NOT NULL
  • Field3 (date_created) — datetime — NOT NULL
  • Field (date_withdraw) — datetime
  • Field (password) — varchar(255) — NOT NULL
  • Field (enabled) — BIT(1) — NOT NULL
  • Field (registermethod) — VARCHAR(10) — NOT NULL
  • Field (email_address) — varchar(255) — NOT NULL
  • Field (last_learned) — bigint(10)