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