ㅁㅁㅁㅁㅁ
Tables (26)
activity_histories (대시보드)
- histories_id — BIGINT — Primary key
- action_type — VARCHAR(100)
- target_type — VARCHAR(100)
- target_id — BIGINT
- content — TEXT
- created_at — TIMESTAMP
certificates (수료증)
- certificates_id — BIGINT — Primary key
- certificate_number — VARCHAR(255)
- issued_at — TIMESTAMP
coding_problem_starter_codes (스타터 코드)
- starter_code_id — BIGINT — Primary key
- language — VARCHAR(50)
- code — TEXT
coding_problem_test_cases (코테집 테스트 케이스)
- coding_test_case_id — BIGINT — Primary key
- input — TEXT
- expected_output — TEXT
- description — TEXT
- order_index — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
coding_problems (코테집_문제)
- coding_id — BIGINT — Primary key
- title — VARCHAR(255)
- description — TEXT
- difficulty — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
coding_submissions (제출기록)
- coding_submission_id — BIGINT — Primary key
- language — VARCHAR(50)
- code — VARCHAR(50)
- result — VARCHAR(50)
- score — INT
- executed_at — TIMESTAMP
coding_workbooks (코테집(워크북))
- workbook_id — BIGINT — Primary key
- title — VARCHAR(255)
- description — TEXT
- created_at — TIMESTAMP
grammar_template_chapters (문법템플릿 챕터)
- chapter_id — BIGINT — Primary key
- title — VARCHAR(255)
- description — TEXT
- order_index — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
grammar_template_practice_files (문법 실습파일)
- grammar_file_id — BIGINT — Primary key
- file_name — VARCHAR(255)
- file_path — VARCHAR(500)
- file_type — VARCHAR(50)
- order_index — INT
- created_at — TIMESTAMP
grammar_templates (문법템플릿)
- grammar_id — BIGINT — Primary key
- title — VARCHAR(255)
- description — TEXT
- category — VARCHAR(100)
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
lab_workspaces (학습공간)
- workspaces_id — BIGINT — Primary key
- workspace_key — VARCHAR(255)
- data — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
learning_progresses (학습 진행률)
- learning_progresses_id — BIGINT — Primary key
- progress_percent — INT
- solved_count — INT
- correct_count — INT
- study_seconds — BIGINT
- last_accessed_at — TIMESTAMP
oauth_accounts (oauth_계정)
- oauth_id (id) — BIGINT — Primary key
- provider — VARCHAR(50)
- provider_user_id — VARCHAR(255)
- email — VARCHAR(255)
- created_at — TIMESTAMP
template_favorites (즐겨찾기)
- favorites_id — BIGINT — Primary key
- created_at — TIMESTAMP
template_interview_questions (면접 예상 질문)
- interview_id — BIGINT — Primary key
- question — VARCHAR(1000)
- answer_hint — TEXT
template_practice_files (기능템플릿 실습)
- file_id — BIGINT — Primary key
- file_path — VARCHAR(500)
- language — VARCHAR(50)
- content — TEXT
- read_only — BOOLEAN
- order_index — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
template_practice_mission_progresses (미션 진행도)
- misson_progresses_id — BIGINT — Primary key
- status — VARCHAR(50)
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
template_practice_missions (기능템플릿 미션)
- mission_id — BIGINT — Primary key
- title — VARCHAR(255)
- description — TEXT
- mission_type — VARCHAR(100)
- order_index — INT
- guide_content — TEXT
- validation_json — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
template_practice_progresses (템플릿 진행도)
- template_progresses_id — BIGINT — Primary key
- status — VARCHAR(50)
- progress_percent — INT
- completed_mission_count — INT
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
- last_accessed_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
template_practice_submissions (제출)
- submissions_id — BIGINT — Primary key
- language — VARCHAR(50)
- source_code — TEXT
- status — VARCHAR(50)
- passed_count — INT
- total_count — INT
- judge_token — VARCHAR(255)
- stdout — TEXT
- stderr — TEXT
- compile_output — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
template_tags (template_태그)
- tag_id — VARCHAR(100) — Primary key
template_tech_stacks (기술 스택)
- tech_stack — VARCHAR(100) — Primary key
template_test_cases (테스트케이스)
- test_case_id — BIGINT — Primary key
- input — TEXT
- expected_output — TEXT
- description — TEXT
- order_index — INT
templates (템플릿)
- templates_id (id) — BIGINT — Primary key
- type — VARCHAR(20)
- slug — VARCHAR(120)
- title — VARCHAR(120)
- summary — VARCHAR(500)
- catefory — VARCHAR(80)
- difficulty — VARCHAR(30)
- status — VARCHAR(20)
- visibility — VARCHAR(20)
- access_level — VARCHAR(20)
- thumbnail_url (Field)
user_settings (사용자 설정)
- settings_id (id) — BIGINT — Primary key
- theme — VARCHAR(50)
- language — VARCHAR(50)
- email_notification — BOOLEAN
- push_notification — BOOLEAN
- editor_font_size — INT
- editor_theme — VARCHAR(50)
- editor_tab_size — INT
- service_theme — VARCHAR(50)
- auto_login_enabled — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users (사용자)
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(100)
- profile_image_url — VARCHAR(500)
- role — VARCHAR(50)
- status — VARCHAR(50)
- email_verified — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP