studyhalp

Tables (13)

member

  • id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(20)
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • handle — VARCHAR(100)
  • is_verified — TINYINT(1) — NOT NULL
  • last_login_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → member_solved_problem.id — NOT NULL

member_recommendation

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • recommendation_id — BIGINT — NOT NULL
  • team_id — BIGINT — 스냅샷 (DB FK 없음)
  • team_name — VARCHAR(255) — 스냅샷
  • email_send_status — VARCHAR(16) — NOT NULL
  • email_sent_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → recommendation.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → member.id — NOT NULL

member_solved_problem

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • solved_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → problem.id — NOT NULL — 백준 문제 번호

notification

  • id — BIGINT — Primary key — NOT NULL
  • recipient_id — BIGINT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • metadata — TEXT
  • read_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • INDEX — idx_recipient
  • id (id2) — BIGINT — Foreign key → member.id — NOT NULL

problem

  • id — BIGINT — Primary key — NOT NULL — 백준 문제 번호
  • title — VARCHAR(255) — NOT NULL
  • title_ko — VARCHAR(255)
  • level — INT
  • accepted_user_count — INT
  • average_tries — DOUBLE

problem_tag

  • id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL — 문제 ID
  • tag_key — VARCHAR(64) — NOT NULL — Tag 참조
  • INDEX — idx_problem_tag_problem
  • INDEX — idx_problem_tag_tag

recommendation

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(16) — NOT NULL — SCHEDULED, MANUAL
  • team_id — BIGINT — 스냅샷 (DB FK 없음)
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

recommendation_problem

  • id — BIGINT — Primary key — NOT NULL
  • recommendation_id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → recommendation.id — NOT NULL

tag

  • tag_key — VARCHAR(64) — Primary key — NOT NULL — solved.ac 태그 키 (dp, greedy 등)
  • name_ko — VARCHAR(100) — NOT NULL — 한글 태그명
  • name_en — VARCHAR(100) — NOT NULL — 영문 태그명

team

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • is_private — TINYINT(1) — NOT NULL
  • recommendation_status — VARCHAR(16) — NOT NULL
  • recommendation_days — INT — NOT NULL
  • problem_difficulty_preset — VARCHAR(16)
  • min_problem_level — INT
  • max_problem_level — INT
  • problem_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

team_include_tag

  • id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL — Team 참조
  • tag_key — VARCHAR(64) — NOT NULL — Tag 참조
  • INDEX — idx_team_include_tag_team
  • INDEX — idx_team_include_tag_tag

team_join

  • id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • type — VARCHAR(16) — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • target_member_id — BIGINT
  • status — VARCHAR(16) — NOT NULL
  • processed_at — DATETIME(6)
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • INDEX — idx_target_status
  • INDEX — idx_team_status
  • INDEX — idx_requester_status

team_member

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • id (id2) — BIGINT — Foreign key → member.id — NOT NULL
  • team_id — BIGINT — NOT NULL
  • id (id3) — BIGINT — Foreign key → team.id — NOT NULL