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