무료포인트 시스템

테이블 (4)

member

  • member_no — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_date — DATETIME(6)
  • modified_date — DATETIME(6)
  • created_by — VARCHAR(50)
  • modified_by — VARCHAR(50)

order

  • order_no — BIGINT
  • member_no — BIGINT — NOT NULL
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • created_date — DATETIME(6)
  • created_by — BIGINT

point_balance

  • point_no — BIGINT
  • member_no — BIGINT — NOT NULL
  • balance — DECIMAL(10, 2) — NOT NULL
  • expiry_date — DATETIME — NOT NULL
  • created_date — DATETIME(6)
  • modified_date — DATETIME(6)
  • created_by — BIGINT
  • modified_by — BIGINT

point_transaction

  • transaction_no — BIGINT
  • member_no — BIGINT — NOT NULL
  • order_no — BIGINT
  • type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • created_date — DATETIME(6)
  • created_by — BIGINT