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)