spring-study-my

Tables (7)

admin_user_log (유저 이벤트로그)

  • Key (userEventLogIdn) — INT — Primary key — NOT NULL
  • Field (userIdn) — INT
  • Field (path) — VARCHAR
  • Field (regIp) — VARCAHR
  • Field (regDate) — DATETIME

cm_board_category (커뮤니티 카테고리)

  • Key (categoryIdn) — INT — Primary key — NOT NULL
  • Field (categoryType) — VARCHAR
  • Field2 (regDate) — DATETIME
  • Field3 (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN

cm_board_comment (게시글 댓글)

  • Key (commentIdn) — INT — Primary key — NOT NULL
  • Field (commentContent) — VARCHAR
  • Field (boardIdn) — INT
  • Field (userIdn) — INT
  • Field (regDate) — DATETIME
  • Field (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN

cm_board_item (커뮤니티 게시글)

  • Key (boardIdn) — INT — Primary key — NOT NULL
  • Field (boardName) — VARCHAR
  • Field (boardContent) — VARCHAR
  • Field (userIdn) — INT
  • Field (categoryIdn) — INT
  • Field (regDate) — DATETIME
  • Field (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN

cm_board_recomment (게시글 대댓글)

  • Key (recommentIdn) — INT — Primary key — NOT NULL
  • Field (recommentContent) — VARCHAR
  • Field (commentIdn) — INT
  • Field (userIdn) — INT
  • Field (regDate) — DATETIME
  • Field (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN

cm_item_count (게시글 조회 관련)

  • Key (itemInfoIdn) — INT — Primary key — NOT NULL
  • Field (itemIdn) — INT
  • Field (itemViewCnt) — INT
  • Field (regDate) — DATETIME
  • Field (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN

cm_user (커뮤니티 유저)

  • Key (userIdn) — INT — Primary key — NOT NULL
  • Field (userName) — VARCHAR
  • Field2 (userNickname) — VARCHAR
  • Field3 (userId) — VARCHAR
  • Field (userPW) — INT
  • Field (regDate) — DATETIME
  • Field (updtDate) — DATETIME
  • Field (delYn) — BOOLEAN