fork(1) download
copy 
  1. -- your code goes herecreate TABLE Колеса(
  2. Id integer PRIMARY KEY AUTOINCREMENT,
  3. Name varchar(50),
  4. Price decimal 
  5. );
  6. create TABLE Противопоказания(
  7. Id integer PRIMARY KEY AUTOINCREMENT, 
  8. name varchar(50)
  9. );
  10. create TABLE Болезни(
  11. Id integer PRIMARY KEY AUTOINCREMENT, 
  12. name varchar(50),
  13. duration Time
  14. );
  15. CREATE TABLE Симтомы(
  16. Id integer PRIMARY KEY AUTOINCREMENT, 
  17. name varchar(50)
  18. );
  19. CREATE TABLE Последствия(
  20. Id integer PRIMARY KEY AUTOINCREMENT, 
  21. name varchar(50)
  22. );
  23.  
  24. CREATE TABLE ПротивопоказанияДляКолес(
  25. DrugID integer,
  26. СontraindicationsID Integer,
  27. FOREIGN KEY(DrugID) REFERENCES Колеса(Id),
  28. FOREIGN KEY(СontraindicationsID) REFERENCES Противопоказания(Id)  
  29. );
  30. CREATE TABLE ПоследствияБолезней(
  31. illnessID integer,
  32. effectsID Integer,
  33. FOREIGN KEY(illnessID) REFERENCES Болезни(Id),
  34. FOREIGN KEY(effectsID) REFERENCES Последствия(Id)  
  35. );
  36. CREATE TABLE СимптомыБолезний(
  37. illnessID integer,
  38. symptomsID Integer,
  39. FOREIGN KEY(illnessID) REFERENCES Болезни(Id),
  40. FOREIGN KEY(symptomsID) REFERENCES Симтомы(Id)   
  41. );
  42. CREATE TABLE КолесаБолезни(
  43. drugID integer,
  44. illnessID Integer,
  45. FOREIGN KEY(drugID) REFERENCES Колеса(Id),
  46. FOREIGN KEY(illnessID) REFERENCES Болезни(Id)   
  47. );
Success #stdin #stdout #stderr 0s 4400KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 2: near "Id": syntax error
https://ideone.com/CALmkx
language:
SQLite (sqlite 3.27.2)
created:
3 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!