CREATE TABLE IF NOT EXISTS glav_table_tehnika (
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 data_prijom REAL,
 data_vydan REAL,
 id_vid_rabot INTEGER, 
 id_sotrudnik INTEGER,
 id_group_tehniki INTEGER,
 id_firmi_tehniki INTEGER,
 id_model_tehniki INTEGER,
 price INTEGER,
 id_client INTEGER,
 shtrih TEXT,
 nagrada REAL,
 nagrada_oplachena INTEGER,
 nom_telefon TEXT);
--===== Справочники ==========
CREATE TABLE IF NOT EXISTS group( 
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 name TEXT);

CREATE TABLE IF NOT EXISTS firma( 
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 name TEXT);

CREATE TABLE IF NOT EXISTS model( 
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 name TEXT);

CREATE TABLE IF NOT EXISTS vid_rabot( 
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 name TEXT);

-- и т.д.