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)