BREATH ERD

Tables (26)

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

category_history (카테고리 이력)

  • id (카테고리이력id) — BIGINT — Primary key — NOT NULL
  • category_id (카테고리id) — BIGINT — Foreign key → category.id — NOT NULL
  • action (액션) — ENUM — NOT NULL
  • before_value (이전값) — VARCHAR(300)
  • after_value (이후값) — VARCHAR(300)
  • changed_by (처리자id) — BIGINT — Foreign key → user.id — 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
  • related_work_id (작품id) — BIGINT — NOT NULL
  • name (이름) — VARCHAR(100) — NOT NULL
  • description (설명) — TEXT
  • display_order (노출순서) — BIGINT — NOT NULL
  • del_yn (삭제여부) — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

character_favorite (캐릭터 즐겨찾기)

  • favorite_id (즐겨찾기id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → document.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

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_history (캐릭터이력)

  • id (이력id) — BIGINT — Primary key — NOT NULL
  • character_id (캐릭터id) — BIGINT — Foreign key → character.character_id — NOT NULL
  • action (액션) — ENUM — NOT NULL
  • reason (사유) — VARCHAR(500)
  • changed_by (처리자id) — BIGINT — Foreign key → user.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

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

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_history (문서이력)

  • id (문서이력id) — BIGINT — Primary key — NOT NULL
  • document_id (문서id) — BIGINT — Foreign key → document.id — NOT NULL
  • action (액션) — ENUM — NOT NULL
  • before_status (이전상태) — ENUM
  • after_status (이후상태) — ENUM
  • reason (사유) — VARCHAR(500)
  • changed_by (처리자id) — BIGINT — Foreign key → user.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

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

info (소개)

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

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 (알림유형) — ENUM — NOT NULL
  • is_enabled (수신여부) — BOOLEAN — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

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
  • 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
  • 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
  • birthDate (생년월일) — LocalDate
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME

user_history (회원이력)

  • id (카테고리이력id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • action (액션) — ENUM — NOT NULL
  • before_value (이전값) — VARCHAR(300)
  • after_value (이후값) — VARCHAR(300)
  • reason (사유) — VARCHAR(500)
  • changed_by (처리자id) — BIGINT — Foreign key → user.id — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL

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