s

Tables (11)

code_snippet

  • code_snippet_id — BIGINT — Primary key — NOT NULL
  • code — TEXT
  • execution_status — ENUM('DONE', 'FAIL', 'IN_PROGRESS', 'NOT_START')
  • language — VARCHAR(255)
  • member_id — BIGINT
  • problem_id — BIGINT
  • study_id — BIGINT

member

  • member_id — BIGINT — Primary key — NOT NULL
  • avatar_url — VARCHAR(255)
  • name — VARCHAR(20) — NOT NULL
  • role — ENUM('FOLLOWER', 'LEADER', 'MEMBER') — NOT NULL

member_study

  • member_study_id — BIGINT — Primary key — NOT NULL
  • member_point — BIGINT
  • role — ENUM('FOLLOWER', 'LEADER', 'MEMBER') — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • study_id — BIGINT — Foreign key → study.study_id
  • INDEX — `FKj93en8486d9fjokd7ism4bsd9`
  • INDEX — `FKr6l01itica62olighey3949ji`

notification

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6)
  • study_id — BIGINT
  • study_name — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.member_id
  • INDEX — `FK1xep8o2ge7if6diclyyx53v4q`

problem

  • problem_id — BIGINT — Primary key — NOT NULL
  • level — BIGINT
  • representative — VARCHAR(255)
  • tag — VARCHAR(255)
  • title — VARCHAR(255)

schedule_problem

  • id — BIGINT — Primary key — NOT NULL
  • presenter — VARCHAR(255)
  • problem_id — BIGINT — Foreign key → problem.problem_id
  • study_schedule_id — BIGINT — Foreign key → study_schedule.study_schedule_id
  • INDEX — `FKshc5ohl773g54yx3ne0deo0d`
  • INDEX — `FK856ksg3ef0nkonyb508qwki9i`

status

  • status_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • problem_id — BIGINT
  • study_id — BIGINT

study

  • study_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • modified_at — DATETIME(6)
  • solve_count — BIGINT
  • study_description — VARCHAR(100) — NOT NULL
  • study_name — VARCHAR(100) — NOT NULL
  • study_point — BIGINT

study_problem

  • id — BIGINT — Primary key — NOT NULL
  • deadline — DATE
  • level — BIGINT
  • member_count — INT — NOT NULL
  • presenter — VARCHAR(255)
  • problem_status — ENUM('DONE', 'IN_PROGRESS', 'NOT_START')
  • solve_count — INT — NOT NULL
  • tag — VARCHAR(255)
  • problem_id — BIGINT — Foreign key → problem.problem_id
  • study_id — BIGINT — Foreign key → study.study_id
  • INDEX — `FKodrhc4hbtrpyi2dci6smjkihc`
  • INDEX — `FK79d0etscty31wa2s8lry68ou8`

study_roll_book

  • study_roll_book_id — BIGINT — Primary key — NOT NULL
  • member_name — VARCHAR(255)
  • study_id — BIGINT
  • today_date — DATE

study_schedule

  • study_schedule_id — BIGINT — Primary key — NOT NULL
  • deadline — DATE
  • study_id — BIGINT