포인트
테이블 (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