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