ㅁㄴㅇㄹ
Tables (11)
Feedback
- feedback_id — INT
- student_id — INT — NOT NULL
- resource_id — INT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- feedback_date — DATETIME
- INDEX — idx_student_resource
LectureTimes
- time_id — INT
- lecture_id — INT
- day_of_week — ENUM('월','화','수','목','금')
- start_time — TIME
- end_time — TIME
Recommendations
- recommendation_id — INT
- student_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- resource_id — INT — NOT NULL
- recommended_at — DATETIME
- INDEX — idx_student_lecture
Resources
- resource_id — INT
- title — VARCHAR(100) — NOT NULL
- url — TEXT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- description — TEXT
- keywords — TEXT
- INDEX — idx_title
- INDEX — idx_type
Schedules
- schedule_id — INT
- student_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- semester — VARCHAR(10) — NOT NULL
- year — INT — NOT NULL
- INDEX — idx_student_lecture
Students
- student_id — INT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- major — VARCHAR(50) — NOT NULL
- pwd — VARCHAR(50) — NOT NULL
- year — INT — NOT NULL
- INDEX — idx_email — 학생 정보를 저장하는 테이블'; CREATE TABLE Lectures ( lecture_id INT AUTO_INCREMENT PRIMARY KE
- course_name — VARCHAR(100) — NOT NULL
- professor_name — VARCHAR(50) — NOT NULL
- INDEX — idx_course_name
Timetable
- student_id — INT — NOT NULL
- course_name — VARCHAR(50) — NOT NULL
- day_of_week — ENUM('월', '화', '수', '목', '금') — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- room — VARCHAR(50)
VideoRatings
- rating_id — INT
- student_id — INT — NOT NULL
- video_id — VARCHAR(50) — NOT NULL
- rating — INT — NOT NULL
- rated_at — DATETIME
- UNIQUE(student_id, — video_id)
- INDEX — idx_video_rating
Video_views
- view_id — INT
- student_id — INT — NOT NULL
- course_name — VARCHAR(50) — NOT NULL
- video_id — VARCHAR(50) — NOT NULL
- viewed_at — TIMESTAMP
- watch_time — INT
YouTubeVideos
- video_id — VARCHAR(50)
- title — VARCHAR(255) — NOT NULL
- url — TEXT
- description — TEXT
- published_date — DATE
- thumbnail_url — TEXT
- channel_title — VARCHAR(100)
- keywords — TEXT
title
- user — varchar — Primary key — NOT NULL
- Field