gd

Tables (3)

PR_BOARD (게시판)

  • id (게시판번호) — NOT NULL — Primary key — NOT NULL
  • userid (회원번호) — NOT NULL — Foreign key → PR_USER.id — NOT NULL
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL
  • read_count (조회수)
  • reg_date (등록일)

PR_REPLY (댓글)

  • rid (댓글번호) — NOT NULL — Primary key — NOT NULL
  • boardid (게시판번호) — NOT NULL — Foreign key → PR_BOARD.id — NOT NULL
  • userid (회원번호) — NOT NULL — Foreign key → PR_USER.id — NOT NULL
  • content (댓글내용) — NOT NULL
  • reg_date (등록일) — NOT NULL
  • update_date (수정일)
  • likecount (좋아요 수)
  • dislikecount (싫어요 수)

PR_USER (회원)

  • id (회원번호) — NOT NULL — Primary key — NOT NULL
  • user_id (아이디) — NOT NULL
  • user_pw (비밀번호) — NOT NULL
  • nickname (닉네임) — NOT NULL
  • email (이메일)
  • birth (생년월일)
  • phone (전화번호)
  • reg_date (등록일) — NOT NULL
  • Field