kiply

Tables (31)

blockchain_chain

  • enabled — boolean — NOT NULL
  • chain_id — bigint
  • withdraw_gas_limit — bigint
  • code — varchar(20) — NOT NULL
  • explorer_url — varchar(255)
  • native_symbol — varchar(255)
  • network_type — varchar(255) — NOT NULL
  • rpc_url — varchar(255)

blockchain_history

  • amount — numeric(38, 18) — NOT NULL
  • chain_id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • member_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • source — varchar(20) — NOT NULL
  • INTERNAL::character — varying
  • SYSTEM::character — varying)::text))
  • status — varchar(20) — NOT NULL
  • CONFIRMED::character — varying
  • FAILED::character — varying)::text))
  • token_symbol — varchar(20) — NOT NULL
  • type — varchar(20) — NOT NULL
  • DEBIT::character — varying)::text))
  • from_address — varchar(42) — NOT NULL
  • to_address — varchar(42) — NOT NULL
  • tx_hash — varchar(66) — NOT NULL

blockchain_hot_wallet

  • is_active — boolean — NOT NULL
  • id — bigint
  • address — varchar(255) — NOT NULL
  • wallet_name — varchar(255) — NOT NULL

blockchain_hot_wallet_asset

  • amount — numeric(38, 18) — NOT NULL
  • hot_wallet_id — bigint — NOT NULL
  • id — bigint
  • last_synced_at — timestamp(6)
  • chain_code — varchar(20) — NOT NULL
  • token_symbol — varchar(20) — NOT NULL

blockchain_token

  • decimals — integer — NOT NULL
  • cmc_id — bigint
  • id — bigint
  • symbol — varchar(32) — NOT NULL

blockchain_token_chain_mapping

  • priority — integer — NOT NULL
  • id — bigint
  • token_id — bigint — NOT NULL
  • chain_code — varchar(20) — NOT NULL
  • contract_address — varchar(42)

blockchain_wallet

  • is_primary — boolean — NOT NULL
  • created_at — timestamp(6)
  • id — bigint
  • member_id — bigint — NOT NULL
  • chain_code — varchar(32) — NOT NULL
  • address — varchar(255)
  • last_synced_at — timestamp(6) — NOT NULL
  • last_synced_block — bigint — NOT NULL

board_notice

  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • updated_at — timestamp(6) — NOT NULL
  • view_count — bigint — NOT NULL
  • author_id — varchar(255) — NOT NULL
  • status — varchar(255) — NOT NULL
  • DELETED::character — varying
  • HIDDEN::character — varying)::text))
  • title — varchar(255) — NOT NULL
  • content — oid — NOT NULL

config_version

  • updated_at — timestamp(6) — NOT NULL
  • version — bigint — NOT NULL
  • domain — varchar(255) — NOT NULL
  • updated_by — varchar(255)

contact

  • del_yn — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • member_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • token_symbol — varchar(32) — NOT NULL
  • alias — varchar(64)
  • address — varchar(128) — NOT NULL
  • memo — oid

event

  • created_at — timestamp(6) — NOT NULL
  • end_date — timestamp(6) — NOT NULL
  • id — bigint
  • start_date — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • view_count — bigint — NOT NULL
  • status — varchar(20) — NOT NULL
  • IN_PROGRESS::character — varying
  • ENDED::character — varying
  • DELETED::character — varying)::text))
  • title — varchar(200) — NOT NULL
  • banner_image_url — varchar(512) — NOT NULL
  • content — oid — NOT NULL

inquiry

  • answered_at — timestamp(6)
  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • member_id — bigint — NOT NULL
  • answer — text
  • content — text — NOT NULL
  • email — varchar(255) — NOT NULL
  • status — varchar(255)
  • PROCESSING::character — varying
  • COMPLETED::character — varying
  • CANCELED::character — varying)::text))
  • type — varchar(255) — NOT NULL
  • ERROR::character — varying
  • REQUEST::character — varying
  • ETC::character — varying)::text))

