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
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