주식 이야기 DB
테이블 (4)
Stock Position Story (stock_position_story)
- Story ID (story_id) — long — 기본 키 — NOT NULL
- User ID (user_id) — long — 외래 키 → User.User ID — NOT NULL
- Creation Date (creation_dt) — datetime
- Content (content) — varchar(200)
- Position Type (positon_type) — enum('long','short')
Stock Purchase Record (stock_purchase_record)
- Stock Purchase ID (stock_purchase_id) — long — 기본 키 — NOT NULL
- Story ID (story_id) — long — 외래 키 → Stock Position Story.Story ID — NOT NULL
- User ID (user_id) — long — 외래 키 → User.User ID — NOT NULL
- Stock Code (stock_code) — varchar(30)
- Purchase Date (purchase_dt) — datetime
- Purchase Price (purchase_price) — long
Stock Sell Record (stock_sell_record)
- Stock Sell ID (stock_sell_id) — long — 기본 키 — NOT NULL
- Story ID (story_id2) — long — 외래 키 → Stock Position Story.Story ID — NOT NULL
- User ID (user_id) — long — 외래 키 → User.User ID — NOT NULL
- Stock Code (stock_code) — varchar(30)
- Sell Date (sell_dt) — datetime
- Average Purchase Price (avg_purchase_price) — long
- Sell Price (sell_price) — long
User (user)
- User ID (user_id) — long — 기본 키 — NOT NULL
- Email (email) — varchar(50)
- Password (password) — varchar(75)
- Name (name) — Varchar(32)