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