Flock Database Validation

Validation Checks

1. Required Fields

Every sheep record must have:

• •id (unique, kebab-case)
• •name (display name)
• •sex (ram, ewe, ram_lamb, ewe_lamb, wether, unknown)
• •status (alive, deceased, sold, unknown)
• •confidence (high, medium, low)

2. Breed Composition

• •All breed percentages must sum to 100% (±1% for rounding)
• •Each breed must be a recognized breed name
• •coat_type should match: mostly hair breeds → "hair", mostly wool breeds → "wool", otherwise "mixed"
• •hair_percentage should be calculable from breed percentages

3. Pedigree Integrity

• •Every sire_id must reference an existing sheep with sex = "ram"
• •Every dam_id must reference an existing sheep with sex = "ewe"
• •No circular references (A is parent of B is parent of A)
• •Sire/dam should be older than offspring (if DOBs are known)

4. Tag Uniqueness

• •No two living sheep should have the same tag number
• •Deceased sheep may share tags with living sheep (tags get reused)
• •Tags noted as "retagged" should be verified

5. Pen Assignments

• •Every sheep with status = "alive" should have a pen assignment
• •No deceased sheep should be listed in active pens
• •Pen ram assignments should match the pens object

6. Health Records

• •Sheep on the "weak resistance" list should have health.weak_resistance = true
• •Treatment dates should be chronological
• •FAMACHA scores should be 1–5

Running Validation

python3 scripts/validate_flock.py
python3 scripts/validate_flock.py --strict    # Treat warnings as errors
python3 scripts/validate_flock.py --check-references  # Verify sire/dam links
python3 scripts/validate_flock.py --check-images      # Verify image references exist

Severity Levels

• •ERROR: Must fix before committing (missing required fields, broken references)
• •WARNING: Should investigate (suspicious breed percentages, missing pen assignments)
• •INFO: Optional improvements (missing optional fields, incomplete health records)