fork download
copy 
  1. -- LMS Logs Table
  2. CREATE TABLE lms_logs (
  3.   log_id INT,
  4.   user_id INT,
  5.   timestamp STRING,
  6.   action STRING,
  7.   status STRING
  8. );
  9.  
  10. -- Users Table
  11. CREATE TABLE users (
  12.   user_id INT,
  13.   name STRING,
  14.   role STRING,
  15.   program STRING
  16. );
  17.  
  18. -- Exams Table
  19. CREATE TABLE exams (
  20.   exam_id INT,
  21.   student_id INT,
  22.   course_code STRING,
  23.   exam_date STRING,
  24.   status STRING
  25. );
Success #stdin #stdout 0.01s 5288KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/OulJlD
language:
SQLite (sqlite 3.27.2)
created:
7 days 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!