Career-Hi
Tables (11)
certification
- pk (id) — int — Primary key — NOT NULL
- member_fk (member_id) — int — Foreign key → profile.pk — NOT NULL
- 내용 (content) — varchar
- 취득일 (certified_at) — timestamp
chat_history
- pk (id) — int — Primary key — NOT NULL
- 채팅방 fk (chat_room_id) — int — Foreign key → chat_room.pk — NOT NULL
- 유저/챗봇 구분 (sender) — 'user', 'llm'
- 내용 (content) — text
- 보낸 날짜 (created_at) — timestamp
chat_room
- pk (id) — int — Primary key — NOT NULL
- 멤버 fk (member_id) — int — Foreign key → member.pk — NOT NULL
- 삭제 여부 (is_deleted) — boolean
- 생성일 (created_at) — timestamp
club_activity
- pk (id) — int — Primary key — NOT NULL
- profile_fk (profile_id) — int — Foreign key → profile.pk — NOT NULL
- 내용 (content) — varchar
course_catalogs
- pk (id) — int — Primary key — NOT NULL
- 학년 (academic_year)
- 반 (section)
- 이수구분 (credit_type)
- 이수단위 (credit_units)
- 영역 (domain)
- 수업번호 (course_number)
- 학수번호 (course_code)
- (변경전)교과목명 (old_course_name)
- 교과목명 (course_name)
- 과목안내 (course_guide)
- 공학인증구분 (accreditation_type)
- 학위과정 (degree_progream)
- 교강사 (instructor)
- 학점 (total_credits)
- 강의 (lecture_credits)
- 실습 (lab_credits)
- 강좌유형 (course_category)
- 수강/정원 (enrollment_capacity)
- 수업형태 (class_format)
- 수업시간 (class_time)
- 강의실 (classroom)
- 이수제한여부 (completion_restriction)
- 과목상세 정보 (detailed_info)
- 6C 핵심역량 (core_competency)
- 설강학과 (offering_department)
- 교과목개요 (course_overview)
- 수업 목표 (course_objectives)
- 1주차 강의계획 (week1_plan)
- 2주차 강의계획 (week2_plan)
- 3주차 강의계획 (week3_plan)
- 4주차 강의계획 (week4_plan)
- 5주차 강의계획 (week5_plan)
- 6주차 강의계획 (week6_plan)
- 7주차 강의계획 (week7_plan)
- 8주차 강의계획 (week8_plan)
- 9주차 강의계획 (week9_plan)
- 10주차 강의계획 (week10_plan)
- 11주차 강의계획 (week11_plan)
- 12주차 강의계획 (week12_plan)
- 13주차 강의계획 (week13_plan)
- 14주차 강의계획 (week14_plan)
- 15주차 강의계획 (week15_plan)
- 16주차 강의계획 (week16_plan)
course_catalogs_mapping (course_catalog_mapping)
- pk (id) — int — Primary key — NOT NULL
- profile_fk (profile_id) — int — Foreign key → profile.pk — NOT NULL
- cousre_catalogs_fk (course_catalogs_id) — int — Foreign key → course_catalogs.pk — NOT NULL
job_interests (job_intersts)
- pk (id) — int — Primary key — NOT NULL
- profile_fk (profile_id) — int — Foreign key → profile.pk — NOT NULL
- 내용 (content) — varchar
job_posting
- pk (id) — varchar — Primary key — NOT NULL
- 제목 (title) — varchar
- 모집시작일 (start_date) — timestamp
- 모집마감일 (deadline) — timestamp
- 모집중 (Field) — boolean
- url — varchar
- 크롤링시점 (crwaling_time) — timestamp
job_posting_mapping
- pk (id) — int — Primary key — NOT NULL
- job_posting_fk (job_posting_id) — int — Foreign key → job_posting.pk — NOT NULL
- member_fk (member_id) — varchar — Foreign key → member.pk — NOT NULL
member
- pk (id) — Primary key — NOT NULL
- 이메일 (email)
- 비밀번호 (pwd)
- 가입일 (signup_date)
profile
- pk (id) — int — Primary key — NOT NULL
- 멤버 fk (memeber_id) — varchar — Foreign key → member.pk — NOT NULL
- 학년 (grade) — int
- 학과 (department) — varchar