kafka_dlt

  • partition — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • msg_offset — bigint — NOT NULL
  • error_message — text
  • payload — text — NOT NULL
  • topic — varchar(255) — NOT NULL

kyc_profile

  • authenticated_at — timestamp(6)
  • id — bigint
  • ci — varchar(500) — NOT NULL
  • di — varchar(500)
  • birth_day — varchar(255)
  • gender — varchar(255)
  • name — varchar(255)
  • nation — varchar(255)
  • phone_corp — varchar(255)
  • phone_no — varchar(255)

member

  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • id — bigint
  • kyc_profile_id — bigint
  • updated_at — timestamp(6) — NOT NULL
  • role — varchar(20) — NOT NULL — 회원
  • status — varchar(20) — NOT NULL — 회원
  • SUSPENDED::character — varying
  • DELETED::character — varying
  • KYC_PENDING::character — varying
  • PURGED::character — varying)::text))
  • name — varchar(100) — 회원
  • user_id — varchar(100) — NOT NULL — 우리
  • email — varchar(200) — 회원
  • picture_url — varchar(512) — 프로필
  • pin_password — varchar(255)

member_agreement

  • id — bigint
  • agreed_at — timestamp(6) — NOT NULL — 동의
  • agreed_version — integer — NOT NULL — 동의한
  • terms_code — varchar(50) — NOT NULL — 동의한
  • member_id — bigint — NOT NULL — 동의한

member_partner_link

  • created_at — timestamp(6)
  • id — bigint
  • member_id — bigint — NOT NULL
  • partner_id — bigint — NOT NULL
  • partner_user_id — varchar(100) — NOT NULL

notification_device_token

  • id — bigint
  • last_registered_at — timestamp(6)
  • device_token — varchar(255) — NOT NULL
  • device_type — varchar(255)
  • user_id — varchar(255) — NOT NULL

notification_setting

  • is_enabled — boolean — NOT NULL
  • is_marketing_enabled — boolean — NOT NULL
  • is_transaction_enabled — boolean — NOT NULL
  • member_id — bigint — NOT NULL

outbox

  • attempts — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • next_attempt_at — timestamp(6)
  • updated_at — timestamp(6) — NOT NULL
  • status — varchar(20) — NOT NULL
  • SENT::character — varying
  • FAILED::character — varying
  • DEAD::character — varying)::text))
  • topic — varchar(100) — NOT NULL
  • message_key — varchar(200) — NOT NULL
  • last_error — varchar(500)
  • payload — oid — NOT NULL

partner

  • daily_reward_limit_count — integer — NOT NULL
  • max_amount_per_request — numeric(38, 18) — NOT NULL
  • id — bigint
  • status — varchar(20) — NOT NULL
  • INACTIVE::character — varying
  • DELETED::character — varying
  • BLOCKED::character — varying)::text))
  • partner_code — varchar(50) — NOT NULL
  • name — varchar(100) — NOT NULL
  • secret_key — varchar(128) — NOT NULL

partner_accounts

  • is_active — boolean — NOT NULL
  • id — bigint
  • last_login_at — timestamp(6)
  • partner_id — bigint
  • role — varchar(20) — NOT NULL
  • MANAGER::character — varying
  • STAFF::character — varying)::text))
  • name — varchar(30) — NOT NULL
  • login_id — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL

reward_asset_balance

  • id — bigint
  • amount — numeric(38, 18) — NOT NULL
  • chain — varchar(20)
  • created_at — timestamp(6) — NOT NULL
  • symbol — varchar(255) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • version — bigint
  • wallet_id — bigint — NOT NULL

