7e12

Tables (19)

Account (계좌)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • final_ammount (최종 금액) — Long
  • account_type (계좌타입) — ENUM
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • member_id (멤버아이디) — Long — Foreign key → Member.id — NOT NULL

Brand (브랜드)

  • id (아이디) — Long — Primary key — NOT NULL
  • brand_name (브랜드이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • second_tag_id (두번째태그아이디) — Long — Foreign key → StuffTagSecond.second_tag_id — NOT NULL

BudgetInformation (예산정보)

  • id (아이디) — Long — Primary key — NOT NULL
  • meet_and_greet (상견례) — Long
  • studio (스튜디오) — Long
  • Field (결혼준비) — Long
  • wedding_ceremony (결혼식) — Long
  • robe (예복) — Long
  • gift (예물) — Long
  • honeymoon (신혼여행) — Long
  • house (집) — Long
  • Field (혼수s)
  • loan (대출) — Long

Couple (커플)

  • id (아이디) — Long — Primary key — NOT NULL
  • wedding_date (결혼날짜) — LocalDate
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

DepositAccount (예금계좌)

  • id (아이디) — Long — Primary key — NOT NULL
  • account_id (계좌아이디) — Long — Foreign key → Account.id — NOT NULL
  • maturity_date (만기일) — LocalDate
  • current_ammount (현재금액) — Long
  • maturity_amount (만기예상금액) — Long
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

Likes (좋아요)

  • id (아이디) — Primary key — NOT NULL
  • couple_id (커플아이디) — Long — Foreign key → Couple.id — NOT NULL
  • marriage_stuff_id (제품아이디) — Long — Foreign key → Stuff.id — NOT NULL
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

LoanProduct (대출상품)

  • id (아이디) — Long — Primary key — NOT NULL
  • dcls_month (상품공시월) — varchar(255)
  • fin_company (금융회사명) — varchar(255)
  • join_way (가입방법) — varchar(255)
  • loan_type (대출종류명) — varchar(255)
  • rate_name (금리명) — varchar(255)
  • rate_bottom (최저금리) — float
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

MarriagePolicy (신혼부부정책)

  • id (아이디) — Long — Primary key — NOT NULL
  • policy (정책) — varchar(255)
  • short_summary (요약) — varchar(255)
  • first_tag (첫번째태그) — varchar(255)
  • second_tag (두번째태그) — varchar(255)
  • url (링크) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

Member (사용자)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — varchar(255)
  • email (이메일) — varchar(255)
  • provider (카카오) — varchar(255)
  • provider_id (카카오 provider id) — varchar(255)
  • image (사진) — varchar(255)
  • role (역할) — ENUM
  • credit_score (신용점수) — float
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • couple_id (커플아이디) — Long — Foreign key → Couple.id — NOT NULL

Money (돈)

  • id (아이디) — Long — Primary key — NOT NULL
  • total_cash (총현금) — Long
  • total_account (총예적금) — Long
  • present_expenditure (현재까지지출) — Long
  • future_expenditure (미래지출) — Long
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • member_id (멤버아이디) — Long — Foreign key → Member.id — NOT NULL

MoneyExpenditure (지출)

  • id (아이디) — Long — Primary key — NOT NULL
  • date (거래날짜) — LocalDate
  • amount (금액) — Long
  • memo (메모) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • money_id (현금아이디) — Long — Foreign key → Money.id — NOT NULL
  • third_tag_id (태그아이디) — Long — Foreign key → TagThird.third_tag_id — NOT NULL

MoneyIncome (수입)

  • id (아이디) — Long — Primary key — NOT NULL
  • date (거래날짜) — LocalDate
  • amount (금액) — Long
  • memo (메모) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • cash_id (현금아이디) — Long — Foreign key → Money.id — NOT NULL

SavingsAccount (적금계좌)

  • id (아이디) — Long — Primary key — NOT NULL
  • account_id (계좌아이디) — Long — Foreign key → Account.id — NOT NULL
  • transfer_date (이체일) — LocalDate
  • transfer_amount (이체금액) — Long
  • maturity_date (만기일) — LocalDate
  • current_amount (현재금액) — Long
  • maturity_amount (만기예상금액) — Long
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

Stuff (제품)

  • id (아이디) — Long — Primary key — NOT NULL
  • title (상품명) — varchar(255)
  • link (링크) — varchar(255)
  • image (이미지링크) — varchar(255)
  • low_price (최저가) — varchar(255)
  • image_vector (이미지벡터) — varchar(255)
  • brand_id (브랜드아이디) — Long — Foreign key → Brand.id — NOT NULL

StuffTagFirst (첫번째태그)

  • first_tag_id (아이디) — Long — Primary key — NOT NULL
  • first_tag_name (태그이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

StuffTagSecond (두번째태그)

  • second_tag_id (아이디) — Long — Primary key — NOT NULL
  • second_tag_name (태그이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • first_tag_id (첫번째태그아이디) — Long — Foreign key → StuffTagFirst.first_tag_id — NOT NULL

TagFirst (첫번째 태그)

  • first_tag_id (아이디) — Long — Primary key — NOT NULL
  • first_tag_name (태그이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • couple_id (커플아이디) — Long — Foreign key → Couple.id — NOT NULL

TagSecond (두번째 태그)

  • second_tag_id (아이디) — Long — Primary key — NOT NULL
  • second_tag_name (태그이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • first_tag_id (첫번째태그아이디) — Long — Foreign key → TagFirst.first_tag_id — NOT NULL

TagThird (세번째 태그)

  • third_tag_id (아이디) — Long — Primary key — NOT NULL
  • third_tag_name (태그이름) — varchar(255)
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • second_tag_id (두번째태그아이디) — Long — Foreign key → TagSecond.second_tag_id — NOT NULL