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