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

ai_embedding_jeju

    ai_embedding_seoul

      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_jeju

        course_seoul

          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

          course_textblock_jeju

            course_textblock_seoul

              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)

              enrollment_jeju

                enrollment_seoul

                  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)

                  review_jeju

                    review_seoul

                      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