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