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