포인트

테이블 (3)

POINT_CONFIG

  • config_key — VARCHAR(50)
  • config_value — VARCHAR(100) — NOT NULL

POINT_DETAIL

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • point_key — VARCHAR(100) — NOT NULL
  • original_amount — DECIMAL(19, 0) — NOT NULL
  • balance — DECIMAL(19, 0) — NOT NULL
  • is_manual — BOOLEAN
  • expire_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

POINT_LEDGER

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • detail_id — BIGINT — NOT NULL
  • trade_no — VARCHAR(100)
  • amount — DECIMAL(19, 0) — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP