lms
Tables (29)
User (Untitled)
- student_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(255)
- email (Field2) — varchar(255)
ai_embedding
- embedding_id — bigserial
- campus_id — smallint — NOT NULL
- item_type — text — NOT NULL
- item_id — bigint — NOT NULL
- chunk_no — int
- model — text — NOT NULL
- dim — int — NOT NULL
- vector — vector — NOT NULL
- created_at — timestamptz
campus
- campus_id — smallserial
- code — text — NOT NULL
- name — text — NOT NULL
course
- course_id — bigserial
- template_id — bigint — NOT NULL
- campus_id — smallint — NOT NULL
- operator_id — uuid
- term — text
- start_date — date
- end_date — date
- created_at — timestamptz
course_enrollments (Untitled2)
- enrollment_id (Key2) — int — Primary key — NOT NULL
- student_id (Key) — int — Foreign key → User.student_id — NOT NULL
- course_id (Key3) — int — Foreign key → courses.course_id — NOT NULL
- operator_id (Key22) — int — Foreign key → courses.operator_id — NOT NULL
- enrollment_date (Field) — timestamp
course_instructor
- course_id — bigint — Primary key — NOT NULL
- instructor_id — uuid — Primary key — NOT NULL
course_instructors (Untitled4)
- course_instructor_id (Key) — int — Primary key — NOT NULL
- course_id (Key2) — int — Foreign key → courses.course_id — NOT NULL
- instructor_id (Key3) — int — Foreign key → instructors.instructor_id — NOT NULL
course_template
- template_id — bigserial
- course_code — text — NOT NULL
- title — text — NOT NULL
course_textblock
- textblock_id — bigserial
- campus_id — smallint — NOT NULL
- course_id — bigint — NOT NULL
- kind — text — NOT NULL
- lang — text
- body — text — NOT NULL
- updated_at — timestamptz
courses (Untitled3)
- course_id (Key) — int — Primary key — NOT NULL
- operator_id (Key2) — int — Foreign key → operators.operator_id — NOT NULL
- title (Field) — varchar(50)
- start_date (Field2) — date
- end_date (Field3) — date
enrollment
- enrollment_id — bigserial
- campus_id — smallint — NOT NULL
- course_id — bigint — NOT NULL
- student_id — uuid — NOT NULL
- enrollment_date — timestamptz
- UNIQUE(course_id, — student_id)
instructor
- person_id — uuid
- title — text
- bio — text
instructors (Untitled5)
- instructor_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(255)
- email (Field2) — varchar(255)
operator
- person_id — uuid
- dept — text
operators (Untitled7)
- operator_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(50)
- email (Field2) — varchar(50)
person
- person_id — uuid
- name — text — NOT NULL
- email — citext
- phone — text
- created_at — timestamptz
review
- review_id — bigserial
- campus_id — smallint — NOT NULL
- course_id — bigint — NOT NULL
- student_id — uuid — NOT NULL
- rating — smallint
- title — text
- body — text
- created_at — timestamptz
- UNIQUE(course_id, — student_id)
reviews (Untitled6)
- review_id (Key) — int — Primary key — NOT NULL
- student_id (Key2) — int — Foreign key → User.student_id — NOT NULL
- course_id (Key3) — int — Foreign key → courses.course_id — NOT NULL
- operator_id (Key22) — int — Foreign key → courses.operator_id — NOT NULL
- rating (Field) — int
- comment (Field2) — text
- created_at (Field3) — timestamp
student
- person_id — uuid
- student_no — text
- entered_at — date