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