HP032

Tables (4)

law_articles

  • id — bigserial — Primary key — NOT NULL
  • law_id — text — Foreign key → laws.law_id — NOT NULL
  • article_no — int — NOT NULL
  • paragraph_no — int
  • item_no — int
  • title — text
  • content — text — NOT NULL
  • content_hash — text — NOT NULL
  • version_mst — text — NOT NULL
  • valid_from — date — NOT NULL
  • valid_to — date
  • is_current — boolean — NOT NULL
  • qdrant_point_id — uuid
  • EXCLUDE — USING

law_versions

  • id — bigserial — Primary key — NOT NULL
  • law_id — text — Foreign key → laws.law_id — NOT NULL
  • mst — text — NOT NULL
  • promulgation_date — date — NOT NULL
  • enforcement_date — date — NOT NULL
  • revision_type — text — NOT NULL

laws

  • law_id — text — Primary key — NOT NULL
  • law_name — text — NOT NULL
  • hierarchy — text — NOT NULL
  • ministry — text

sync_state

  • id — int — Primary key — NOT NULL
  • last_synced_at — timestamptz — NOT NULL
  • last_change_marker — text