한이음ERD

테이블 (6)

After_b

  • Stock_symbol — NOT NULL — 외래 키 → Before_b.Stock_symbol — NOT NULL
  • User_id — NOT NULL — 외래 키 → Before_b.User_id — NOT NULL
  • Company_name — NOT NULL

Before_b

  • Stock_symbol — NOT NULL — 기본 키 — NOT NULL
  • User_id — NOT NULL — 외래 키 → User_id.User_id — NOT NULL
  • Company_name — NOT NULL
  • Retained_YN — NOT NULL
  • Ranked_YN — NOT NULL
  • Interested_YN — NOT NULL

Finance_data

  • Stock_symbol — NOT NULL — 기본 키 — NOT NULL
  • Company_name — NOT NULL

Predict

  • Stock_symbol — NOT NULL — 외래 키 → Finance_data.Stock_symbol — NOT NULL
  • Company_name — NOT NULL
  • Predicted_stock_price — NOT NULL
  • Accuracy — NOT NULL
  • Date — NOT NULL
  • Checkpoint — NOT NULL

Stock_buy

  • User_id — NOT NULL — 외래 키 → User_id.User_id — NOT NULL
  • Stock_symbol — NOT NULL — 외래 키 → Finance_data.Stock_symbol — NOT NULL
  • Company_name — NOT NULL
  • Number of shares (Number_of_shares) — NOT NULL
  • Current_price (Stock_price) — NOT NULL
  • Total_price — NOT NULL
  • Trade_date — NOT NULL
  • Price_earnings_ratio — NOT NULL

User_id

  • User_id — NOT NULL — 기본 키 — NOT NULL
  • User_name — NOT NULL
  • Phone_number — NOT NULL
  • Bank — NOT NULL
  • Account — NOT NULL
  • Option1_1 — NOT NULL
  • Option1_2 — NOT NULL