주식 이야기 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)