bob
Tables (24)
bookcase_items (책장_품목)
- id (ID) — bigint — Primary key — NOT NULL
- status (상태(품질)) — enum — NOT NULL
- member_id (회원 ID) — binary(16) — NOT NULL
- book_id (책 ID) — bigint — NOT NULL
- usage_id (사용처 ID) — bigint
- deleted_at (삭제시각) — datetime(6)
books (책)
- id (ID) — bigint — Primary key — NOT NULL
- isbn (ISBN13) — varchar(13) — NOT NULL
- title (제목) — varchar(200) — NOT NULL
- author (저자) — varchar(200) — NOT NULL
- description (설명) — varchar(255) — NOT NULL
- price_standard (가격) — int — NOT NULL
- cover (표지) — varchar(255) — NOT NULL
- pub_date (출간일) — date — NOT NULL
categories (도서 카테고리)
- id (ID) — int — Primary key — NOT NULL
- parent_id (부모 카테고리 ID) — int — Foreign key → categories.id
- name (카테고리명) — varchar(20) — NOT NULL
chat_messages (채팅방_메시지)
- id (ID) — bigint — Primary key — NOT NULL
- chatroom_id (채팅방 ID) — bigint — Foreign key → chatrooms.id — NOT NULL
- sender_id (발신자 ID) — binary(16) — NOT NULL
- type (채팅 종류) — enum — NOT NULL
- content (내용) — varchar(500)
- created_at (생성시각) — datetime(6) — NOT NULL
chatroom_members (채팅방_회원)
- id (ID) — bigint — Primary key — NOT NULL
- chatroom_id (채팅방 ID) — bigint — Foreign key → chatrooms.id — NOT NULL
- member_id (참여자 ID) — binary(16) — NOT NULL
- last_read_message_id (마지막으로 읽은 메시지 ID) — bigint
- entered_at (입장시각) — datetime(6) — NOT NULL
- exited_at (퇴장시각) — datetime(6)
chatrooms (채팅방)
- id (ID) — bigint — Primary key — NOT NULL
- post_id (게시글 ID) — bigint — NOT NULL
- trade_id (거래 ID) — bigint — NOT NULL
- title_suffix (제목 접두사) — varchar(100) — NOT NULL
- last_chat_message (마지막 채팅메시지 ID) — varchar(255)
- last_chat_at (마지막 채팅시각) — datetime(6)
- created_at (생성시각) — datetime(6) — NOT NULL
emd_areas (읍/면/동)
- id (ID) — int — Primary key — NOT NULL
- sigg_area_id (시/군/구 ID) — int — Foreign key → sigg_areas.id — NOT NULL
- adm_code (지역코드) — varchar(10) — NOT NULL
- geom (지역위치(경계)) — geometry — NOT NULL
- name (지역명) — varchar(50) — NOT NULL
files (파일)
- id (ID) — bigint — Primary key — NOT NULL
- domain (참조 도메인) — enum — NOT NULL
- reference_id (참조 도메인 ID) — varchar(255)
- uploader (올린이) — binary(16) — NOT NULL
- name (이름) — varchar(255) — NOT NULL
- sequence (순서) — int
- created_at (생성시각) — datetime(6) — NOT NULL
filter_words (비속어)
- id (ID) — bigint — Primary key — NOT NULL
- word (비속어) — varchar(100) — NOT NULL
- predefined (사전 정의) — bit(1) — NOT NULL
- created_at (생성시각) — datetime(6) — NOT NULL
inquiries (문의)
- id (ID) — bigint — Primary key — NOT NULL
- status (문의 처리 상태) — enum — NOT NULL
- email (문의자 이메일) — varchar(150) — NOT NULL
- title (문의 제목) — varchar(50) — NOT NULL
- content (문의 내용) — varchar(200) — NOT NULL
- reply (문의 답변) — varchar(2000)
- manager_id (처리자 ID) — binary(16)
- created_at (생성시각) — datetime(6) — NOT NULL
- processed_at (처리시각) — datetime(6)
interests (관심사)
- id (ID) — bigint — Primary key — NOT NULL
- name (관심사 이름(정규화)) — varchar(20) — NOT NULL
member_areas (회원_활동지역)
- id (ID) — bigint — Primary key — NOT NULL
- emd_id (읍/면/동 ID) — int — NOT NULL
- authenticated_at (인증시각) — date — NOT NULL
member_interests (회원_관심사(키워드))
- id (ID) — bigint — Primary key — NOT NULL
- member_id (회원 ID) — binary(16) — Foreign key → members.id — NOT NULL
- interest_id (관심사 ID) — bigint — NOT NULL
- display_name (관심사 이름) — varchar(20) — NOT NULL
member_wishes (회원_희망품목)
- id (ID) — bigint — Primary key — NOT NULL
- member_id (회원 ID) — binary(16) — Foreign key → members.id — NOT NULL
- book_id (책 ID) — bigint — NOT NULL
members (회원)
- id (ID) — binary(16) — Primary key — NOT NULL
- area_id (활동지역 ID) — bigint — Foreign key → member_areas.id — NOT NULL
- role (역할) — enum('USER', 'ADMIN') — NOT NULL
- provider (openId 제공자) — enum('GOOGLE','NAVER')
- status (활성상태) — enum — NOT NULL
- email (이메일) — varchar(150) — NOT NULL
- password (패스워드) — varchar(200)
- nickname (별명) — varchar(100) — NOT NULL
- profile_image_url (프로필 이미지) — varchar(255)
- last_active_at (최근 활동시각) — datetime(6)
- created_at (생성시각) — datetime(6) — NOT NULL
- memo (관리자 메모) — varchar(200)
notifications (알림)
- id (ID) — bigint — Primary key — NOT NULL
- type (알림 종류) — enum — NOT NULL
- receiver_id (받는이) — binary(16) — NOT NULL
- reference_id (참조 도메인 ID) — varchar(255)
- body (내용) — varchar(255) — NOT NULL
- is_read (읽기여부) — bit(1) — NOT NULL
- created_at (생성시각) — datetime(6) — NOT NULL
post_favorites (게시글_찜)
- id (ID) — bigint — Primary key — NOT NULL
- post_id (게시글 ID) — bigint — Foreign key → posts.id — NOT NULL
- member_id (찜한 회원 ID) — binary(16) — NOT NULL
post_filter_words (게시글_비속어)
- id (ID) — bigint — Primary key — NOT NULL
- post_id (게시글 ID) — bigint — Foreign key → posts.id — NOT NULL
- word (비속어) — varchar(20) — NOT NULL
posts (게시글)
- id (ID) — bigint — Primary key — NOT NULL
- status (활성상태) — enum — NOT NULL
- category_id (카테고리 ID) — int — NOT NULL
- book_id (책 ID) — bigint — NOT NULL
- book_status (책 상태(품질)) — enum — NOT NULL
- title (제목) — varchar(50) — NOT NULL
- description (설명) — varchar(200)
- price (가격) — int — NOT NULL
- thumbnail_url (썸네일) — varchar(255) — NOT NULL
- writer_id (작성자 ID) — binary(16) — NOT NULL
- writer_book_id (작성자 책장 품목 ID) — bigint — NOT NULL
- registration_area_id (등록지 ID) — int — NOT NULL
- trade_progress (거래 진행 상태) — enum — NOT NULL
- view_count (조회수) — int — NOT NULL
- scrap_count (찜수) — int — NOT NULL
- wish_only (희망도서 제한여부) — bit(1) — NOT NULL
- created_at (생성시각) — datetime(6) — NOT NULL
reports (신고)
- id (ID) — bigint — Primary key — NOT NULL
- status (신고 처리 상태) — enum — NOT NULL
- target (신고 유형) — enum — NOT NULL
- target_id (신고 유형 ID) — bigint — NOT NULL
- reason (신고 사유) — varchar(20) — NOT NULL
- reporter_id (신고자 ID) — binary(16) — NOT NULL
- reported_id (피신고자 ID) — binary(16) — NOT NULL
- manager_id (처리자 ID) — binary(16)
- created_at (생성시각) — datetime(6) — NOT NULL
- processed_at (처리시각) — datetime(6)
sido_areas (행정구역(시/도))
- id (ID) — int — Primary key — NOT NULL
- adm_code (지역코드) — varchar(2) — NOT NULL
- name (지역명) — varchar(50) — NOT NULL
sigg_areas (행정구역(시/군/구))
- id (ID) — int — Primary key — NOT NULL
- sido_area_id (시/도 ID) — int — Foreign key → sido_areas.id — NOT NULL
- adm_code (지역코드) — varchar(5) — NOT NULL
- name (지역명) — varchar(50) — NOT NULL
trade_item (거래_품목)
- id (ID) — bigint — Primary key — NOT NULL
- trade_id (거래 ID) — bigint — Foreign key → trades.id — NOT NULL
- item_id (책장 품목 ID) — bigint — NOT NULL
- owner (소유자) — enum — NOT NULL
- created_at (생성시각) — datetime(6) — NOT NULL
trades (거래)
- id (ID) — bigint — Primary key — NOT NULL
- status (활성상태) — enum — NOT NULL
- post_id (게시글 ID) — bigint — NOT NULL
- seller_id (판매자 ID) — binary(16) — NOT NULL
- buyer_id (구매자 ID) — binary(16) — NOT NULL
- is_far (먼 거리여부) — bit(1) — NOT NULL
- created_at (생성시각) — datetime(6) — NOT NULL
- updated_at (수정시각) — datetime(6) — NOT NULL