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