ㅁㅁㅁㅁㅁ

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