F

Tables (7)

coin (코인)

  • coin_id — BIGINT — Primary key — NOT NULL
  • ticker_id — BIGINT — Foreign key → ticker.ticker_id — NOT NULL
  • upbit_coin_id — BIGINT — Foreign key → upbit_coin.upbit_coin_id — NOT NULL
  • name — VARCHAR
  • prospects — BigDecimal
  • coin_picture — VARCHAR(500)
  • gpt_data — VARCHAR(250)

coin_sentiment_stats (코인 통계)

  • ticker_id — BIGINT — Foreign key → ticker.ticker_id — NOT NULL
  • time — DATETIME
  • coin_score — FLOAT

news (뉴스)

  • news_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(250)
  • content — VARCHAR(10000)
  • newspaper — VARCHAR(250)
  • source — VARCHAR(500)
  • uploadtime — DATETIME
  • title_en — VARCHAR(250)
  • content_en — VARCHAR(10000)

news_sentiment (뉴스 감성분석)

  • news_id — BIGINT — Foreign key → news.news_id — NOT NULL
  • sentiment_score — FLOAT
  • sentiment_label — VARCHAR(20)

news_ticker_relation (뉴스-티커)

  • news_id — BIGINT — Foreign key → news.news_id — NOT NULL
  • ticker_id — BIGINT — Foreign key → ticker.ticker_id — NOT NULL

ticker (티커)

  • ticker_id — BIGINT — Primary key — NOT NULL
  • cryptopanic_ticker — VARCHAR(250)

upbit_coin (업비트코인)

  • upbit_coin_id — BIGINT — Primary key — NOT NULL
  • upbit_ticker — VARCHAR(250)