CatDB

Tables (3)

Board (게시판)

  • board_id (게시글 id) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • category (카테고리)
  • reg_date (작성일)
  • img_url (이미지)
  • member_id (회원 id) — Foreign key → Member.member_id — NOT NULL

Comment (댓글)

  • comment_id (댓글 id) — Primary key — NOT NULL
  • content (내용)
  • reg_date (작성일)
  • board_id (게시글 id) — Foreign key → Board.board_id — NOT NULL
  • member_id (회원 id) — Foreign key → Member.member_id — NOT NULL

Member (회원)

  • member_id (회원 id) — Primary key — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • nickname (닉네임)
  • role (관리자또는 유저)