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