kt-market

테이블 (6)

상품 (product)

  • Key (product_id) — Int — 기본 키 — NOT NULL
  • Field (name) — Varchar — NOT NULL
  • Field2 (price) — Int — NOT NULL
  • Field (stock) — Int — NOT NULL
  • Field2 (type) — Enum — NOT NULL
  • Field (created_date) — DateTime — NOT NULL
  • Field2 (modified_date) — DateTime — NOT NULL

영수증 (receipt)

  • Key (receipt_id) — Int — 기본 키 — NOT NULL
  • Field (member_id) — Int — NOT NULL
  • Field2 (status) — Enum — NOT NULL
  • Field3 (use_point) — Int — NOT NULL
  • Field (created_date) — DateTime — NOT NULL
  • Field2 (modified_date) — DateTime — NOT NULL

영수증 아이템 (receipt_item)

  • Key (receipt_item_id) — Int — 기본 키 — NOT NULL
  • Key (receipt_id) — Int — 외래 키 → 영수증.Key — NOT NULL
  • Field (product_id) — Int — NOT NULL
  • Field2 (product_name) — Varchar — NOT NULL
  • Field3 (product_price) — Int — NOT NULL
  • Field (quantity) — Int — NOT NULL
  • Field2 (created_date) — DateTime — NOT NULL
  • Field (modified_date) — DateTime — NOT NULL

회원 (member)

  • 키 (member_id) — Int — 기본 키 — NOT NULL
  • (member_point_id) — Int — 외래 키 → 회원 포인트.member_point_id — NOT NULL
  • (user_id) — Varchar — NOT NULL
  • (password) — Varchar — NOT NULL
  • (role) — Varchar — NOT NULL
  • (grade) — Enum — NOT NULL
  • Field (created_date) — DateTime — NOT NULL
  • Field (modified_date) — DateTime

회원 포인트 (member_point)

  • (member_point_id) — Int — 기본 키 — NOT NULL
  • (available_point) — Int — NOT NULL
  • (accumulated_point) — Int — NOT NULL
  • Field (created_date) — DateTime — NOT NULL
  • Field2 (modified_date) — DateTime — NOT NULL

회원 포인트 아이템 (member_point_item)

  • (member_point_item_id) — Int — 기본 키 — NOT NULL
  • (member_point_id) — Int — 외래 키 → 회원 포인트.member_point_id — NOT NULL
  • (point) — Int — NOT NULL
  • (type) — Enum — NOT NULL
  • Field (created_date) — DateTime — NOT NULL
  • Field2 (modified_date) — DateTime — NOT NULL