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