16team
Tables (7)
keyword
- id (Key) — BIGINT — Primary key — NOT NULL
- stock_name (Key2) — VARCHAR(255) — Foreign key → stock.stock_Id — NOT NULL
- keyword (id) — VARCHAR(255)
news
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(500)
- content — TEXT
- url — VARCHAR(500)
- collected_at (수집한시간) — DATETIME
- summary (요약) — TEXT
- news_keyword (뉴스 키워드)
stock
- stock_Id (Key) — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- sector — VARCHAR(255)
term
- id — BIGINT — Primary key — NOT NULL
- word (용어) — VARCHAR(255) — NOT NULL
- definition (설명) — TEXT
- category (카테고리) — VARCHAR(100)
- created_at (생성시간) — DATETIME
trend
- id — BIGINT — Primary key — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- searchVolume — INT — NOT NULL
- createdAt (Field) — VARCHAR(255)
- categories (Field2) — VARCHAR(255)
user
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100)
user_view_history
- id — BIGINT
- user_id — BIGINT — NOT NULL
- company_id — BIGINT — NOT NULL
- viewed_at — DATETIME — NOT NULL