final
Tables (7)
campaign (Untitled7)
- 캠페인아이디 (campaignID) — int — Primary key — NOT NULL
- 캠페인종류 (type) — varchar(50)
- 캠페인시작날짜 (startDate) — date
- 캠페인종료날짜 (endDate) — date
- 타겟팅분류 (TargeSegment) — varchar(50)
- 상품아이디 (productID) — int — Foreign key → product.상품아이디 — NOT NULL
coupon (Untitled3)
- 쿠폰아이디 (couponID) — int — Primary key — NOT NULL
- 발행날짜 (issuedDate) — date
- 만료날짜 (expiryDate) — date
- 사용여부 (useStatus) — boolean
- 고객아이디 (customerID) — int — Foreign key → customer.고객아이디 — NOT NULL
- 구매아이디 (purchaseID) — int — Foreign key → purchase.구매아이디 — NOT NULL
customer (Untitled)
- 고객아이디 (customerID) — int — Primary key — NOT NULL
- 고객이름 (name) — varchar(50)
- 고객나이 (age) — int
- 고객성별 (gender) — varchar(10)
- 고객번호 (phoneNumber) — int
pos (Untitled5)
- 포스아이디 (posID) — int — Primary key — NOT NULL
- 지점아이디 (storeID) — int
- 구매날짜 (purchaseTime) — dateime
- 구매아이디 (purchaseID) — int — Foreign key → purchase.구매아이디 — NOT NULL
product (Untitled6)
- 상품아이디 (productID) — int — Primary key — NOT NULL
- 상품이름 (name) — varchar(100)
- 상품가격 (price) — int
- 상품브랜드 (brand) — varchar(50)
- 상품카테고리 (category) — varchar(50)
purchase (Untitled2)
- 구매아이디 (purchaseID) — int — Primary key — NOT NULL
- 구매날짜 (purchaseDate) — date
- 구매 개수 (amount) — int
- 온라인/오프라인 구분 (online) — boolean
- 고객아이디 (customerID) — int — Foreign key → customer.고객아이디 — NOT NULL
- 상품아이디 (productID) — int — Foreign key → product.상품아이디 — NOT NULL
- 캠페인아이디 (campaignID) — int — Foreign key → campaign.캠페인아이디 — NOT NULL
segment (Untitled4)
- 세분화아이디 (segmentID) — int — Primary key — NOT NULL
- 세분화 기준 (criteria) — varchar(50)
- 고객아이디 (customerID) — int — Foreign key → customer.고객아이디 — NOT NULL