BugBuster 개발자 커뮤니티
테이블 (10)
board
- postNum — INT — 기본 키
- writer — VARCHAR(50)
- title — VARCHAR(100)
- content — TEXT
- codeContent — TEXT
- createdAt — TIMESTAMP
- views — INT — NOT NULL
- programmingLanguage — VARCHAR(50)
- user_id — varchar(50) — 외래 키 → member.user_id
board_attach
- id — INT — 기본 키
- postNum — INT
- filename — VARCHAR(40)
- createdAt — TIMESTAMP
- postNum (postNum2) — INT — 외래 키 → board.postNum
comment
- commentId — int — 기본 키
- postNum — int — NOT NULL
- userId — varchar(50) — NOT NULL
- content — text — NOT NULL
- parentCommentId — int
- depth — INT
- isDeleted — BOOLEAN
- createdAt — DATETIME
- updateAt — DATETIME
- user_id — varchar(50) — 외래 키 → member.user_id
- postNum (postNum2) — INT — 외래 키 → board.postNum
- commentId (commentId2) — int — 외래 키 → comment.commentId
likes
- likeNum — INT — 기본 키
- user_id — VARCHAR(50)
- postNum — INT
- created_at — TIMESTAMP
- user_id (user_id2) — varchar(50) — 외래 키 → member.user_id
- postNum (postNum2) — INT — 외래 키 → board.postNum
member
- user_id — varchar(50) — 기본 키
- user_password — varchar(100)
- user_name — varchar(100)
- zipcode — varchar(5)
- address — varchar(100)
- user_email — varchar(100)
- user_phone_number — varchar(20)
- birth_date — DATE
- detailAddress — varchar(100)
member_interest
- user_id — VARCHAR(50) — 기본 키
- interest — varchar(20) — 기본 키
- user_id (user_id2) — varchar(50) — 외래 키 → member.user_id
news
- newsId — INT — 기본 키
- title — TEXT — NOT NULL
- originallink — TEXT — NOT NULL
- link — TEXT — NOT NULL
- description — TEXT — NOT NULL
- pubDate — TIMESTAMP
- query — VARCHAR(50)
- category — VARCHAR(50)
problems
- problemId — INT — 기본 키
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- sampleInput — TEXT
- sampleOutput — TEXT
- difficulty — VARCHAR(50)
- language — VARCHAR(50)
- createdAt — TIMESTAMP
profile_attach
- id — INT — 기본 키
- user_id — varchar(50)
- filename — VARCHAR(40)
- createdAt — TIMESTAMP
- user_id (user_id2) — varchar(50) — 외래 키 → member.user_id
submissions
- submissionId — INT — 기본 키
- userId — VARCHAR(50) — NOT NULL
- problemId — INT — NOT NULL
- code — TEXT — NOT NULL
- language — VARCHAR(50)
- submittedAt — TIMESTAMP
- isCorrect — BOOLEAN
- feedback — TEXT
- user_id — varchar(50) — 외래 키 → member.user_id
- problemId (problemId2) — INT — 외래 키 → problems.problemId