한이음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