B
B
Beginner2017-12-26 00:45:26
SQL
Beginner, 2017-12-26 00:45:26

How to create a database for a dictionary?

Dictionary for android application on sqlite.
Let's say we need to create a dictionary for 3 languages, does that mean we need to create 3 tables with 3 columns in each table? Or are there better options?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
R
Roman Mirilaczvili, 2017-12-26
@2ord

In a simple case, a translations table with the following fields:
src | dest | lang_id

M
Mikhail Makarov, 2017-12-26
@NightmareZz

One table. One column per key and one column per language.

S
Sergey Ya, 2017-12-26
@sejak1983

3 related tables, most likely you will need to save some more data for each specific language.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question