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