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