test_sh
Tables (3)
User (user 유저)
- id (아이디) — PK — Primary key — NOT NULL — UNIQUE
- PW (비밀번호)
- NAME (이름)
- created_at (가입일)
- updated_at (수정일) — NOT NULL
- email (이메일) — NOT NULL — UNIQUE
comments (댓글)
- comment_num (댓글번호) — PK — Primary key — NOT NULL — UNIQUE
- post_num (글번호2) — PK — Foreign key → posts.post_num — NOT NULL — UNIQUE
- id (아이디2) — PK — Foreign key → posts.id — NOT NULL — UNIQUE
- id (아이디3) — PK — Foreign key → User.id — NOT NULL — UNIQUE
- post_num (글번호) — PK — NOT NULL
- ID (아이디) — PK — NOT NULL
- content (내용)
- updated_at (수정일)
- Field
posts (게시글)
- post_num (글번호) — PK — Primary key — NOT NULL — UNIQUE
- id (아이디) — PK — Foreign key → User.id — NOT NULL — UNIQUE
- ID (사용자ID) — NOT NULL
- TITLE (제목)
- content (내용)
- created_at (작성일)
- updated_at (수정일)
- view_count (조회수)
- Field