55

Tables (4)

Member (Untitled)

  • Key (회원ID) — BIGINT — Primary key — NOT NULL — 회원번호(자동증가)
  • Field — VARCHAR — NOT NULL — 이름
  • Field2 — VARCHAR — NOT NULL
  • Field3 (이메일) — VARCHAR — NOT NULL — 이메일(형식지정)
  • Field3

Untitled2

  • Key — Primary key — NOT NULL
  • Field

Untitled3 (Board)

  • Key2 (게시글번호) — Primary key — NOT NULL — 글번호(자동증가)
  • Key (회원ID) — BIGINT — Foreign key → Member.Key — NOT NULL — 회원번호(자동증가)
  • Field (작성자) — VARCHAR — NOT NULL — 작성자(회원만)
  • Field (제목) — VARCHAR — 제목
  • Field (내용) — TEXT — 내용(null 가능)

Untitled4 (Comment)

  • Key (댓글id) — Primary key — NOT NULL — 댓글번호(자동증가)
  • Field (댓글내용) — TEXT — NOT NULL — 댓글내용
  • Field — NOT NULL — 글번호(자동증가)
  • Key (회원ID) — BIGINT — Foreign key → Member.Key — NOT NULL — 회원번호(자동증가)