erd

Tables (5)

auth (권한)

  • auth_id (pk) — long — Primary key — NOT NULL
  • Field

board (게시판)

  • board_id (pk) — long — Primary key — NOT NULL
  • board_pid (uk) — long — Primary key — NOT NULL
  • subject (Field) — varchar
  • contents (Field2) — Text
  • view_count (Field3)
  • Field4

category (카테고리)

  • category_id (pk) — long — Primary key — NOT NULL
  • category_name (Field) — varchar
  • Field2

comments (댓글)

  • comments_id (pk) — Primary key — NOT NULL
  • comments_pid (Field)
  • Field2

user (사용자)

  • user_id (PK) — long — Primary key — NOT NULL
  • user_name (Field) — varchar
  • user_pw (Field2)
  • user_nickname (Field3)