okeydokey

테이블 (4)

글 (forums)

  • 글ID (forumId) — int — 기본 키 — NOT NULL — auto increment
  • 글제목 (forumTitle) — varchar(50) — NOT NULL — how can i change my username?
  • 글내용 (forumContents) — varchar(10000) — NOT NULL — I read a reply from Stack Overflow, and I find the replier showing his name instead of @user999999 format. Below is one…
  • 글작성날짜 (forumDate) — datetime — NOT NULL — 2023-01-01 12:30:45
  • 글수정날짜 (forumUpdateDate) — datetime — 2023-01-03 12:30:45
  • 글조회수 (forumHits) — int — 20
  • 글투표수 (forumVotingCounts) — int — 3
  • 유저ID (userId) — int — 외래 키 → 회원정보.유저ID — NOT NULL — auto increment

답변 (answers)

  • 답변ID (answerId) — int — 기본 키 — NOT NULL — auto increment
  • 답변내용 (answerContents) — varchar(10000) — NOT NULL — Click on profile on upper right corner. Click edit. Change "Display Name" to desired. Save
  • 답변작성날짜 (answerDate) — datetime — NOT NULL — 2023-01-02 12:30:45
  • 답변수정날짜 (answerUpdateDate) — datetime — 2023-01-02 12:33:45
  • 답변투표수 (answerVotingCounts) — int — 23
  • 유저ID (userId) — int — 외래 키 → 회원정보.유저ID — NOT NULL — auto increment
  • 글ID (forumId) — int — 외래 키 → 글.글ID — NOT NULL — auto increment

답변에 대한 댓글 (comments)

  • 댓글ID (commentId) — int — 기본 키 — NOT NULL — auto increment
  • 댓글내용 (commentContents) — varchar(10000) — NOT NULL — This answer is now obsolete! Please refer to any of the other answers which explain how to do this in modern versions o…
  • 댓글작성자 (commentWriter) — varchar(20) — NOT NULL — Gimby
  • 댓글작성날짜 (commentDate) — datetime — NOT NULL — 2023-01-03 12:33:45
  • 댓글수정날짜 (commentUpdateDate) — datetime — 2023-01-03 13:33:45
  • 유저ID (userId) — int — 외래 키 → 회원정보.유저ID — NOT NULL — auto increment
  • 답변ID (answerId) — int — 외래 키 → 답변.답변ID — NOT NULL — auto increment

회원정보 (users)

  • 유저ID (userId) — int — 기본 키 — NOT NULL — auto increment
  • 이름 (userName) — varchar(15) — NOT NULL — bely
  • 이메일 (userEmail) — varchar(50) — NOT NULL — [email protected]
  • 비밀번호 (userPw) — varchar(20) — NOT NULL — bely123
  • 작성날짜 (userDate) — datetime — NOT NULL — 2023-01-01 12:30:45
  • 수정날짜 (userUpdateDate) — datetime — 2023-01-01 12:30:45