Eoeo

Tables (11)

Course (course)

  • Id (id) — Long — Primary key — NOT NULL
  • Name (name) — String
  • IsDeleted (is_deleted) — Boolean
  • CreatedAt (created_at) — DateTime
  • UpdatedAt (updated_at) — DateTime

Untitled

    article

    • Id (id) — Long — Primary key — NOT NULL
    • BoardCategoryId (board_category_id) — Long — Foreign key → board_category.Id — NOT NULL
    • Title (title) — String
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime
    • Field

    board_category (boardCategory)

    • Id (id) — Long — Primary key — NOT NULL
    • Field
    • SchoolId (school_id) — Long — Foreign key → school_code.Id — NOT NULL
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • DeletedAt (deleted_at) — DateTime

    class_taken (classTaken)

    • Id (id) — Long — Primary key — NOT NULL
    • Field
    • UserId (user_id) — Long — Foreign key → user.id — NOT NULL
    • ClassId (class_id) — Long — Foreign key → lecture.Id — NOT NULL
    • IsSubstitute (is_substitute) — Boolean
    • OriginalClassId (original_class_id) — Long — Foreign key → lecture.Id — NOT NULL
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime

    lecture (class)

    • Id (id) — Long — Primary key — NOT NULL
    • CourseId (course_id) — Long — Foreign key → Course.Id — NOT NULL
    • LectureId (lecture_id) — String
    • Name (name) — String
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime

    major

    • Key (id) — Long — Primary key — NOT NULL
    • Name (Field) — String
    • SchoolId (school_id) — Long — Foreign key → school_code.Id — NOT NULL
    • CoreCourseId (core_course_id) — Long — Foreign key → Course.Id — NOT NULL
    • RequiredCourseId (required_course_id) — Long — Foreign key → Course.Id — NOT NULL
    • SelectiveCourseId (selective_course_id) — Long — Foreign key → Course.Id — NOT NULL
    • CoreCredit (core_credit) — Long
    • RequiredCredit (required_credit) — Long
    • SelectiveCredit (selective_credit) — Long
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime

    prerequisite

    • Id (id) — Long — Primary key — NOT NULL
    • ClassId (class_id) — Long — Foreign key → lecture.Id — NOT NULL
    • PrerequisiteId (prerequisite_id) — Long — Foreign key → lecture.Id — NOT NULL
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime

    school_code (schoolCode)

    • Id (id) — Long — Primary key — NOT NULL
    • Name (name) — String
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (created_at) — DateTime
    • DeletedAt (deleted_at) — DateTime

    substitute_lecture (substituteClass)

    • Id (id) — Long — Primary key — NOT NULL
    • OriginalLectureId (original_lecture_id) — Long — Foreign key → lecture.Id — NOT NULL
    • SubstituteLectureId (substitute_lecture_id) — Long — Foreign key → lecture.Id — NOT NULL
    • IsDeleted (is_deleted) — Boolean
    • CreatedAt (Field) — DateTime
    • UpdatedAt (Field2) — DateTime

    user

    • id — Long — Primary key — NOT NULL
    • Username (username) — String
    • Password (password) — String
    • Name (name) — String
    • MajorId (major_id) — Long — Foreign key → major.Key — NOT NULL
    • SecondMajorId (second_major_id) — Long — Foreign key → major.Key — NOT NULL
    • IsDeleted (is_deleted) — boolean
    • CreatedAt (created_at) — DateTime
    • UpdatedAt (updated_at) — DateTime