data sheet
Tables (9)
admin (admins)
- id — INT — Primary key — NOT NULL
- email — VARCHAR — NOT NULL — 아이디
- password — VARCHAR — NOT NULL — 비밀번호
- auth — VARCHAR — 인증정보
creators
- id — INT — Primary key — NOT NULL
- group — VARCHAR — 소속
- kol_name — VARCHAR — KOL 이름
- exchange_id — VARCHAR — 거래소 ID
- uid — VARCHAR — UID
- code — VARCHAR — 코드
- commission_rate — decimal — 커미션 요율
exchange_binance
- id — integer — Primary key — NOT NULL — sequence
- order_type — varchar
- uid — varchar — NOT NULL
- commission_asset — varchar
- commission_earned — decimal — NOT NULL
- commission_amount — decimal — NOT NULL
- commission_time — datetime
- registration_time — datetime
- created_at — datetime
exchange_bingx
- id — integer — Primary key — NOT NULL — sequence
- uid — varchar — NOT NULL
- remark — varchar
- referral_type — varchar
- trading_volume — decimal
- vip_level — integer
- trading_fee — decimal
- offset_trading_fees — decimal
- payable_trading_fee — decimal
- rebate_ratio — decimal
- user_traing_rebate — decimal
- commissions — decimal
- created_at — datetime
exchange_bitget
- id — integer — Primary key — NOT NULL — sequence
- uid — varchar — NOT NULL
- referral_code — varchar
- remark — varchar
- trading_amount — decimal
- trading_fee — decimal
- fee_deducted — decimal
- fee_paid — decimal
- partner_commission — decimal
- user_commission — decimal
- total_commission — decimal
- created_at — datetime
exchange_bybit
- id — integer — Primary key — NOT NULL — seqeunce
- uid — varchar — NOT NULL
- commissons — decimal — 숫자만 입력
- joined_time — datetime
- source — varchar
- kyc — varchar
- first_deposited — datetime
- deposited_amount — decimal
- total_volume — decimal
- maker — decimal
- taker — decimal
- created_at — datetime
exchange_gateio
- id — integer — Primary key — NOT NULL — sequence
- uid — varchar — NOT NULL
- email — varchar
- phone — varchar
- group — varchar
- ultra_level — integer
- superior_uid — varchar
- remark — varchar
- trading_time — datetime
- trading_type — varchar
- trading_pairv — varchar
- maker_amount — decimal
- taker_amountd — decimal
- fees — decimal
- fees_usdt — decimal
- trading_volume — decimal
- sub_account_transactions — enum — 'YES', 'NO'
- payment_method — varchar
- created_at — datetime
logs
- id — INT — Primary key — NOT NULL
- code — VARCHAR — 코드
- code_name — VARCHAR — 코드명
- action — VARCHAR — 액션
- description — TEXT — 설명
- admin_id — INT — NOT NULL — 어드민 ID
transformed_data
- id — INT — Primary key — NOT NULL
- creator_uid — VARCHAR — NOT NULL — 크리에이터 UID
- trading_volume — decimal — 거래량
- trader — VARCHAR — 트레이더
- commission — decimal — 커미션