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