sometimes_final

Tables (16)

ADMINS

  • admin_id — INT — 비밀번호
  • login_id — VARCHAR(50) — NOT NULL — 이름
  • password — VARCHAR(255) — NOT NULL — 이메일
  • name — VARCHAR(50) — NOT NULL — 권한(운영자/개발자)
  • email — VARCHAR(100) — NOT NULL — 로그_ID
  • role — VARCHAR(20) — NOT NULL — 오류유형(CSP_FAIL/LLM_TIMEOUT 등)

BUILDINGS

  • building_id — INT — Primary key — NOT NULL — 건물명(예:가천관)
  • building_name — VARCHAR(50) — NOT NULL — 관리자_ID

CARTS

  • user_id — INT — Foreign key → USERS.user_id — NOT NULL — 목표 학점
  • course_id — INT — Foreign key → COURSES.course_id — NOT NULL — 기수강_ID
  • major_id (major_id2) — INT — Foreign key → USERS.major_id — 학과_ID
  • created_at — DATETIME — NOT NULL — 회원_ID

COURSES

  • course_id — INT — 학점
  • course_code — VARCHAR(50) — NOT NULL — 담당교수
  • course_name — VARCHAR(100) — NOT NULL — 수용인원
  • major_id — INT — Foreign key → MAJORS.major_id — NOT NULL — 장바구니 담은 인원(AI가중치용)
  • classification — VARCHAR(50) — NOT NULL — 스케줄_ID
  • credits — INT — NOT NULL — 강의_ID
  • professor — VARCHAR(50) — 요일
  • capacity — INT — NOT NULL — 시작교시
  • cart_count — INT — NOT NULL — 종료교시
  • major_id (major_id2) — INT — Foreign key → MAJORS.major_id — 학과_ID

COURSE_SCHEDULES

  • schedule_id — INT — 강의실 호수
  • course_id — INT — Foreign key → COURSES.course_id — NOT NULL — 거리_ID
  • day_of_week — VARCHAR(10) — NOT NULL — 출발건물_ID
  • start_period — INT — NOT NULL — 도착건물_ID
  • end_period — INT — NOT NULL — 소요시간(분)
  • building_id — INT — Foreign key → BUILDINGS.building_id — 오르막길 여부
  • room_name — VARCHAR(50) — 회원_ID
  • major_id (major_id2) — INT — Foreign key → COURSES.major_id — 학과_ID
  • building_id (building_id2) — INT — Foreign key → BUILDINGS.building_id — 건물명(예:가천관)

DISTANCES

  • distance_id — INT — 담은 일시
  • from_building_id — INT — Foreign key → BUILDINGS.building_id — NOT NULL — 선호도_ID
  • to_building_id — INT — Foreign key → BUILDINGS.building_id — NOT NULL — 회원_ID
  • time_minutes — INT — NOT NULL — 선호 공강 요일
  • is_uphill — BOOLEAN — NOT NULL — 아침수업 기피여부
  • =건물 — 간
  • building_id (building_id2) — INT — Foreign key → BUILDINGS.building_id — 건물명(예:가천관)

ERROR_LOGS

  • log_id — INT — 발생일시
  • error_type — VARCHAR(50) — NOT NULL — 회원_ID
  • error_message — TEXT — NOT NULL — 로그인ID
  • created_at — DATETIME — NOT NULL — 비밀번호

GRADUATION_REQS

  • req_id — INT — 생성일시
  • major_id — INT — Foreign key → MAJORS.major_id — NOT NULL — 매핑_ID
  • apply_year — VARCHAR(20) — NOT NULL — 시간표_ID
  • total_req_credits — INT — NOT NULL — 강의_ID
  • major_req_credits — INT — NOT NULL — 공지_ID
  • general_req_credits — INT — NOT NULL — 작성자_ID
  • major_id (major_id2) — INT — Foreign key → MAJORS.major_id — 학과_ID

MAJORS

  • major_id — INT — Primary key — 학과_ID
  • college_name — VARCHAR(50) — NOT NULL — 단과대학명
  • major_name — VARCHAR(50) — NOT NULL — 학과명

NOTICES

  • notice_id — INT — NOT NULL

PREFERENCES

  • pref_id — INT — 교과목명
  • user_id — INT — Foreign key → USERS.user_id — NOT NULL — 이수구분
  • free_day — VARCHAR(10) — 학점
  • avoid_morning — BOOLEAN — NOT NULL — 요건_ID
  • avoid_uphill — BOOLEAN — NOT NULL — 학과_ID
  • target_credits — INT — NOT NULL — 적용학번(예:20학번)
  • major_id (major_id2) — INT — Foreign key → USERS.major_id — 학과_ID

SYSTEM_CONFIGS

  • config_id — INT — NOT NULL

TAKEN_COURSES

  • taken_id — INT — 전필 필수이수학점
  • user_id — INT — Foreign key → USERS.user_id — NOT NULL — 교양 필수이수학점
  • course_code — VARCHAR(50) — NOT NULL — 시간표_ID
  • course_name — VARCHAR(100) — NOT NULL — 회원_ID
  • classification — VARCHAR(50) — NOT NULL — 플랜 타입(A,B,C)
  • credits — INT — NOT NULL — 최종 저장 여부
  • major_id (major_id2) — INT — Foreign key → USERS.major_id — 학과_ID

TIMETABLES

  • timetable_id — INT — 내용
  • user_id — INT — Foreign key → USERS.user_id — NOT NULL — 작성일시
  • plan_type — VARCHAR(10) — NOT NULL — 설정_ID
  • is_selected — BOOLEAN — NOT NULL — 설정키
  • ai_comment — TEXT — EXT COMMENT '요청된 설정값
  • created_at — DATETIME — NOT NULL — 분류(가중치/프롬프트)
  • major_id (major_id2) — INT — Foreign key → USERS.major_id — 학과_ID

TIMETABLE_COURSES

  • map_id — INT — 요청 관리자_ID
  • timetable_id — INT — Foreign key → TIMETABLES.timetable_id — NOT NULL — 업데이트 일시
  • course_id — INT — Foreign key → COURSES.course_id — NOT NULL
  • major_id (major_id2) — INT — Foreign key → TIMETABLES.major_id — 학과_ID

USERS

  • user_id — INT — 학과_ID
  • login_id — VARCHAR(50) — NOT NULL — 학년
  • password — VARCHAR(255) — NOT NULL — 학번
  • name — VARCHAR(50) — NOT NULL — 이메일
  • major_id — INT — Foreign key → MAJORS.major_id — NOT NULL — 상태(ACTIVE/WITHDRAWN)
  • grade — INT — NOT NULL — 가입일시
  • student_id — VARCHAR(20) — NOT NULL — 강의_ID
  • email — VARCHAR(100) — NOT NULL — 학수번호
  • status — VARCHAR(20) — NOT NULL — 교과목명
  • created_at — DATETIME — NOT NULL — 개설조직_ID
  • major_id (major_id2) — INT — Foreign key → MAJORS.major_id — 학과_ID