Automatic Coin Trading

Tables (7)

Coin Ticker (가상 화폐 현재가)

  • market_name (Field) — varchar
  • last_trade_time_stamp (Field2) — LocalDateTime
  • open_price (Field3) — double
  • high_price (Field4) — double
  • low_price (Field5) — double
  • trade_price (Field6) — double
  • changed (Field7) — Enum(String)
  • changed_price (Field8) — double
  • changed_rate (Field9) — double
  • all_day_trade_price (Field10) — double
  • all_day_trade_volume (Field11) — double
  • highest_week_price (Field12) — double
  • highest_day (Field13) — LocalDateTime
  • lowest_week_price (Field14) — double
  • lowest_day (Field15) — LocalDateTime

Market (가상 화폐)

  • id (Key) — Long — Primary key — NOT NULL
  • coin_name (Field) — varchar
  • coin_eng_name (Field2) — varchar
  • market (Field3) — varchar

Portfolio (보유 코인(단품))

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • wallet_id (Key3) — Long — Foreign key → Wallet.id — NOT NULL
  • market_name (Field) — varchar
  • price (Field2) — double
  • volume (Field3) — double
  • average_value (Field4) — double
  • last_trade_time_stamp (Field5) — LocalDateTime

Trade (거래)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • market_id (Key3) — Long — Foreign key → Market.id — NOT NULL
  • trade_value (Field2) — double
  • trade_type (Field) — Enum(String)
  • quantity (Field3) — double
  • time_stamp (Field4) — DateTime

Trading record (매매 기록)

  • id (Key) — Long — Primary key — NOT NULL
  • market_id (Key2) — Long — Foreign key → Market.id — NOT NULL
  • user_id (Key3) — Long — Foreign key → User.id — NOT NULL
  • average_value (Field3) — double

User (유저)

  • id (Key) — Long — Primary key — NOT NULL
  • wallet_id (Key2) — Long — Foreign key → Wallet.id — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • role (Field4) — Enum(String)

Wallet (지갑)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • balance (Field) — double