투자 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)