TIPS

TIPS DB Schema

Tables (8)

answer

  • answer_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • problem_id — BIGINT — Foreign key → problem.problem_id — NOT NULL
  • content — LONGTEXT — NOT NULL
  • good_vote — BIGINT — NOT NULL
  • bad_vote — BIGINT — NOT NULL

board

  • board_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(250) — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → comment.comment_id
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • problem_id — BIGINT — Foreign key → problem.problem_id
  • answer_id — BIGINT — Foreign key → answer.answer_id
  • document_id — BIGINT — Foreign key → document.document_id
  • content — LONGTEXT — NOT NULL
  • good_vote — BIGINT — NOT NULL
  • bad_vote — BIGINT — NOT NULL

document

  • document_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • category_id — BIGINT — Foreign key → document_category.category_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(250) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • good_vote — BIGINT — NOT NULL
  • bad_vote — BIGINT — NOT NULL

document_category

  • category_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → document_category.category_id
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • name — VARCHAR(250) — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(80) — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • email — VARCHAR(180) — NOT NULL
  • password — VARCHAR(60) — NOT NULL
  • is_admin — TINYINT(1) — NOT NULL

problem

  • problem_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → problem_category.category_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(250) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • time_limit — SMALLINT — NOT NULL
  • good_vote — BIGINT — NOT NULL
  • bad_vote — BIGINT — NOT NULL
  • hard_vote — BIGINT — NOT NULL
  • easy_vote — BIGINT — NOT NULL

problem_category

  • category_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → problem_category.category_id
  • name — VARCHAR(250) — NOT NULL