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