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 — 약관