point

Tables (3)

point

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • balance — INT — NOT NULL
  • last_transaction_id — BIGINT
  • created_date — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • last_modified_date — DATETIME(6)
  • last_modified_by — VARCHAR(100)

point_transaction

  • id — BIGINT — Primary key — NOT NULL
  • point_id — BIGINT — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • amount — INT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • expired_date — DATETIME(6)
  • used_amount — INT — NOT NULL
  • created_date — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • last_modified_date — DATETIME(6)
  • last_modified_by — VARCHAR(100)

point_transaction_link

  • id — BIGINT — Primary key — NOT NULL
  • accumulated_transaction_id — BIGINT — NOT NULL
  • used_transaction_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • created_date — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • last_modified_date — DATETIME(6)
  • last_modified_by — VARCHAR(100)