reward_history

  • acquisition_price — numeric(38, 18) — NOT NULL
  • amount — numeric(38, 18) — NOT NULL
  • id — bigint
  • occurred_at — timestamp(6) — NOT NULL
  • wallet_id — bigint
  • reward_id — varchar(64) — NOT NULL
  • trace_id — varchar(64) — NOT NULL
  • asset_symbol — varchar(255)
  • chain — varchar(255)
  • reason — varchar(255)
  • type — varchar(255)

reward_issue_request

  • amount — numeric(38, 18) — NOT NULL
  • decimals — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • expires_at — timestamp(6)
  • id — bigint
  • member_id — bigint
  • processed_at — timestamp(6)
  • wallet_id — bigint
  • asset_symbol — varchar(32) — NOT NULL
  • chain_code — varchar(32)
  • partner_code — varchar(32) — NOT NULL
  • status — varchar(32) — NOT NULL
  • PROCESSED::character — varying
  • FAILED::character — varying)::text))
  • issue_id — varchar(64) — NOT NULL
  • trace_id — varchar(64)
  • partner_user_id — varchar(100) — NOT NULL
  • reason — varchar(255)

reward_lot

  • decimal — integer — NOT NULL
  • original_amount — numeric(38, 18) — NOT NULL
  • remaining_amount — numeric(38, 18) — NOT NULL
  • expired_at — timestamp(6) — NOT NULL
  • id — bigint
  • wallet_id — bigint — NOT NULL
  • chain_code — varchar(255) — NOT NULL
  • original_trace_id — varchar(255) — NOT NULL
  • token_symbol — varchar(255) — NOT NULL

reward_metadata

  • age — integer
  • amount — numeric(38, 18)
  • history_id — bigint — NOT NULL
  • gender — varchar(255)
  • merchant — varchar(255)
  • region — varchar(255)
  • raw_metadata — jsonb

reward_wallet

  • created_at — timestamp(6) — NOT NULL
  • id — bigint
  • member_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL

reward_withdraw_request

  • actual_gas_fee — numeric(38, 18)
  • amount — numeric(38, 18) — NOT NULL
  • applied_gas_price — numeric(38)
  • decimals — integer — NOT NULL
  • gas_fee — numeric(38, 18) — NOT NULL
  • gas_limit — numeric(38)
  • onchain_nonce — numeric(38)
  • receipt_retry_count — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • hot_wallet_id — bigint
  • id — bigint
  • member_id — bigint — NOT NULL
  • requested_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • wallet_id — bigint — NOT NULL
  • chain_code — varchar(32) — NOT NULL
  • status — varchar(32) — NOT NULL
  • APPROVED::character — varying
  • REJECTED::character — varying
  • EXPIRED::character — varying
  • PROCESSING::character — varying
  • ONCHAIN_REQUESTED::character — varying
  • COMPLETED::character — varying
  • FAILED::character — varying
  • FAILED_CHECK_REQUIRED::character — varying
  • FAILED_REFUNDED::character — varying)::text))
  • token_symbol — varchar(32) — NOT NULL
  • trace_id — varchar(64) — NOT NULL
  • withdraw_id — varchar(64) — NOT NULL
  • destination_address — varchar(255) — NOT NULL
  • fail_reason — varchar(255)
  • onchain_tx_hash — varchar(255)
  • token_contract — varchar(255)

social_accounts

  • id — bigint
  • member_id — bigint — NOT NULL
  • provider — varchar(50) — NOT NULL
  • provider_user_id — varchar(100) — NOT NULL
  • picture_url — varchar(512)
  • email — varchar(255)
  • name — varchar(255)
  • refresh_token — varchar(512)

terms

  • id — bigint
  • created_at — timestamp(6) — NOT NULL
  • enforcement_date — timestamp(6) — NOT NULL — 약관
  • is_active — boolean — NOT NULL — 현재
  • mandatory — boolean — NOT NULL — 필수
  • terms_code — varchar(50) — NOT NULL — 약관
  • title — varchar(100) — NOT NULL — 약관
  • updated_at — timestamp(6) — NOT NULL
  • version — integer — NOT NULL — 약관