ㄴㅇ

Tables (7)

BOARD (게시글)

  • BID (게시글 번호) — PK — Primary key — NOT NULL
  • BTITLE (게시글 제목) — NN
  • BCONTENT (게시글 내용) — NN
  • BDATE (작성일) — NN
  • BIMG (게시 파일 경로) — NN
  • MID (아이디) — FK — Foreign key → MEMBER.MID — NOT NULL

LLIKE (좋아요)

  • LID (LLIKE 번호) — PK — Primary key — NOT NULL
  • LSTATUS (좋아요) — NN
  • NLSTATUS (싫어요) — NN
  • REPORT (신고) — NN
  • MID (아이디) — FK — Foreign key → MEMBER.MID — NOT NULL
  • BID (게시글 번호) — FK — Foreign key → BOARD.BID — NOT NULL

MEMBER (유저)

  • MID (아이디) — PK — Primary key — NOT NULL
  • MPW (비밀번호) — NN
  • MNAME (사용자 이름) — NN
  • NICKNAME (닉네임) — NN
  • MPHONE (휴대폰) — NN
  • MEMAIL (이메일) — NN
  • ROLE (권한) — NN

NOVEL (소설)

  • NID (소설 번호) — PK — Primary key — NOT NULL
  • NTITLE (소설 제목) — NN
  • NCONTENT (소설 내용) — NN
  • NIMG (소설 이미지 경로) — NN
  • NGENRE (소설 장르) — NN
  • NWRITER (작가명) — NN

OPINION (리뷰)

  • OID (리뷰 번호) — PK — Primary key — NOT NULL
  • OCONTENT (리뷰 내용) — NN
  • ODATE (리뷰 작성일) — NN
  • OSTAR (평점) — NN
  • MID (아이디) — FK — Foreign key → MEMBER.MID — NOT NULL
  • NID (소설 번호) — FK — Foreign key → NOVEL.NID — NOT NULL

REPLY (댓글)

  • RID (댓글 번호) — PK — Primary key — NOT NULL
  • RCONTENT (댓글 내용) — NN
  • RDATE (댓글 작성일) — NN
  • MID (아이디) — FK — Foreign key → MEMBER.MID — NOT NULL
  • BID (게시글 번호) — FK — Foreign key → BOARD.BID — NOT NULL

REPLY_RE (대댓글)

  • RRID (대댓글 번호) — PK — Primary key — NOT NULL
  • RRCONTENT (대댓글 내용) — NN
  • RRDATE (대댓글 작성일) — NN
  • RID (댓글 번호) — FK — Foreign key → REPLY.RID — NOT NULL
  • MID (아이디) — FK — Foreign key → MEMBER.MID — NOT NULL
  • BID (게시글 번호) — FK — Foreign key → BOARD.BID — NOT NULL