point
Tables (7)
point_idempotency
- id — BIGINT — Primary key — NOT NULL
- transaction_type — VARCHAR(30) — NOT NULL
- request_id — VARCHAR(64) — NOT NULL
- point_operation_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_lot
- id — BIGINT — Primary key — NOT NULL
- point_operation_id — BIGINT — NOT NULL
- wallet_id — BIGINT — NOT NULL
- original_amount — BIGINT — NOT NULL
- remaining_amount — BIGINT — NOT NULL
- earn_type — VARCHAR(40) — NOT NULL
- expire_date — DATE — NOT NULL
- earn_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_lot_entry
- id — BIGINT — Primary key — NOT NULL
- point_lot_id — BIGINT — NOT NULL
- point_operation_id — BIGINT — NOT NULL
- transaction_type — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- lot_balance_after — BIGINT — NOT NULL
- transaction_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_operation
- id — BIGINT — Primary key — NOT NULL
- wallet_id — BIGINT — NOT NULL
- transaction_type — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- balance_after — BIGINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- display_description — VARCHAR(200)
- internal_memo — VARCHAR(500)
- order_id — VARCHAR(64)
- transaction_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_policy
- id — BIGINT — Primary key — NOT NULL
- policy_key — VARCHAR(40) — NOT NULL
- policy_value — BIGINT — NOT NULL
- effective_from — DATETIME(6) — NOT NULL
- effective_to — DATETIME(6)
- description — VARCHAR(200)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_use_cancel_restoration
- id — BIGINT — Primary key — NOT NULL
- use_cancel_operation_id — BIGINT — NOT NULL
- source_use_lot_entry_id — BIGINT — NOT NULL
- restore_lot_entry_id — BIGINT — NOT NULL
- expire_lot_entry_id — BIGINT
- new_lot_id — BIGINT
- restoration_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
point_wallet
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(64) — NOT NULL
- available_balance — BIGINT — NOT NULL
- next_expire_date — DATE
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL