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

Untitled

    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