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