IPX

Tables (10)

cases

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • applicant_name — VARCHAR(200)
  • inventor_name — VARCHAR(200)
  • technical_field — TEXT
  • description — TEXT
  • user_input_ipc — TEXT — NOT NULL
  • search_completed_at — TIMESTAMP
  • novelty_completed_at — TIMESTAMP
  • inventive_completed_at — TIMESTAMP
  • report_completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

invention_components

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → cases.id — NOT NULL
  • label — CHAR(1) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • UNIQUE(case_id, — label)

inventive_arguments

  • id — BIGSERIAL — Primary key — NOT NULL
  • analysis_id — BIGINT — Foreign key → inventive_step_analyses.id — NOT NULL
  • argument_type — VARCHAR(30) — NOT NULL
  • applicable — BOOLEAN — NOT NULL
  • ai_recommended — BOOLEAN — NOT NULL
  • content — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • UNIQUE(analysis_id, — argument_type)

inventive_step_analyses

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → cases.id — NOT NULL
  • primary_art_id — BIGINT — Foreign key → prior_arts.id — NOT NULL
  • secondary_art_id — BIGINT — Foreign key → prior_arts.id
  • created_at — TIMESTAMP — NOT NULL

novelty_analyses

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → cases.id — NOT NULL
  • overall_verdict — VARCHAR(20)
  • summary — TEXT
  • created_at — TIMESTAMP — NOT NULL

novelty_comparisons

  • id — BIGSERIAL — Primary key — NOT NULL
  • novelty_analysis_id — BIGINT — Foreign key → novelty_analyses.id — NOT NULL
  • component_id — BIGINT — Foreign key → invention_components.id — NOT NULL
  • prior_art_id — BIGINT — Foreign key → prior_arts.id — NOT NULL
  • match_status — VARCHAR(20) — NOT NULL
  • prior_art_excerpt — TEXT
  • UNIQUE(novelty_analysis_id, — component_id,

prior_arts

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → cases.id — NOT NULL
  • application_number — VARCHAR(20) — NOT NULL
  • rank — SMALLINT — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • rrf_score — FLOAT
  • included — BOOLEAN — NOT NULL
  • reason — TEXT
  • summary — TEXT
  • tech_purpose — TEXT
  • key_features — TEXT
  • matched_keywords — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • UNIQUE(case_id, — application_number)

reports

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → cases.id — NOT NULL
  • author_name — VARCHAR(100) — NOT NULL
  • novelty_satisfied — BOOLEAN — NOT NULL
  • inventive_satisfied — BOOLEAN — NOT NULL
  • overall_conclusion — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

terms_agreements

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • terms_type — VARCHAR(50) — NOT NULL
  • terms_version — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • company — VARCHAR(200)
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL