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)