투자 ERD

테이블 (3)

investing_product

  • product_id — bigint(20) — 기본 키 — NOT NULL
  • title — varchar(32)
  • total_invesing_amount (total_investing_amount) — int(11)
  • started_at — datetime
  • finished_at — datetime
  • num_of_investor — int(11)
  • current_investing_amount — int(11)
  • status — varchar(32) — NOT NULL

product_user (trade)

  • trade_id — bigint(20) — 기본 키 — NOT NULL
  • product_id — bigint(20) — 외래 키 → investing_product.product_id — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.user_id — NOT NULL
  • trade_at — datetime
  • investing_amount — int(11)

user

  • user_id — bigint(20) — 기본 키 — NOT NULL
  • user_name — varchar(30)