create table Dokladchik (Dokladchik_ID INTEGER PRIMARY KEY, FIO TEXT, Pol_Razd_Mat LOGIC, Reg_Vznos LOGIC, Uch_Zaved_ID1 INTEGER, FOREIGN KEY (Uch_Zaved_ID1) REFERENCES Uch_Zaved (Uch_Zaved_ID) ON DELETE NO ACTION);

create table Doklad (Doklad_ID INTEGER PRIMARY KEY, Sekciya_ID1 INTEGER, Nazvanie_Dokl TEXT, Predm_oblast TEXT, Forma_vyst TEXT, Ustniy LOGIC, Stendoviy LOGIC, FOREIGN KEY (Sekciya_ID1) REFERENCES Sekciya (Sekciya_ID) ON DELETE NO ACTION);

create table Vystuplenie (Vystuplenie_ID INTEGER PRIMARY KEY, Pred_oblast TEXT, Sekciya TEXT, Doklad_ID1 INTEGER, Dokladchik_ID1 INTEGER, FOREIGN KEY (Doklad_ID1) REFERENCES Doklad (Doklad_ID) ON DELETE NO ACTION, FOREIGN KEY (Dokladchik_ID1) REFERENCES Dokladchik (Dokladchik_ID) ON DELETE NO ACTION);

create table Uch_Zaved (Uch_Zaved_ID INTEGER PRIMARY KEY, Nazvanie TEXT, Gorod TEXT);

create table Konferenciya (Konferenciya_ID INTEGER PRIMARY KEY, Nazvanie_Konf TEXT, Mesto_Prov  TEXT, Date TEXT, Kolich_sekciy INTEGER);

create table Ustnyi_doklad (Ustn_ID INTEGER, Presentation LOGIC, Doklad_ID2 INTEGER, FOREIGN KEY (Doklad_ID2) REFERENCES Doklad (Doklad_ID) ON DELETE NO ACTION);

create table Sekciya (Sekciya_ID INTEGER NOT NULL PRIMARY KEY, Nazvanie_sekcii TEXT, Predsedatel TEXT, Tematika TEXT, Data_rab_sek TEXT, Kolich_dokladov TEXT, Konferenciya_ID1 INTEGER, FOREIGN KEY (Konferenciya_ID1) REFERENCES Konferenciya (Konferenciya_ID) ON DELETE NO ACTION);

create table Stendovyi_doklad(Stend_ID INTEGER, No_of_Stend INTEGER, Doklad_ID3 INTEGER, FOREIGN KEY (Doklad_ID3) REFERENCES Doklad (Doklad_ID) ON DELETE NO ACTION);

PRAGMA foreign_keys = ON;

.headers ON

sqlite> insert into Doklad (Doklad_ID, Sekciya_ID1, Nazvanie_Dokl, Predm_oblast, Forma_vyst, Ustniy, Stendoviy)
   ...> values (1, 6, "OTO", "fizika", "ochnaja", "true", "false");
Error: FOREIGN KEY constraint failed
sqlite> insert into Vystuplenie (Vystuplenie_ID, Doklad_ID1, Dokladchik_ID1, Pred_oblast, Sekciya)
   ...> values (10, 10, 13, "informatika", "IT budushego");
Error: FOREIGN KEY constraint failed