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