mini_pjt
Tables (15)
annotations
- id — bigint — Primary key — NOT NULL
- job_id — bigint — Foreign key → review_jobs.id — NOT NULL
- finding_id — bigint — Foreign key → findings.id
- author_id — bigint — Foreign key → users.id — NOT NULL
- body — text — NOT NULL
- page_no — int
- bbox — jsonb
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
documents
- id — bigint — Primary key — NOT NULL
- owner_id — bigint — Foreign key → users.id — NOT NULL
- folder_id — bigint — Foreign key → folders.id
- title — varchar(255) — NOT NULL
- file_key — varchar(512) — NOT NULL
- file_hash — varchar(64) — NOT NULL
- mime_type — varchar(100) — NOT NULL
- size_bytes — bigint — NOT NULL
- page_count — int
- parse_status — varchar(20) — NOT NULL
- uploaded_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
extracted_elements
- id — bigint — Primary key — NOT NULL
- document_id — bigint — Foreign key → documents.id — NOT NULL
- section_id — bigint — Foreign key → sections.id
- page_no — int — NOT NULL
- kind — varchar(30) — NOT NULL
- raw_text — text
- normalized_value — numeric
- unit — varchar(20)
- bbox — jsonb
- embedding — vector(1024)
finding_decisions
- id — bigint — Primary key — NOT NULL
- finding_id — bigint — Foreign key → findings.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- decision — varchar(20) — NOT NULL — ACCEPT / REJECT
- created_at — timestamptz — NOT NULL
finding_elements
- finding_id — bigint — Foreign key → findings.id — NOT NULL
- element_id — bigint — Foreign key → extracted_elements.id — NOT NULL
- role — varchar(30) — SUBJECT / REFERENCE
finding_evidence
- id — bigint — Primary key — NOT NULL
- finding_id — bigint — Foreign key → findings.id — NOT NULL
- page_no — int — NOT NULL
- bbox — jsonb
- quote — text
- chunk_id — varchar(100)
- score — numeric
findings
- id — bigint — Primary key — NOT NULL
- job_id — bigint — Foreign key → review_jobs.id — NOT NULL
- rule_id — bigint — Foreign key → validation_rules.id
- severity — varchar(20) — NOT NULL — ERROR / WARNING / INFO
- category — varchar(50) — NOT NULL
- confidence — numeric
- title — varchar(255) — NOT NULL
- description — text — NOT NULL
- calc_expr — text
- expected_value — numeric
- actual_value — numeric
- page_no — int
- status — varchar(20) — NOT NULL — OPEN / ACCEPTED / REJECTED
- embedding — vector(1024)
folders
- id — bigint — Primary key — NOT NULL
- owner_id — bigint — Foreign key → users.id — NOT NULL
- name — varchar(100) — NOT NULL
- order_no — int
- created_at — timestamptz — NOT NULL
pages
- id — bigint — Primary key — NOT NULL
- document_id — bigint — Foreign key → documents.id — NOT NULL
- page_no — int — NOT NULL
- width — numeric
- height — numeric
- text_layer — text
review_jobs
- id — bigint — Primary key — NOT NULL
- document_id — bigint — Foreign key → documents.id — NOT NULL
- status — varchar(20) — NOT NULL — PENDING / RUNNING / DONE / FAILED / CANCELLED
- review_status — varchar(20) — NOT NULL — IN_REVIEW / COMPLETED
- review_score — int
- ruleset_version — int
- started_at — timestamptz
- finished_at — timestamptz
- completed_at — timestamptz
- error_code — varchar(50)
review_jobs_review_jobs
- review_jobs_status — varchar(20) — Foreign key → review_jobs.status — NOT NULL
- review_jobs_review_score — int — Foreign key → review_jobs.review_score — NOT NULL
sections
- id — bigint — Primary key — NOT NULL
- document_id — bigint — Foreign key → documents.id — NOT NULL
- parent_id — bigint — Foreign key → sections.id
- source — varchar(20) — NOT NULL
- title — varchar(255) — NOT NULL
- level — int — NOT NULL
- page_from — int
- page_to — int
- order_no — int — NOT NULL
sessions
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- refresh_token_hash — varchar(255) — NOT NULL
- user_agent — varchar(255)
- ip — inet
- expires_at — timestamptz — NOT NULL
- revoked_at — timestamptz
users
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — timestamptz — NOT NULL
- deleted_at — timestamptz
validation_rules
- id — bigint — Primary key — NOT NULL
- rule_code — varchar(50) — NOT NULL
- version — int — NOT NULL
- target_kind — varchar(30)
- expression — text — NOT NULL
- tolerance — numeric
- severity — varchar(20) — NOT NULL
- message_template — text
- effective_from — date
- effective_to — date