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