테스트
테이블 (7)
ATTACHMENTS
- ATTACH_ID — NUMBER
- POST_ID — NUMBER — 외래 키 → POSTS.POST_ID — NOT NULL
- ORIGINAL_NAME — VARCHAR2(500) — NOT NULL
- STORED_NAME — VARCHAR2(500) — NOT NULL
- FILE_PATH — VARCHAR2(1000) — NOT NULL
- FILE_SIZE — NUMBER — NOT NULL — 파일
- MIME_TYPE — VARCHAR2(100)
- CREATED_AT — TIMESTAMP — NOT NULL
CATEGORIES
- CATEGORY_ID — NUMBER
- NAME — VARCHAR2(100) — NOT NULL
- DESCRIPTION — VARCHAR2(300)
- SORT_ORDER — NUMBER — NOT NULL
- IS_ACTIVE — NUMBER(1) — NOT NULL
COMMENTS
- COMMENT_ID — NUMBER
- POST_ID — NUMBER — 외래 키 → POSTS.POST_ID — NOT NULL
- USER_ID — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- PARENT_ID — NUMBER — 외래 키 → COMMENTS.COMMENT_ID
- CONTENT — VARCHAR2(2000) — NOT NULL
- IS_DELETED — NUMBER(1) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
LIKES
- LIKE_ID — NUMBER
- USER_ID — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- TARGET_TYPE — VARCHAR2(10) — NOT NULL
- TARGET_ID — NUMBER — NOT NULL — 대상
- CREATED_AT — TIMESTAMP — NOT NULL
POSTS
- POST_ID — NUMBER
- CATEGORY_ID — NUMBER — 외래 키 → CATEGORIES.CATEGORY_ID — NOT NULL
- USER_ID — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- TITLE — VARCHAR2(300) — NOT NULL
- CONTENT — CLOB — NOT NULL
- VIEW_COUNT — NUMBER — NOT NULL — 조회수
- LIKE_COUNT — NUMBER — NOT NULL — 좋아요
- IS_NOTICE — NUMBER(1) — NOT NULL — 공지
- IS_DELETED — NUMBER(1) — NOT NULL — 소프트
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
SESSIONS
- SESSION_ID — VARCHAR2(128)
- USER_ID — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- IP_ADDRESS — VARCHAR2(45)
- USER_AGENT — VARCHAR2(500)
- CREATED_AT — TIMESTAMP — NOT NULL
- EXPIRES_AT — TIMESTAMP — NOT NULL — 세션
USERS
- USER_ID — NUMBER
- EMAIL — VARCHAR2(255) — NOT NULL — 이메일
- PASSWORD — VARCHAR2(255) — NOT NULL — bcrypt
- NICKNAME — VARCHAR2(100) — NOT NULL — 닉네임
- ROLE — VARCHAR2(10) — NOT NULL — 권한:
- PROFILE_IMG — VARCHAR2(500) — 프로필
- IS_ACTIVE — NUMBER(1) — NOT NULL — 활성
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL