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)
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 (주문 생성 시간)
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)