Erd 1안
테이블 (12)
card_products (카드상품)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- issuer (카드사) — VARCHAR(50) — NOT NULL
- name (카드_이름) — VARCHAR(100) — NOT NULL
- annual_fee (연회비) — INT
- image_url (카드_이미지) — VARCHAR(255)
- terms_url (공식_페이지) — VARCHAR(255)
- benefits (혜택_목록) — JSON — NOT NULL
- conditions (이용_조건) — VARCHAR(255)
- is_recommended (추천_가능_여부) — BOOLEAN — NOT NULL
- checked_at (조건_확인일) — DATE
couples (커플)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- bride_id (신부_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- groom_id (신랑_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- status (연결_상태) — ENUM('대기','연결','해제') — NOT NULL
- groom_ratio (신랑_분담률) — INT — NOT NULL
- bride_ratio (신부_분담률) — INT — NOT NULL
- connected_at (연결_일시) — TIMESTAMP
- created_at (생성_일시) — TIMESTAMP — NOT NULL
financial_accounts (금융수단)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- user_id (사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- provider_key (마이데이터_식별키) — VARCHAR(255) — NOT NULL
- account_type (금융수단_구분) — ENUM('계좌','카드') — NOT NULL
- institution (금융회사) — VARCHAR(100) — NOT NULL
- display_name (표시_이름) — VARCHAR(100) — NOT NULL
- balance (잔액) — BIGINT
- status (연동_상태) — ENUM('연결','해제') — NOT NULL
- linked_at (연동_일시) — TIMESTAMP — NOT NULL
goal_items (목표항목)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- goal_id (결혼목표_아이디) — BIGINT — 외래 키 → wedding_goals.id — NOT NULL
- category (준비_카테고리) — ENUM('예식장','스튜디오','드레스','메이크업','예비비','신혼여행','기타') — NOT NULL
- priority (중요도) — INT — NOT NULL
- min_amount (희망_최소금액) — BIGINT
- max_amount (희망_최대금액) — BIGINT
- target_amount (목표_금액) — BIGINT — NOT NULL
- current_amount (실제_결제금액) — BIGINT — NOT NULL
- included_in_budget (예산_포함_여부) — BOOLEAN — NOT NULL
- is_completed (계약_완료_여부) — BOOLEAN — NOT NULL
invitations (커플초대)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- inviter_id (초대한_사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- invitee_id (초대받은_사용자_아이디) — BIGINT
- invite_code (초대_코드) — VARCHAR(30) — NOT NULL
- status (초대_상태) — ENUM('생성','요청','수락','거절','만료') — NOT NULL
- expired_at (만료_일시) — DATETIME — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
notifications (알림)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- user_id (사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- type (알림_유형) — ENUM('커플초대','목표변경','시안요청','미션','시스템') — NOT NULL
- title (제목) — VARCHAR(100) — NOT NULL
- content (내용) — TEXT — NOT NULL
- is_read (읽음_여부) — BOOLEAN — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
records (거래내역)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- user_id (사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- goal_item_id (목표항목_아이디) — BIGINT
- account_id (금융수단_아이디) — BIGINT
- record_scope (내역_구분) — ENUM('결혼비용','개인소비') — NOT NULL
- type (거래_유형) — ENUM('수입','지출','저축') — NOT NULL
- category (카테고리) — VARCHAR(50) — NOT NULL
- merchant (거래명) — VARCHAR(100) — NOT NULL
- amount (금액) — BIGINT — NOT NULL
- record_date (거래_일자) — DATE — NOT NULL
- memo (메모) — TEXT
- input_method (입력_방식) — ENUM('마이데이터','직접입력') — NOT NULL
- created_at (생성_일시) — TIMESTAMP — NOT NULL
- updated_at (수정_일시) — TIMESTAMP — NOT NULL
saving_missions (절약미션)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- user_id (사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- category (지출_카테고리) — VARCHAR(50) — NOT NULL
- title (미션_제목) — VARCHAR(100) — NOT NULL
- method (행동_방법) — VARCHAR(255) — NOT NULL
- expected_saving (예상_절감액) — BIGINT — NOT NULL
- status (미션_상태) — ENUM('추천','도전중','완료','취소') — NOT NULL
- start_date (시작_일자) — DATE
- end_date (종료_일자) — DATE
- created_at (생성_일시) — TIMESTAMP — NOT NULL
terms_agreements (약관동의)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- user_id (사용자_아이디) — BIGINT — 외래 키 → users.id — NOT NULL
- terms_type (약관_유형) — ENUM('이용약관','개인정보','마이데이터') — NOT NULL
- agreed (동의_여부) — BOOLEAN — NOT NULL
- agreed_at (동의_일시) — TIMESTAMP
users (사용자)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- password_hash — VARCHAR(255)
- name (이름) — VARCHAR(30) — NOT NULL
- nickname (닉네임) — nickname
- phone (휴대폰_번호) — VARCHAR(20)
- profile_image — VARCHAR(255)
- provider (로그인_방식) — ENUM('일반','카카오','네이버') — NOT NULL
- role (역할) — role
- annual_income (세후_연소득) — BIGINT
- total_assets — BIGINT
- share_level (공개_범위) — ENUM('전체공개','요약공개','비공개') — NOT NULL
- created_at (생성_일시) — created_at — NOT NULL
- updated_at (수정_일시) — TIMESTAMP — NOT NULL
wedding_goals (결혼목표)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- couple_id (커플_아이디) — BIGINT — 외래 키 → couples.id — NOT NULL
- creator_id (작성자_아이디) — BIGINT — NOT NULL
- draft_title (시안_제목) — VARCHAR(100) — NOT NULL
- wedding_date (결혼_예정일) — DATE
- wedding_region (준비_지역) — VARCHAR(100)
- budget_type (예산_유형) — ENUM('알뜰형','균형형','플렉스형')
- total_budget (총_결혼예산) — BIGINT — NOT NULL
- draft_status (시안_상태) — ENUM('작성중','검토중','확정','거절') — NOT NULL
- is_main (메인_시안_여부) — BOOLEAN — NOT NULL
- created_at (wedding_goals) — notifications — NOT NULL
- updated_at (수정_일시) — TIMESTAMP — NOT NULL
wedding_statistics (결혼통계)
- id (아이디) — BIGINT — 기본 키 — NOT NULL
- region (지역) — VARCHAR(100) — NOT NULL
- category (준비_카테고리) — VARCHAR(50) — NOT NULL
- average_cost (평균_비용) — BIGINT — NOT NULL
- minimum_cost (최소_비용) — BIGINT
- maximum_cost (최대_비용) — BIGINT
- base_year (기준_연도) — INT — NOT NULL
- source_url (데이터_출처) — VARCHAR(255)
- updated_at (갱신일) — DATE