Test
Tables (5)
BOARD (Untitled2)
- BNO (게시글번호) — INT — Primary key — NOT NULL
- ID (아이디) — VARCHAR(30) — Foreign key → MEMBER.ID — NOT NULL
- TITLE (제목) — VARCHAR(1000)
- CONTENT (내용) — LONGTEXT
- NICKNAME (비회원닉네임) — VARCHAR(30)
- BPWD (비회원비밀번호)
- MODID (수정아이디) — VARCHAR(30)
- MODDATE (수정날짜) — DATE
- COUNT (조회수) — INT
- RPTCOUNT (신고횟수) — INT
- DELETE_YN (삭제유무) — CHAR(1)
- DATE (작성날짜) — DATE
BOARD_LIKE (CopyOfUntitled5)
- BLNO (좋아요번호) — INT — Primary key — NOT NULL
- BNO (게시글번호) — INT — Foreign key → BOARD.BNO — NOT NULL
- ID (아이디) — VARCHAR(30)
- DATE (좋아요날짜) — DATE
BOARD_REPLY (CopyOfUntitled4)
- BRNO (댓글번호) — INT — Primary key — NOT NULL
- BNO (게시글번호) — INT — Foreign key → BOARD.BNO — NOT NULL
- ID (아이디) — VARCHAR(30)
- RLEVEL (댓글뎁스) — INT
- BRCONTENT (댓글내용) — LONGTEXT
- DATE (작성날짜) — DATE
BOARD_REPORT (Untitled3)
- RNO (신고번호) — INT — Primary key — NOT NULL
- BNO (게시글번호) — INT — Foreign key → BOARD.BNO — NOT NULL
- WRTID (작성자아이디) — VARCHAR(30)
- RPTID (신고자아이디) — VARCHAR(30)
- RCONTENT (신고내용) — LONGTEXT
MEMBER (Untitled)
- ID (아이디) — VARCHAR(30) — Primary key — NOT NULL
- MNO (회원번호) — INT
- DELETE_YN (삭제유무) — CHAR(1)
- PWD (비밀번호) — VARCHAR(1000)
- DATE (가입날짜) — DATE