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 — 커미션