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