board-system
Tables (4)
COMMENTS (댓글)
- COMMENTS_ID (댓글 ID) — VARCHAR(50) — Primary key — NOT NULL
- POST_ID (게시판 ID) — VARCHAR(50) — Foreign key → POSTS.POSTS_ID — NOT NULL
- CONTENT (댓글내용) — VARCHAR — NOT NULL
- AUTHOR (댓글작성자) — VARCHAR(100) — NOT NULL
- STATUS (댓글 상태) — VARCHAR(20) — NOT NULL
- PARENT_COMMENT_ID (부모 댓글 ID) — VARCHAR(50) — NULL일 경우 최상위 댓글 의미
- CREATED_AT (생성일자) — DATE — NOT NULL
- UPDATED_AT (수정일자) — DATE — NOT NULL
LIKE (좋아요)
- LIKE_ID (좋아요 ID) — VARCHAR(50) — Primary key — NOT NULL
- TARGET_ID (대상 ID) — VARCHAR(50) — Foreign key → POSTS.POSTS_ID — NOT NULL — TARGET_ID: 조건부 FK (Conditional Foreign Key) - POSTS.POSTS_ID (when TARGET_TYPE='POST') - COMMENTS.COMMENT_ID (when TARG…
- TARGET_ID (대상ID) — VARCHAR(50) — Foreign key → COMMENTS.COMMENTS_ID — NOT NULL
- TARGET_TYPE (대상 타입) — VARCHAR(6) — NOT NULL
- USERNAME (사용자명) — VARCHAR(50) — NOT NULL
- CREATED_AT (생성일자) — DATE — NOT NULL
POSTS (게시판)
- POSTS_ID (게시판 ID) — VARCHAR(50) — Primary key — NOT NULL
- TITLE (제목) — VARCHAR(200) — NOT NULL
- CONTENT (내용) — VARCHAR — NOT NULL
- AUTHOR (작성자) — VARCHAR(100) — NOT NULL
- VIEW_COUNT (조회수) — INTEGER
- CATEGORY (카테고리) — VARCHAR(50) — NOT NULL
- CREATED_AT (생성일자) — DATE — NOT NULL
- UPDATED_AT (수정일자) — DATE — NOT NULL
- COMMENT_COUNT (댓글개수) — NUMBER
User (사용자)
- USER_ID (사용자 ID) — VARCHAR(50) — Primary key — NOT NULL
- USER_NAME (사용자명) — VARCHAR(50) — NOT NULL — 유니크, 4~20자, 영문+숫자+언더스코어
- PASSWORD (비밀번호) — VARCHAR(50) — NOT NULL — BCrypt, 최소 8자
- EMAIL (이메일주소) — VARCHAR(50) — NOT NULL — 유니크, 이메일 형식
- NICKNAME (별명) — VARCHAR(50) — NOT NULL — 2~20자
- PROFILE_IMAGE (프로필사진) — VARCHAR(50)
- ROLE (권한) — VARCHAR(50) — NOT NULL — USER, ADMIN (기본값: USER)
- STATUS (사용자 상태) — VARCHAR(20) — NOT NULL — ACTIVE, INACTIVE, SUSPENDED
- CREATED_AT (가입일시) — DATE — NOT NULL
- UPDATED_AT (수정일시) — DATE — NOT NULL
- LAST_LOGIN_AT (마지막로그인) — DATE