BREATH ERD1

Tables (28)

Address (주소)

  • id (주소id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • city (시/도) — VARCHAR(20) — NOT NULL
  • district (행정구역) — VARCHAR(20)
  • street (동) — VARCHAR(255) — NOT NULL

bookmark (스크랩문서)

  • bookmark_id (스크랩id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

category (카테고리)

  • id (카테고리id) — BIGINT — Primary key — NOT NULL
  • parent_id (부모카테고리id) — BIGINT
  • category_name (분류명)
  • step (단계) — INT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

character (캐릭터)

  • character_id (캐릭터id) — BIGINT — Primary key — NOT NULL
  • author_id (작성자id) — BIGINT — Foreign key → user.id — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • related_work_id (작품id) — BIGINT — NOT NULL
  • name (이름) — VARCHAR(100) — NOT NULL
  • is_original (원작인물여부) — NOT NULL
  • description (설명) — TEXT
  • display_order (노출순서) — BIGINT — NOT NULL
  • del_yn (삭제여부) — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

character_gallery (캐릭터갤러리)

  • gallery_id (갤러리id) — BIGINT — Primary key — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • image_url (이미지url) — VARCHAR(500) — NOT NULL
  • display_order (정렬순서) — BIGINT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

character_relation (캐릭터관계)

  • relation_id (관계id) — BIGINT — Primary key — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • target_character_id (대상캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • description (관계설명) — ENUM
  • display_order (정렬순서) — BIGINT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

character_stat (캐릭터스탯)

  • stat_id (스탯id) — BIGINT — Primary key — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • name (항목명) — TEXT — NOT NULL
  • stat_value (수치값) — BIGINT
  • display_order (정렬순서) — BIGINT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

comment (댓글)

  • id (댓글id) — BIGINT — Primary key — NOT NULL
  • id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • id (회원id) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • id (회원id2) — BIGINT — Foreign key → user.id — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL

comment_like (댓글좋아요)

  • id (댓글좋아요id) — BIGINT — Primary key — NOT NULL
  • id (댓글id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (회원id3) — BIGINT — Foreign key → user.id — NOT NULL
  • id (피드id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (회원id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (회원id2) — BIGINT — Foreign key → comment.id — NOT NULL

company_info (기업소개)

  • id (소개id) — BIGINT — Primary key — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

document (역사문서)

  • id (문서id) — BIGINT — Primary key — NOT NULL
  • origin_document_id (수정전원본id) — BIGINT
  • author_id (작성자id) — BIGINT — Foreign key → user.id — NOT NULL
  • category_id (카테고리id) — BIGINT — Foreign key → category.id — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • summary (개요) — TEXT — NOT NULL
  • status (상태) — ENUM — NOT NULL
  • profile_image (프로필이미지) — VARCHAR(255)
  • reliability (권한) — VARCHAR(50)
  • rejection_reason (거절사유) — VARCHAR(255)
  • blocked_reason (계정정지사유) — VARCHAR(255)
  • del_yn (삭제여부) — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

document_alias (이명)

  • id (이명id) — BIGINT — Primary key — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • alias (다른이름) — VARCHAR(100) — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

document_section (섹션)

  • section_id (섹션id) — BIGINT — Primary key — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (본문) — TEXT
  • display_order (정렬순서) — INT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • Field (논쟁여부)

feeLog (회비장부)

  • id (회비id) — BIGINT — Primary key — NOT NULL
  • email (유저이메일) — VARCHAR(100) — NOT NULL
  • amount (결제금액) — BIGINT
  • createdTume (결제 시간) — LocalDateTime — NOT NULL
  • status (결제상태) — ENUM — NOT NULL

feed (피드)

  • id (피드id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • content (게시글) — TEXT
  • create_time (생성일)

feed_image (피드사진)

  • id (이미지id) — BIGINT — Primary key — NOT NULL
  • feed_id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • (회원id) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • image_url (이미지url) — VARCHAR(500)
  • sequence (사진정렬) — INT

feed_like (피드좋아요)

  • id (좋아요id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • (회원id2) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • (크루id2) — BIGINT — Foreign key — NOT NULL
  • (크루장id2) — BIGINT — Foreign key — NOT NULL
  • create_time (생성시간) — LOCALDATE

notification (알림)

  • id (알림id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • type (알림유형) — VARCHAR(30) — NOT NULL
  • message (내용) — VARCHAR(255) — NOT NULL
  • is_read (읽음여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • reference_type (대상유형) — VARCHAR(20) — NOT NULL
  • reference_id (대상id) — BIGINT — NOT NULL

notification_setting (알림설정)

  • id (설정id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • type (알림유형) — VARCHAR(30) — NOT NULL
  • message (내용) — VARCHAR(255) — NOT NULL
  • is_read (읽음여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • reference_type (대상유형) — VARCHAR(20) — NOT NULL
  • reference_id (대상id) — BIGINT — NOT NULL

reFundLog (환불장부)

  • id (환불id) — BIGINT — Primary key — NOT NULL
  • imp_uid (포트원결제고유번호) — VARCHAR(100) — NOT NULL
  • amount (환불금액) — BIGINT
  • status (승인상태) — ENUM
  • refund_type (정산상태) — ENUM
  • refundreason (환불사유) — VARCHAR(100)

recent_view_document (최근본문서)

  • view_id (열람id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

related_work (관련작품)

  • id (소개id) — BIGINT — Primary key — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • title (제목) — TEXT — NOT NULL
  • description (소개) — TEXT
  • link_url (링크) — TEXT
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

report (신고)

  • id (신고id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • report_type (신고유형) — enum — NOT NULL
  • target_id (대상id) — BIGINT — NOT NULL
  • reason_text (신고내용) — VARCHAR(500)
  • status (신고상태) — enum — NOT NULL
  • create_at (신고일) — DATETIME — NOT NULL

settlementLog (정산로그)

  • id (정산id) — BIGINT — Primary key — NOT NULL
  • host_id (정산받을id) — BIGINT — Foreign key → user.id — NOT NULL
  • amount (정산금액) — BIGINT — NOT NULL
  • isSettled (정산승인) — ENUM — NOT NULL
  • bankName (보낸 은행) — VARCHAR(100) — NOT NULL
  • accountNumber (보낸계좌) — VARCHAR(100) — NOT NULL

source (출처)

  • id (출처id) — BIGINT — Primary key — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • source_name (사료명) — VARCHAR(255) — NOT NULL
  • link_url (링크) — VARCHAR(500)
  • source_type (유형) — VARCHAR(50)
  • footnote_number (각주번호) — INT — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

user (회원)

  • id (회원id) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(255)
  • nickName (닉네임) — VARCHAR(50) — NOT NULL
  • profile_image (프로필이미지) — VARCHAR(255)
  • role (권한) — ENUM — NOT NULL
  • provider (로그인유형) — ENUM — NOT NULL
  • account_status (계정상태) — ENUM — NOT NULL
  • blocked_reason (계정정지사유) — VARCHAR(255)
  • del_yn (삭제여부) — NOT NULL
  • provider_id (소셜id) — BIGINT — NOT NULL
  • gender (성별) — ENUM — NOT NULL
  • birthDate (생년월일) — LocalDate — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

user_interest_category (회원관심카테고리)

  • id (관심id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • category_id (카테고리id) — BIGINT — Foreign key → category.id — NOT NULL

wiki_link (위키링크)

  • link_id (링크id) — BIGINT — Primary key — NOT NULL
  • from_document_id (출발문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • to_document_id (도착문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME