community

Tables (3)

boards (Untitled2)

  • 닉네임 (username) — varchar — Foreign key → members.닉네임
  • 게시글ID (board_id) — varchar
  • 게시글제목 (board_title) — varchar
  • 게시글내용 (board_text) — text
  • 좋아요 (count_likes) — int unsigned
  • 조회수 (count_views) — int unsigned
  • 댓글수 (count_comments) — int unsigned

comments (Untitled3)

  • Key — Primary key — NOT NULL
  • 닉네임 (username) — varchar — Foreign key → members.닉네임
  • Field

members (Untitled)

  • 닉네임 (username) — varchar — Primary key
  • ID (id_user) — varchar
  • 비밀번호 (password) — varchar
  • ID숫자 (in_no) — int unsigned
  • 생성시간 (created_at) — datetime