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)