테스트

테이블 (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