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