무료포인트 시스템
테이블 (4)
member
- member_no — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_date — DATETIME(6)
- modified_date — DATETIME(6)
- created_by — VARCHAR(50)
- modified_by — VARCHAR(50)
order
- order_no — BIGINT
- member_no — BIGINT — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
- created_date — DATETIME(6)
- created_by — BIGINT
point_balance
- point_no — BIGINT
- member_no — BIGINT — NOT NULL
- balance — DECIMAL(10, 2) — NOT NULL
- expiry_date — DATETIME — NOT NULL
- created_date — DATETIME(6)
- modified_date — DATETIME(6)
- created_by — BIGINT
- modified_by — BIGINT
point_transaction
- transaction_no — BIGINT
- member_no — BIGINT — NOT NULL
- order_no — BIGINT
- type — VARCHAR(20) — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- created_date — DATETIME(6)
- created_by — BIGINT