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) — 선택한 설문 문항 조합