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