my-practice-erd

Tables (3)

Untitled (Members)

  • Key (member_id) — BIGINT — Primary key — NOT NULL — 회원번호(자동증가)
  • Field (name) — VARCHAR — NOT NULL — 이름
  • Field (password) — VARCHAR — NOT NULL — 비밀번호
  • Field (email) — VARCHAR — NOT NULL — 이메일

Untitled (Board)

  • Key (board_no) — BIGINT — Primary key — NOT NULL — 글번호(자동증가)
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 회원번호(자동증가)
  • Field (writer) — VARCHAR — NOT NULL — 작성자(회원만)
  • Field (title) — VARCHAR — NOT NULL — 제목
  • Field2 (content) — TEXT — 내용

Untitled (Comment)

  • Key (comment_id) — Primary key — NOT NULL — 댓글번호(자동증가)
  • Field (content) — VARCHAR — NOT NULL — 댓글내용
  • Key (board_no) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 글번호(자동증가)
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 회원번호(자동증가)