ReadOur

테이블 (18)

post_tag

  • post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
  • tag_id — BIGINT — 외래 키 → tag.tag_id — NOT NULL

tag

  • tag_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL

게시글 (post)

  • post_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • book_id — BIGINT — 외래 키 → 책.book_id
  • chat_room_id — BIGINT
  • category — ENUM('REVIEW', 'FREE', 'MEETING') — NOT NULL
  • content — TEXT — NOT NULL
  • is_spoiler — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • is_hidden — BOOLEAN — NOT NULL
  • hit — BIGINT — NOT NULL

게시글 내 도서 주의사항 (post_warning)

  • warning — ENUM( 'VIOLENCE', 'SEXUAL', 'ABUSE', 'SUICIDE', 'DEATH', 'DRUG', 'BODY_HORROR', 'SENSITIVE_TOPIC' ) — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL

게시글 좋아요 (post_like)

  • post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

댓글 (comment)

  • comment_id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • is_hidden — BOOLEAN — NOT NULL

댓글 좋아요 (comment_like)

  • comment_id — BIGINT — 외래 키 → 댓글.comment_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

신고 (report)

  • report_id — BIGINT — 기본 키 — NOT NULL
  • user_id (reporter_id) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • target_type — ENUM('POST','COMMENT','CHAT_MESSAGE') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason_code — ENUM('SPAM','HARASSMENT','HATE','SEXUAL','ILLEGAL','OTHER') — NOT NULL
  • reason_text — VARCHAR(1000)
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — idx_report_target_time

알림 (notification)

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • type — ENUM( 'NEW_COMMENT','NEW_REPLY','NEW_LIKE', 'MENTION','POST_HIDDEN','COMMENT_HIDDEN', 'CHAT_MESSAGE','CHAT_ANNOUNCEMENT', 'CAL_EVENT_CREATE','CAL_EVENT_UPDATE','CAL_EVENT_DELETE', 'POLL_CREATED','POLL_RESULT', 'BOOK_AVAILABLE' ) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • message — VARCHAR(1000)
  • link_url — VARCHAR(512)
  • target_type — ENUM('POST','COMMENT','CHAT_ROOM','EVENT','BOOK','USER', 'POLL')
  • target_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • read_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL

유저 (user)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED','BANNED','DELETED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

유저 관심 도서관 (user_interested_library)

  • libCode — VARCHAR(50) — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

책 (book)

  • book_id — BIGINT — 기본 키 — NOT NULL
  • isbn10 — VARCHAR(20)
  • isbn13 — VARCHAR(20)
  • addition_symbol — VARCHAR(16)
  • vol — VARCHAR(32)
  • bookname — VARCHAR(512) — NOT NULL
  • authors — VARCHAR(1000)
  • publisher — VARCHAR(255)
  • publication_date — DATE
  • publication_year — INT
  • class_no — VARCHAR(50)
  • class_nm — VARCHAR(255)
  • description — TEXT
  • book_image_url — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

책 하이라이트 (book_highlight)

  • highlight_id — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • page_number — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • book_id — BIGINT — 외래 키 → 책.book_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL

책 한 줄 리뷰 (book_review)

  • review_id — BIGINT — 기본 키 — NOT NULL
  • book_id — BIGINT — 외래 키 → 책.book_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • rating — TINYINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

캘린더 (calendar)

  • calendar_id — BIGINT — 기본 키 — NOT NULL
  • user_id (owner_user_id) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • scope — ENUM('PERSONAL','COMMUNITY','CHAT_ROOM') — NOT NULL
  • related_room_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

캘린더 이벤트 (calendar_event)

  • event_id — BIGINT — 기본 키 — NOT NULL
  • calendar_id — BIGINT — 외래 키 → 캘린더.calendar_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • location — VARCHAR(200)
  • starts_at — DATETIME — NOT NULL
  • ends_at — DATETIME — NOT NULL
  • all_day — BOOLEAN — NOT NULL
  • user_id (created_by) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

파일 링크 (file_link)

  • target_type — ENUM('POST','COMMENT','CHAT_MESSAGE') — 기본 키 — NOT NULL
  • target_id — BIGINT — 기본 키 — NOT NULL
  • file_id — BIGINT — 외래 키 → 파일 에셋.file_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

파일 에셋 (file_asset)

  • file_id — BIGINT — 기본 키 — NOT NULL
  • user_id (owner_user_id) — BIGINT — 외래 키 → 유저.user_id — NOT NULL
  • bucket — VARCHAR(128) — NOT NULL
  • object_key — VARCHAR(512) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • byte_size — BIGINT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL