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