mailplug

Tables (3)

Board (BOARD(게시판))

  • BOARD_ID (boardId) — int — Primary key — NOT NULL
  • BOARD_SJ (boardSj) — varchar2
  • BOARD_TYPE (boardType) — varchar2

Copy Of Poster (COMMENT(댓글))

  • Key (commentId) — int — Primary key — NOT NULL
  • BOARD_ID (boardId) — int — Foreign key → Poster.BOARD_ID — NOT NULL
  • POSTER_ID (posterId) — int — Foreign key → Poster.POSTER_ID — NOT NULL
  • BOARD_TYPE (commentCn) — varchar2
  • Field (wirter) — varchar2
  • Field2 (rgsDt) — date
  • Field3 (updDt) — date

Poster (POSTER(게시글))

  • POSTER_ID (posterId) — int — Primary key — NOT NULL
  • BOARD_ID (boardId) — int — Foreign key → Board.BOARD_ID — NOT NULL
  • BOARD_TYPE (posterSj) — varchar2
  • BOARD_SJ (posterCn) — varchar2
  • Field (wirter) — varchar2
  • Field2 (rgsDt) — date
  • Field3 (updDt) — date
  • Field4 (commentCnt) — int