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)