StackoverflowClone
Tables (7)
Answer (answers)
- ID (answer_id) — BIGINT — Primary key — NOT NULL — PK
- 본문 (body) — text — NOT NULL
- 작성날짜 (created_at) — timestamp — NOT NULL
- 수정날짜 (modified_at) — timestamp — NOT NULL
- 추천수 (vote) — integer — NOT NULL
- 게시글 식별 (post_id) — BIGINT — Foreign key → POST.ID — NOT NULL — FK
- Member 식별 (member_id) — BIGINT — Foreign key → Member.ID — NOT NULL — FK
Comment (comments)
- ID (comment_id) — BIGINT — Primary key — NOT NULL — PK
- 본문 (body) — text — NOT NULL
- 작성날짜 (created_at) — timestamp — NOT NULL
- 수정날짜 (modified_at) — timestamp — NOT NULL
- 답변 식별 (answer_id) — BIGINT — Foreign key → Answer.ID — FK
- 게시글 식별 (post_id) — BIGINT — Foreign key → POST.ID — FK
- Member 식별 (member_id) — BIGINT — Foreign key → Member.ID — NOT NULL — FK
Member (member)
- ID (member_id) — BIGINT — Primary key — NOT NULL — PK
- 로그인아이디 (email) — varchar(70) — NOT NULL — UNIQUE
- 비밀번호 (password) — varchar(20) — NOT NULL
- 닉네임 (alias) — varchar(20) — NOT NULL — UNIQUE
- 가입날짜 (created_at) — timestamp — NOT NULL
MemberTag (memberTag)
- ID (memberTag_id) — BIGINT — Primary key — NOT NULL — PK
- ID (member_id) — BIGINT — Foreign key → Member.ID — NOT NULL — FK
- ID (tag_id) — integer — Foreign key → Tag.ID — NOT NULL — FK
POST (posts)
- ID (post_id) — BIGINT — Primary key — NOT NULL — PK
- 제목 (title) — varchar(255)
- 본문 (body) — text — NOT NULL
- 조회수 (hit) — integer — NOT NULL
- 추천수 (vote) — integer — NOT NULL
- 작성날짜 (create_at) — timestamp — NOT NULL
- 수정날짜 (modified_at) — timestamp — NOT NULL
- Member 식별 (member_id) — BIGINT — Foreign key → Member.ID — NOT NULL — FK
PostTag
- ID (postTag_id) — BIGINT — Primary key — NOT NULL — PK
- ID (tag_id) — integer — Foreign key → Tag.ID — NOT NULL — FK
- ID (post_id) — BIGINT — Foreign key → POST.ID — NOT NULL — FK
Tag (tags)
- ID (tag_id) — integer — Primary key — NOT NULL — PK
- 태그명 (tag_name) — varchar(30) — NOT NULL — UNIQUE
- 태그설명 (tag_about) — varchar(255)