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