Moin
Tables (5)
fee_policy
- idx — BIGINT
- code — VARCHAR(20)
- currency — VARCHAR(10)
- min_amount — DECIMAL(19, 4)
- max_amount — DECIMAL(19, 4)
- fixed_fee — INT
- fee_rate — DOUBLE
limit_policy
- idx — BIGINT
- id_type — VARCHAR(20)
- currency — VARCHAR(10)
- limit_amount — DECIMAL(19, 4)
quote_history
- idx — BIGINT
- user_idx — BIGINT — Foreign key → users.idx
- request_date — DATE
- currency_code — VARCHAR(10)
- amount — DECIMAL(19, 12)
- fee — DECIMAL(19, 12)
- exchange_rate — DECIMAL(19, 12)
- expire_time — TIMESTAMP
- target_amount — DECIMAL(19, 12)
- usd_exchange_rate — DECIMAL(19, 12)
- usd_amount — DECIMAL(19, 12)
- is_expired — BOOLEAN
remittance_history
- idx — BIGINT
- user_idx — BIGINT — Foreign key → users.idx
- quote_idx — BIGINT — Foreign key → quote_history.idx
- amount — DECIMAL(19, 12)
- remittance_date — DATETIME
- status — BOOLEAN
users
- idx — BIGINT
- user_id — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(30)
- id_type — VARCHAR(20)
- id_value — VARCHAR(50)
- refresh_token — VARCHAR(1000)
- reg_date — DATETIME
- mod_date — DATETIME