uu
Tables (3)
product_accumulation (상품투자합계)
- product_id (상품ID) — INT — Foreign key → product_list.product_id — NOT NULL
- current_investing_amount (현재모집금액)
product_list (상품목록)
- product_id (상품ID) — INT — Primary key — NOT NULL
- product_title (상품제목) — VARCHAR2(30)
- total_investing_amount (총모집금액) — BIGINT
- investing_start_at (모집시작일시) — timestamp
- investing_end_at (모집종료일시) — timestamp
user_product (사용자투자목록)
- user_id (사용자ID) — INT — Primary key — NOT NULL
- product_id (상품ID) — INT — Foreign key → product_list.product_id — NOT NULL
- investing_amount (투자금액) — BIGINT
- investing_at (투자일시) — timestamp