unitfit

Tables (8)

course_offerings (개설분반)

  • course_id (FK) — int — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → enrollments.user_id — NOT NULL
  • offering_id (Key2) — int — Foreign key → enrollments.offering_id — NOT NULL
  • offering_id (Field) — int
  • year (Field2) — year
  • semester (Field3) — tinyint
  • section (Field4) — var(10)
  • professor_name (Field5) — var(100)
  • capacity (Field6) — smallint
  • enrolled_count (Field7) — smallint
  • schedule_day (Field8) — var(20)
  • schedule_time (Field9) — var(50)
  • created_at (Field10) — timestamp

course_reviews (강의 평가)

  • course_id (FK) — int — Foreign key → course_offerings.course_id — NOT NULL
  • user_id (Key) — int — Foreign key → course_offerings.user_id — NOT NULL
  • offering_id (Key2) — int — Foreign key → course_offerings.offering_id — NOT NULL
  • review_id (Field) — int
  • rating (Field2) — int
  • difficulty (Field3) — tinyint
  • workload (Field4) — tinyint
  • comment (Field5) — text
  • helpful_count (Field6) — int
  • created_at (Field7) — var

courses (과목 마스터)

  • course_id (FK) — int — Foreign key → course_offerings.course_id — NOT NULL
  • user_id (Key) — int — Foreign key → course_offerings.user_id — NOT NULL
  • offering_id (Key2) — int — Foreign key → course_offerings.offering_id — NOT NULL
  • course_id (Field) — int
  • course_code (Field2) — var(20)
  • course_name (Field3) — var(200)
  • credits (Field4) — tinyint
  • course_type (Field5) — enum(...)
  • department (Field6) — var(100)
  • description (Field7) — text
  • created_at (Field8) — timestamp

enrollments (수강 신청)

  • user_id (Key) — int — Primary key — NOT NULL
  • offering_id (Key2) — int — Primary key — NOT NULL
  • enrollment_id (Field) — int
  • grade (Field2) — var(2)
  • grade_point (Field3) — decimal(3,2)
  • status (Field4) — enum(...)
  • enrolled_at (Field5) — timestamp

notifications (알림)

  • user_id (Key) — int — Primary key — NOT NULL
  • notification_id (Field) — int
  • type (Field2) — enum(..)
  • title (Field3) — var(200)
  • content (Field4) — text
  • is_read (Field5) — boolean
  • created_at (Field6) — timestamp

team (팀 프로젝트)

  • offering_id (Key) — int — Primary key — NOT NULL
  • course_id (FK) — int — Foreign key → course_offerings.course_id — NOT NULL
  • user_id (Key2) — int — Foreign key → course_offerings.user_id — NOT NULL
  • offering_id (Key22) — int — Foreign key → course_offerings.offering_id — NOT NULL
  • team_id (Key3) — int — Foreign key → team_members.team_id — NOT NULL
  • user_id (Key23) — int — Foreign key → team_members.user_id — NOT NULL
  • team_id (Field) — int
  • team_name (Field2) — var(200)
  • max_members (Field3) — tinyint
  • current_count (Field4) — tinyint
  • status (Field5) — enum(..)
  • created_at (Field6) — timestamp
  • Field7 — timestamp

team_members (팀원)

  • team_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Primary key — NOT NULL
  • member (Field2) — int
  • role (Field) — enum(...)
  • contribution (Field3) — tinyint
  • joinde_at (Field4) — timestamp

user (학생)

  • course_id (FK) — int — Foreign key → course_reviews.course_id — NOT NULL
  • user_id (Key) — int — Foreign key → course_reviews.user_id — NOT NULL
  • offering_id (Key2) — int — Foreign key → course_reviews.offering_id — NOT NULL
  • team_id (Key3) — int — Foreign key → team_members.team_id — NOT NULL
  • user_id (Key22) — int — Foreign key → team_members.user_id — NOT NULL
  • user_id (Key4) — int — Foreign key → notifications.user_id — NOT NULL
  • user_id (-) — int
  • student_id (Field2) — var(20)
  • name (Field3) — var(100)
  • email (Field4) — var(100)
  • department (Field) — var(100)
  • admission_year (Field7) — int
  • total_credits (Field8) — decimal(5,2)
  • gpa (Field9) — decimal(3,2)
  • created_at (Field12) — timestamp
  • updated_at (Field13) — timestamp
  • Field5