DemoProject

테이블 (3)

상품 (PRODUCT)

  • Product ID (product_id) — bigint — 기본 키 — NOT NULL — 상품 ID
  • Title (title) — varchar
  • Total Investing Amount (total_investing_amount) — bigint
  • Start At (start_at) — date
  • Finished At (finished_at) — date
  • Is Available (is_available) — boolean
  • Is Deleted (is_deleted) — boolean

투자 (INVEST)

  • Invest ID (invest_id) — bigint — 기본 키 — NOT NULL
  • User ID (user_id) — bigint — 외래 키 → 회원.User ID — NOT NULL
  • Product ID (product_id) — bigint — 외래 키 → 상품.Product ID — NOT NULL — 상품 ID
  • Investing Amount (investing_amount) — bigint
  • Invest Datetime (invest_datetime) — date
  • Is Deleted (is_deleted) — boolean

회원 (USER)

  • User ID (user_id) — bigint — 기본 키 — NOT NULL
  • User Name (username) — varchar
  • Email (email) — varchar
  • Is Deleted (is_deleted) — boolean