unifit_1
Tables (9)
Untitled
- Key — Primary key — NOT NULL
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