stock
Tables (5)
Company (tb_company)
- company_id — INT — Primary key — NOT NULL
- company_name — VARCHAR(64)
News_analysis (tb_news_analysis)
- news_analysis_id — INT — Primary key — NOT NULL
- company_id — INT — Foreign key → Company.company_id — NOT NULL
- company_name — VARCHAR(64)
- title — VARCAHR(1024)
- url — VARCHAR(2048)
- date — DATETIME
- sentiment — VARCHAR(10)
- score — FLOAT
Stock (tb_stock)
- stock_id (id) — INT — Primary key — NOT NULL
- company_id — INT — Foreign key → Company.company_id — NOT NULL
- company_name — VARCHAR(64)
- date — DATETIME
- open — INT
- high — INT
- low — INT
- close — INT
- volume — INT
- stock_change — FLOAT
- ma_5 — FLOAT
- fast_k — FLOAT
- slow_k — FLOAT
- slow_d — FLOAT
- rsi — FLOAT
- std — FLOAT
- upper — FLOAT
- lower — FLOAT
report (Untitled2)
- report_id — INT — Primary key — NOT NULL
- company_id — INT — Foreign key → Company.company_id — NOT NULL
- sales — DOUBLE
- operating Income — DOUBLE
- net income — DOUBLE
- assets — DOUBLE
- Liabilities — DOUBLE
- Stockholders' Equity — DOUBLE
- capital Stock — DOUBLE
- cfo — DOUBLE
- cfi — DOUBLE
- cff — DOUBLE
- roe — FLOAT
- roa — FLOAT
- per — FLOAT
- pbr — FLOAT
- psr — FLOAT
- pcr — FLOAT
- dy — FLOAT
- date — DATETIME