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