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 — 회원번호(자동증가)