1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
CREATE TABLE articles (
a_alphagram text,
a_artid int PRIMARY KEY,
a_title text,
a_title_flat text,
a_title_flat_r text,
a_title_r text,
a_trans text,
a_trans_flat text,
a_trans_flat_r text
);
CREATE TABLE defs (
d_def text,
d_defid int PRIMARY KEY,
d_lexid int REFERENCES lexemes(l_lexid),
d_num int
);
CREATE TABLE langs (
lg_lang varchar(32) PRIMARY KEY,
lg_num int,
lg_num_min int
);
CREATE TABLE lexemes (
l_artid int REFERENCES articles(a_artid),
l_genre text,
l_is_flexion int,
l_is_gentile int,
l_is_locution int,
l_lang text REFERENCES langs(lg_lang),
l_lexid int PRIMARY KEY,
l_num int,
l_rand int,
l_sigle text,
l_type text
);
CREATE TABLE prons (
p_lexid int REFERENCES lexemes(l_lexid),
p_num int,
p_pron text,
p_pron_flat text,
p_pron_flat_r text,
p_pronid int
);
CREATE TABLE redirects (
r_target text,
r_title varchar(255) PRIMARY KEY
);
CREATE TABLE transc (
tr_artid int REFERENCES articles(a_artid),
tr_transc text,
tr_transc_flat text,
tr_transc_flat_r text
); |
Partager