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