needs

테이블 (3)

Complaint_Needs (불편사항 니즈)

  • complain_needs_id (Key) — Long — 기본 키 — NOT NULL
  • product_name (제품명) — varchar(100)
  • category_id (카테고리) — Long
  • compaint (불편사항) — varchar(255)
  • discomfort_moment (불편한 순간) — varchar(255)
  • frequency (빈도) — int
  • solution (해결책) — varchar
  • improvement_idea (개선사항) — varchar
  • additional_payment (추가비용) — int
  • comment (추가하고싶은말) — varchar(255)
  • ai_summary (ai요약) — varchar(255)

Require_Needs (요구사항 니즈)

  • require_needs_id (Key) — Long — 기본 키 — NOT NULL
  • title (제목) — varchar(100)
  • category_id (카테고리) — Long
  • content (내용) — varchar(255)
  • solution (해결책) — varchar(255)
  • expected_cost (예상비용) — int
  • expected_user (예상사용자) — int
  • Reference (참고) — varchar(255)
  • additional_explanation (추가설명) — varchar(255)
  • ai_summary (ai 요약) — varchar(255)

카테고리 (category)

  • category_id (Key) — Long — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • use_yn (Field2) — varchar(1)