Boida!

Tables (11)

Connected_exchange (Untitled2)

  • connected exchange (connected exchage primary key) — Primary key — NOT NULL
  • user (id) — Foreign key → users.user — NOT NULL
  • exchange (exchange primary key) — Foreign key → exchange.exchange — NOT NULL
  • api key (Field2)
  • secret key (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • is_deleted (Field6)

asset (Untitled5)

  • asset (asset primary eky) — Primary key — NOT NULL
  • user (id) — Foreign key → users.user — NOT NULL
  • crypto (crypto primary key) — Foreign key → crypto.crypto — NOT NULL
  • exchange (exchange primary key) — Foreign key → exchange.exchange — NOT NULL
  • purchase_amount (코인 매수금액)
  • valuation_amount (코인 평가금액)
  • valuation_loss (코인 평가손익)
  • valuation_earning_rate (코인 평가수익률)
  • balance (코인갯수)

crypto (CopyOfUntitled3)

  • crypto (crypto primary key) — Primary key — NOT NULL
  • crypto_name (Field)
  • crypto_image (Field2)

exchange (Untitled3)

  • exchange (exchange primary key) — Primary key — NOT NULL
  • exchange_type (Field)
  • exchange_image (Field2)
  • is_available (거래소 연동 서비스 가능 여부)
  • location (국내 : domestic, 해외: aboard)

explain (Untitled4)

  • Key — Primary key — NOT NULL
  • exchange (exchange primary key) — Foreign key → exchange.exchange — NOT NULL
  • content (Field)
  • image (Field2)

notification (Untitled7)

  • user (id) — Foreign key → users.user — NOT NULL
  • target_user_id (알림을 보낸 유저)
  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • is_read (Field5)
  • type (알림타입)

total_asset analysis result (CopyOfUntitled5)

  • Field (총자산)

upbit_accounts (Untitled8)

    upbit_transaction (거래내역)

    • transaction (transaction primary key) — Primary key — NOT NULL
    • exchange (exchage primary key) — Foreign key → Connected_exchange.connected exchange — NOT NULL
    • exchange (exchange primary key) — Foreign key → Connected_exchange.exchange — NOT NULL
    • uuid (주문의 고유 아이디)
    • side (주문 종류)
    • ord_type (주문 방식)
    • price (주문 당시 화폐 가격)
    • state (주문 상태)
    • market (마켓의 유일키)
    • volume (사용자가 입력한 주문 양)
    • remaining_volume (체결 후 남은 주문 양)
    • reserved_fee (수수료로 예약된 비용)
    • remaining_fee (남은 수수료)
    • paid_fee (사용된 수수료)
    • locked (거래에 사용중인 비용)
    • executed_volume (체결된 양)
    • trades_count (해당 주문에 걸린 체결 수)
    • created_at (주문 생성 시간)

    user_log (Untitled6)

    • Field
    • Field2

    users (Untitled)

    • user (id) — Primary key — NOT NULL
    • platform_type (소셜로그인 타입)
    • email (이메일)
    • nickname (이름)
    • age_range (나이범위)
    • gender (성별)
    • profile_image (프로필 이미지)
    • thumbnail_image (썸네일 이미지)
    • access_token (엑세스 토큰)
    • refresh_token (리프레쉬 토큰)
    • fcm_token (firebase 토큰)
    • created_at (Field)
    • connected_at (Field2)