LikeLionLMS

Tables (7)

Answer

  • PK (answer_id) — int — Primary key — NOT NULL
  • FK (question_id) — int — Foreign key → Question.PK — NOT NULL
  • FK (user_ID) — int — Foreign key → User.PK — NOT NULL
  • Field (title) — varchar(100)
  • Field (name) — varchar(20)
  • Field (content) — varchar(1000)
  • Field (created_at) — timestamp()
  • Field (last_edited_at) — timestamp()
  • Field (views) — tinyint
  • Field (private) — boolean

Assginment (Assignment)

  • PK (assign_title) — varchar(50) — Primary key — NOT NULL
  • FK (code) — varchar(50) — Foreign key → Course.PK — NOT NULL
  • FK (user_ID) — int — Foreign key → Course.FK — NOT NULL
  • Field (created_at) — timestamp()
  • Field (end_date) — timestamp()
  • Field (name) — varchar(50)
  • Field (content) — varchar(1000)
  • Field (sub_status) — boolean
  • Field (score_status) — boolean
  • Field (score_date) — timestamp()
  • Field (feedback) — varchar(500)

Assignment_submit (Assignment_Submit)

  • PK (name) — varchar(100) — Primary key — NOT NULL
  • FK (assign_title) — varchar(50) — Foreign key → Assginment.PK — NOT NULL
  • FK (user_ID) — int — Foreign key → Assginment.FK — NOT NULL
  • Field (content) — varchar(1000)
  • Field (submit_date) — timestamp()
  • Field (last_submit) — timestamp()
  • Field2 (file_name) — varchar(100)
  • Field (file_type) — varchar(20)

Course

  • PK (code) — varchar(50) — Primary key — NOT NULL
  • FK (user_ID) — int — Foreign key → User.PK — NOT NULL
  • Field (name) — varchar(255)
  • Field (propessor) — varchar(20)
  • Field (date) — timestamp()
  • Field (num_stu) — tinyint
  • Field (attendance) — int

Lecture (Lectures)

  • PK (week) — int — Primary key — NOT NULL
  • FK (course_code) — varchar(20) — Foreign key → Course.PK — NOT NULL
  • Field (title) — varcahr(50)
  • Field (created_at) — timestamp()
  • Field (date) — timestamp()
  • Field (progress) — int
  • Field (attendance) — boolean

Question

  • PK (question_id) — int — Primary key — NOT NULL
  • FK (user_ID) — int — Foreign key → User.PK — NOT NULL
  • FK (code) — varchar(50) — Foreign key → Course.PK — NOT NULL
  • Field (title) — varchar(100)
  • Field3 (name) — varchar(20)
  • Field (content) — varchar(1000)
  • Field (created_at) — timestamp()
  • Field2 (last_edited_at) — timestamp()
  • Field (views) — tinyint
  • Field (private) — boolean

User

  • PK (ID) — int — Primary key — NOT NULL
  • Field (univ_num) — int
  • Field2 (name) — varchar(255)
  • Field2 (grade) — int
  • Field3 (major) — varchar(255)
  • Field (loginID) — varchar(30)
  • Field (password) — varchar(30)
  • Field (authority) — varchar(255)
  • Field3 (email) — varchar(50)