CREATE TABLE countries
(id SERIAL,
 name VARCHAR( 255 ),
 PRIMARY KEY (id)
);

CREATE TABLE countries_names
(id INT NOT NULL,
 id_lang INT NOT NULL,
 name VARCHAR( 255 ),
 PRIMARY KEY (id, id_lang),
 FOREIGN KEY (id) REFERENCES countries (id),
 FOREIGN KEY (id_lang) REFERENCES lang (id)

);

CREATE TABLE contact_info_fields
(id SERIAL,
 name VARCHAR( 255 ) NOT NULL,
 PRIMARY KEY (id)
);

CREATE TABLE contact_info_records
(id_user INT NOT NULL,
 id_ci_field INT NOT NULL,
 id_lang INT NOT NULL,
 value TEXT,
 PRIMARY KEY (id_user, id_ci_field, id_lang),
 FOREIGN KEY (id_user) REFERENCES users (id),
 FOREIGN KEY (id_ci_field) REFERENCES contact_info_fields (id),
 FOREIGN KEY (id_lang) REFERENCES lang (id)
);