fork download 
  1. CREATE TABLE Vehicle_Type
  2. (
  3. TypeID char (3) not null PRIMARY KEY,
  4. [Description] varchar (100) not null
  5. );
  6. INSERT into Vehicle_Type VALUES
  7. ('TT','Tracter Trailor'),
  8. ('ST','Semi-Tracter Trailor');
  9.  
  10. CREATE TABLE Maintenance_Code
  11. (
  12. Maintenance_Type_ID varchar (5) not null PRIMARY KEY,
  13. [Description] varchar (100) not null
  14. );
  15. INSERT INTO Maintenance_Code VALUES
  16. ('MOC4','Oil Change'),
  17. ('MHR9','Hose Replacement'),
  18. ('MTR5','Tire Ratation'),
  19. ('MAB8','Alignment & Balancing Tires');
  20.  
  21. CREATE TABLE Maintenance_Descriptions
  22. (
  23. Maintenance_Type_ID varchar (5) not null PRIMARY KEY
  24. FOREIGN KEY REFERENCES Maintenance_Code(Maintenance_Type_ID),
  25. Level_Code varchar (10) not null,
  26. Average_Hours_Required varchar (5) not null,
  27. Days_Between_Recommended_Maintenance int not null,
  28. Maximum_Days_Between_Maintenance int not null
  29. );
  30.  
  31. INSERT INTO Maintenance_Descriptions VALUES
  32. ('MOC4','LvL1','1.25','90','120'),
  33. ('MHR9','LvL2','3.5','180','200'),
  34. ('MTR5','LvL3','2.0','180','210'),
  35. ('MAB8','LvL4','5.30','180','210');
  36.  
  37.  
  38. CREATE TABLE Vehicles
  39. (
  40. VIN_Number varchar (17) not null PRIMARY KEY,
  41. TypeID char (3) not null 
  42. FOREIGN KEY REFERENCES Vehicle_Type(TypeID),
  43. Class_Code varchar (6) not null,
  44. Put_Into_Service_Date date not null,
  45. Gross_Weight varchar (7) not null,
  46. Milleage varchar (9) not null,
  47. Purchase_Price varchar (9) not null,
  48. Accumulated_Depreciation varchar (9) not null,
  49. Taken_Out_Of_Service date,
  50. Capacity varchar (20) not null
  51. );
  52.  
  53. INSERT INTO Vehicles VALUES
  54. ('2HNYD28478H501589','ST','CL7GVW','2000-04-02','58,510','30,004','$65,350','$23,314','2010-04-30','45,000 53X13.6X102'),
  55. ('2T1FF28PX1C539447','TT','CL5GVW','2001-05-29','47,850','89,347','$57,950','$17,964','2012-06-01','97,000 55X15.25X102');
  56.  
  57.  
  58. CREATE TABLE Vehicle_Maintenance
  59. (
  60. VIN_Number varchar (17) not null,
  61. PartsID varchar (10) not null,
  62. Maintenance_Type_ID varchar (5) not null,
  63. Put_Into_Service_Date date not null,
  64. Last_Maintenance_Date date not null,
  65. Next_Scheduled_Maintenance date not null,
  66. Under_Warranty_Flag char (1) not null
  67. );
  68.  
  69. INSERT INTO Vehicle_Maintenance VALUES
  70. ('2HNYD28478H501589','QH1300AS','MOC4','2011-06-15','2012-01-31','2013-01-31','Y'),
  71. ('2T1FF28PX1C539447','1590002','MHR9','2011-02-22','2012-03-25','2012-12-01','Y');
  72.  
  73. CREATE TABLE Tire_Maintenance
  74. (
  75. Barcode varchar (17) not null PRIMARY KEY,
  76. Maintenance_Type_ID varchar (5) not null 
  77. FOREIGN KEY REFERENCES Maintenance_Code(Maintenance_Type_ID),
  78. TypeID char (3) not null 
  79. FOREIGN KEY REFERENCES Vehicle_Type(TypeID),
  80. Manufacture_ID varchar (15) not null,
  81. Put_Into_Service_Date date not null,
  82. Rotated_Scheduled_Date date not null,
  83. Last_Rotated_Date date not null,
  84. Disposal_Date date not null
  85. );
  86.  
  87. INSERT INTO Tire_Maintenance VALUES
  88. ('79008 40228','MTR5','ST','GoodYr2002','2006-10-06','2012-08-10','2012-05-12','2012-05-17'),
  89. ('96018 13820','MAB8','TT','Yukon2010','2009-07-02','2012-05-31','2012-02-28','2012-02-10');
  90.  
  91.  
  92. CREATE TABLE Maintenance_Work_Order
  93. (
  94. Work_Order_ID varchar (5) not null PRIMARY KEY,
  95. VIN_Number varchar (17) not null 
  96. FOREIGN KEY REFERENCES Vehicles (VIN_Number),
  97. Maintenance_Type_ID varchar (5) not null 
  98. FOREIGN KEY REFERENCES Maintenance_Code(Maintenance_Type_ID),
  99. Assignment_To varchar (9) not null,
  100. Date_Started date not null,
  101. Date_Completed date not null,
  102. [Hours] varchar (7) not null
  103. );
  104.  
  105.  
  106. INSERT INTO Maintenance_Work_Order VALUES
  107. ('H1000','2HNYD28478H501589','MOC4','Blue Team','2012-05-09','2012-05-11','3.0'),
  108. ('H1001','2T1FF28PX1C539447','MHR9','Black Team','2012-04-28','2012-04-30','2.75');
  109.  
  110.  
  111. CREATE TABLE Vendors
  112. (
  113. Vendor_ID varchar (7) not null PRIMARY KEY,
  114. Name varchar (10) not null,
  115. Order_Address varchar (5) not null,
  116. Order_Street varchar (10) not null,
  117. Order_City varchar (15) not null,
  118. Order_State char (2) not null,
  119. Order_Zip int not null,
  120. Order_Contact char (15) not null,
  121. Order_Phone_Number varchar (15) not null,
  122. Order_Fax_Number varchar (15), 
  123. Billing_Address varchar (5) not null,
  124. Billing_Street varchar (10) not null,
  125. Billing_City varchar (15) not null,
  126. Billing_State char (2) not null,
  127. Billing_Zip int not null,
  128. Billing_Contact char (15) not null,
  129. Billing_Phone_Number varchar (15) not null,
  130. Billing_Fax_Number varchar (15) not null
  131. );
  132.  
  133. INSERT INTO Vendors VALUES
  134. ('SAP8','Sears','5178','Pearl Road','Cleveland','OH','44129','Mary Kay','(216)351-3279','(216)351-7500','6600','Bessemer Avenue','Cleveland','OH','44127','John Smith','(216)341-7140','(216)429-3523'),
  135. ('NA00','NAPA','3141','Superior Avenue','Cleveland','OH','44114','Andrew Linder','(216)771-1515','(216)398-9800','6600','Bessemer Avenue','Cleveland','OH','44127','John Smith','(216)341-7140','(216)429-3523');
  136.  
Runtime error #stdin #stdout 0s 3008KB
comments (?)
stdin 
SELECT * from Vehicle_Type
SELECT * from Maintenance_Code
SELECT * from Maintenance_Descriptions
SELECT * from Vehicles
SELECT * from Vehicle_Maintenance;
SELECT * from Tire_Maintenance
SELECT * from Maintenance_Work_Order
SELECT * from Vendors
stdout 
Standard output is empty
https://ideone.com/7OW3I
language:
SQLite (sqlite 3.27.2)
created:
14 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!