LMS

Tables (6)

Untitled (Course)

  • Field (course_id) — int — Primary key
  • Field (instructor_id) — int — Foreign key → Untitled.Field
  • Field (operator_id) — int — Foreign key → Untitled.Field
  • Field (review_id) — int — Foreign key → Untitled.Field
  • Field (title) — text

Untitled (Instructor)

  • Field (instructor_id) — int — Primary key
  • Field2 (name) — text

Untitled (Student)

  • Field (student_id) — int — Primary key
  • Field (operator_id) — int — Foreign key → Untitled.Field
  • Field2 (name) — text
  • Field3 (email) — text

Untitled (Operator)

  • Field (operator_id) — int — Primary key
  • Field2 (name) — text
  • Field3 (email) — text

Untitled (Review)

  • Field (review_id) — int — Primary key
  • Field (student_id) — int — Foreign key → Untitled.Field
  • Field2 (rating) — int
  • Field3 (comment) — text

Untitled (Description)

  • Field (description_id) — int — Primary key
  • Field (course_id) — int — Foreign key → Untitled.Field
  • Field (review_id) — int — Foreign key → Untitled.Field
  • Field (text) — text