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