test

Tables (6)

SingoHangMok (신고항목)

  • hangmok_num (항목번호) — int(20) — Primary key — NOT NULL
  • hangmok_cont (항목내용) — varchar(20)
  • hangmok_blind (삭제여부) — int(2)

SingoList (신고내역)

  • singo_num (내역번호) — int(20) — Primary key — NOT NULL
  • mem_id (회원아이디) — varchar(20) — Foreign key → members.mem_id — NOT NULL
  • hangmok_num (항목번호) — int(20) — Foreign key → SingoHangMok.hangmok_num — NOT NULL
  • board_num (게시글번호) — int(50) — Foreign key → board.board_num — NOT NULL
  • singo_cont (신고설명) — varchar(100)
  • singo_state (처리상태) — int(2)
  • singo_date (신고날짜) — DATETIME
  • singo_updateDay (처리날짜) — DATETIME

board (게시글)

  • board_num (게시글번호) — int(50) — Primary key — NOT NULL
  • mem_id (회원아이디) — varchar(20) — Foreign key → members.mem_id — NOT NULL
  • board_sub (제목) — varchar(100)
  • board_cont (내용) — varchar(1000)
  • board_date (작성날짜) — DATETIME
  • board_updateDate (수정날짜) — DATETIME
  • board_blind (삭제여부) — int(2)
  • board_commentCount (댓글갯수) — int(10)

comment (댓글)

  • comment_num (댓글번호) — int(50) — Primary key — NOT NULL
  • board_num (게시글번호) — int(50) — Foreign key → board.board_num — NOT NULL
  • mem_id (회원아이디) — varchar(20) — Foreign key → members.mem_id — NOT NULL
  • comment_cont (댓글내용) — varchar(100)
  • comment_date (작성시간) — DATETIME
  • comment_updateDate (수정시간) — DATETIME
  • comment_bilnd (삭제여부) — int(2)

members (회원)

  • mem_id (회원아이디) — varchar(20) — Primary key — NOT NULL
  • mem_pw (비밀번호) — varchar(100)

singoClear (신고처리)

  • clear_num (처리번호) — int(20) — Primary key — NOT NULL
  • singo_num (내역번호) — int(20) — Foreign key → SingoList.singo_num — NOT NULL
  • clear_id (처리자아이디) — varchar(20)