BugBuddy
Tables (15)
answer_reactions
- id — BIGINT — Primary key — NOT NULL
- answer_id — BIGINT — Foreign key → answers.id — NOT NULL
- voter_user_id — BIGINT — Foreign key → users.id — NOT NULL
- reaction_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
answer_stats
- answer_id — BIGINT — Foreign key → answers.id — NOT NULL
- helpful_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
answers
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → questions.id — NOT NULL
- author_user_id — BIGINT — Foreign key → users.id — NOT NULL
- body — MEDIUMTEXT — NOT NULL
- author_snapshot_role — VARCHAR(20) — NOT NULL
- is_accepted — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
chat_messages
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_user_id — BIGINT — Foreign key → users.id — NOT NULL
- message_type — VARCHAR(20) — NOT NULL
- content — MEDIUMTEXT
- file_url — VARCHAR(500)
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
chat_room_feedback
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- rater_user_id — BIGINT — Foreign key → users.id — NOT NULL
- rating — TINYINT(1) — NOT NULL
- comment — VARCHAR(500) — ARCHAR(500) NUL
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
chat_rooms
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → questions.id
- mentor_user_id — BIGINT — Foreign key → users.id — NOT NULL
- mentee_user_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- closed_at — DATETIME(3)
- deleted_at — DATETIME(3)
mentor_application_links
- id — BIGINT — Primary key — NOT NULL
- mentor_application_id — BIGINT — Foreign key → mentor_applications.id — NOT NULL
- link_type — VARCHAR(30) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
mentor_applications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- q1_answer — TEXT — NOT NULL
- q2_answer — TEXT — NOT NULL
- reviewer_user_id — BIGINT — Foreign key → users.id
- reviewed_at — DATETIME(3)
- rejection_reason — VARCHAR(500)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
question_stats
- question_id — BIGINT — Foreign key → questions.id — NOT NULL
- answer_count — INT — NOT NULL
- helpful_total — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
question_tags
- question_id — BIGINT — Foreign key → questions.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
questions
- id — BIGINT — Primary key — NOT NULL
- author_user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(120) — NOT NULL
- body — MEDIUMTEXT — NOT NULL
- category — VARCHAR(30) — NOT NULL
- question_type — VARCHAR(30) — NOT NULL
- allow_1to1 — TINYINT(1) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
reports
- id — BIGINT — Primary key — NOT NULL
- reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- reason_code — VARCHAR(30) — NOT NULL
- reason_detail — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- resolved_at — DATETIME(3)
- resolver_user_id — BIGINT — Foreign key → users.id
- deleted_at — DATETIME(3)
tags
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(60) — NOT NULL
- is_official — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3)
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- oauth_provider — VARCHAR(50)
- oauth_subject — VARCHAR(255)
- nickname — VARCHAR(40) — NOT NULL
- bio — VARCHAR(280)
- role — VARCHAR(20) — NOT NULL
- mentor_status — VARCHAR(20) — NOT NULL
- xp — INT — NOT NULL
- level — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deactivated_at — DATETIME(3)
- deleted_at — DATETIME(3)
xp_events
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- event_type — VARCHAR(40) — NOT NULL
- ref_type — VARCHAR(30)
- ref_id — BIGINT
- delta_xp — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL