Kurvey ERD

Tables (10)

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (selectionComboId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (userId) — varchar(45) — 로그인 ID
  • Field (name) — varchar(45) — 이름
  • Field (password) — varchar(45) — 비밀번호
  • Field (birthday) — date — 생년월일
  • Field (numberOfFamilies) — int — 가구원 수
  • Field (hasBaby) — Boolean — 영유아 존재 여부
  • Field (hasDog) — Boolean — 반려견 존재 여부
  • Field (hasCat) — Boolean — 반려묘 존재 여부
  • Field (hasPlant) — Boolean — 반려식물 존재 여부

Untitled (product)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (categoryId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(45) — 상품명
  • Field (description) — varchar(100) — 상품 한 줄 설명
  • Field (cost) — int — 금액
  • Field (deliveryType) — varchar(45) — 배송 유형
  • Field (....) — ... — ...

Untitled (category)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(45) — 카테고리 명

Untitled (lifeStyleQuestion)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (question) — varchar(45) — 문항

Untitled (LifeStyleAnswer)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (questionId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (priority) — int — 우선순위 점수

Untitled (purchase)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — timestamp — 구매 시간

Untitled (purchaseProduct)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (purchaseId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (productId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — int — 구매 수량

Untitled (priorityWeight)

  • Key (priority) — int — Primary key — NOT NULL
  • Field (weight) — int — 우선순위에 대한 가중치

Untitled (similarity)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (selectionComboId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (value) — int — 유사도

Untitled (selectionCombo)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (selection) — varchar(10) — 선택한 설문 문항 조합