quietlight/skraak_mcp - Change 45CSH7XONAYN6NMIII5EEOR3AJRZ5OXYMMDXZU4GJK2L224C3NCQC

updated schema.svg

Created by quietlight on April 19, 2026

45CSH7XONAYN6NMIII5EEOR3AJRZ5OXYMMDXZU4GJK2L224C3NCQC

Dependencies

In channels

main

Change contents

Insertion in db/schema.dbml at line 164 [3.320733]
[3.326270]
[3.326270]
```
  "active" BOOLEAN [default: TRUE]
```

Replacement in db/schema.svg at line 7 [3.172440]

B:BD[3.172689] → [4.6197:6433]

<svg width="6217pt" height="3909pt"
 viewBox="0.00 0.00 6216.67 3908.61" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 3904.61)">

[3.172689]

[3.172924]

<svg width="6217pt" height="3993pt"
 viewBox="0.00 0.00 6216.67 3993.04" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 3989.04)">

Replacement in db/schema.svg at line 704 [3.172440]

B:BD[3.265273] → [4.89011:100586]

<ellipse fill="none" stroke="black" stroke-width="0" cx="3581.95" cy="-3218.96" rx="434.33" ry="681.8"/>
<polygon fill="#1d71b8" stroke="transparent" points="3276.95,-3638.96 3276.95,-3698.96 3886.95,-3698.96 3886.95,-3638.96 3276.95,-3638.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3638.96 3276.95,-3698.96 3886.95,-3698.96 3886.95,-3638.96 3276.95,-3638.96"/>
<text text-anchor="start" x="3405.9" y="-3660.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;ebird_taxonomy &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3578.96 3276.95,-3638.96 3886.95,-3638.96 3886.95,-3578.96 3276.95,-3578.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3578.96 3276.95,-3638.96 3886.95,-3638.96 3886.95,-3578.96 3276.95,-3578.96"/>
<text text-anchor="start" x="3287.95" y="-3600.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="3312.84" y="-3600.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3600.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3518.96 3276.95,-3578.96 3886.95,-3578.96 3886.95,-3518.96 3276.95,-3518.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3518.96 3276.95,-3578.96 3886.95,-3578.96 3886.95,-3518.96 3276.95,-3518.96"/>
<text text-anchor="start" x="3287.95" y="-3539.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxonomy_version &#160;&#160;&#160;</text>
<text text-anchor="start" x="3641.34" y="-3540.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(4)</text>
<text text-anchor="start" x="3836.86" y="-3540.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3540.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3458.96 3276.95,-3518.96 3886.95,-3518.96 3886.95,-3458.96 3276.95,-3458.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3458.96 3276.95,-3518.96 3886.95,-3518.96 3886.95,-3458.96 3276.95,-3458.96"/>
<text text-anchor="start" x="3287.95" y="-3479.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.64" y="-3480.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="3836.86" y="-3480.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3480.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3398.96 3276.95,-3458.96 3886.95,-3458.96 3886.95,-3398.96 3276.95,-3398.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3398.96 3276.95,-3458.96 3886.95,-3458.96 3886.95,-3398.96 3276.95,-3398.96"/>
<text text-anchor="start" x="3287.95" y="-3419.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">category &#160;&#160;&#160;</text>
<text text-anchor="start" x="3623.55" y="-3420.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3836.86" y="-3420.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3420.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3338.96 3276.95,-3398.96 3886.95,-3398.96 3886.95,-3338.96 3276.95,-3338.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3338.96 3276.95,-3398.96 3886.95,-3398.96 3886.95,-3338.96 3276.95,-3338.96"/>
<text text-anchor="start" x="3287.95" y="-3359.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_code &#160;&#160;&#160;</text>
<text text-anchor="start" x="3623.55" y="-3360.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3836.86" y="-3360.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3360.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3278.96 3276.95,-3338.96 3886.95,-3338.96 3886.95,-3278.96 3276.95,-3278.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3278.96 3276.95,-3338.96 3886.95,-3338.96 3886.95,-3278.96 3276.95,-3278.96"/>
<text text-anchor="start" x="3287.95" y="-3299.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_concept_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3300.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3218.96 3276.95,-3278.96 3886.95,-3278.96 3886.95,-3218.96 3276.95,-3218.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3218.96 3276.95,-3278.96 3886.95,-3278.96 3886.95,-3218.96 3276.95,-3218.96"/>
<text text-anchor="start" x="3287.83" y="-3239.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">primary_com_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3605.86" y="-3240.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3836.96" y="-3240.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.85" y="-3240.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3158.96 3276.95,-3218.96 3886.95,-3218.96 3886.95,-3158.96 3276.95,-3158.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3158.96 3276.95,-3218.96 3886.95,-3218.96 3886.95,-3158.96 3276.95,-3158.96"/>
<text text-anchor="start" x="3287.95" y="-3179.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sci_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3605.76" y="-3180.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3836.86" y="-3180.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3180.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3098.96 3276.95,-3158.96 3886.95,-3158.96 3886.95,-3098.96 3276.95,-3098.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3098.96 3276.95,-3158.96 3886.95,-3158.96 3886.95,-3098.96 3276.95,-3098.96"/>
<text text-anchor="start" x="3287.95" y="-3119.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">bird_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3120.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(30)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3038.96 3276.95,-3098.96 3886.95,-3098.96 3886.95,-3038.96 3276.95,-3038.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3038.96 3276.95,-3098.96 3886.95,-3098.96 3886.95,-3038.96 3276.95,-3038.96"/>
<text text-anchor="start" x="3287.95" y="-3059.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">family &#160;&#160;&#160;</text>
<text text-anchor="start" x="3644.86" y="-3060.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2978.96 3276.95,-3038.96 3886.95,-3038.96 3886.95,-2978.96 3276.95,-2978.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2978.96 3276.95,-3038.96 3886.95,-3038.96 3886.95,-2978.96 3276.95,-2978.96"/>
<text text-anchor="start" x="3287.95" y="-2999.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_group &#160;&#160;&#160;</text>
<text text-anchor="start" x="3644.86" y="-3000.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2918.96 3276.95,-2978.96 3886.95,-2978.96 3886.95,-2918.96 3276.95,-2918.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2918.96 3276.95,-2978.96 3886.95,-2978.96 3886.95,-2918.96 3276.95,-2918.96"/>
<text text-anchor="start" x="3287.95" y="-2939.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">report_as &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-2940.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2858.96 3276.95,-2918.96 3886.95,-2918.96 3886.95,-2858.96 3276.95,-2858.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2858.96 3276.95,-2918.96 3886.95,-2918.96 3886.95,-2858.96 3276.95,-2858.96"/>
<text text-anchor="start" x="3287.95" y="-2879.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_from &#160;&#160;&#160;</text>
<text text-anchor="start" x="3751.53" y="-2880.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<text text-anchor="start" x="3836.86" y="-2880.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-2880.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2798.96 3276.95,-2858.96 3886.95,-2858.96 3886.95,-2798.96 3276.95,-2798.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2798.96 3276.95,-2858.96 3886.95,-2858.96 3886.95,-2798.96 3276.95,-2798.96"/>
<text text-anchor="start" x="3287.95" y="-2819.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_to &#160;&#160;&#160;</text>
<text text-anchor="start" x="3790.62" y="-2820.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2738.96 3276.95,-2798.96 3886.95,-2798.96 3886.95,-2738.96 3276.95,-2738.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2738.96 3276.95,-2798.96 3886.95,-2798.96 3886.95,-2738.96 3276.95,-2738.96"/>
<text text-anchor="start" x="3309.87" y="-2760.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;taxonomy_version, species_code &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3275.95,-2737.96 3275.95,-3699.96 3887.95,-3699.96 3887.95,-2737.96 3275.95,-2737.96"/>

[3.265273]

[3.276662]

<ellipse fill="none" stroke="black" stroke-width="0" cx="3581.95" cy="-3260.96" rx="434.33" ry="724.15"/>
<polygon fill="#1d71b8" stroke="transparent" points="3276.95,-3710.96 3276.95,-3770.96 3886.95,-3770.96 3886.95,-3710.96 3276.95,-3710.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3710.96 3276.95,-3770.96 3886.95,-3770.96 3886.95,-3710.96 3276.95,-3710.96"/>
<text text-anchor="start" x="3405.9" y="-3732.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#ffffff"> &#160;&#160;&#160;&#160;&#160;&#160;ebird_taxonomy &#160;&#160;&#160;&#160;&#160;&#160;</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3650.96 3276.95,-3710.96 3886.95,-3710.96 3886.95,-3650.96 3276.95,-3650.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3650.96 3276.95,-3710.96 3886.95,-3710.96 3886.95,-3650.96 3276.95,-3650.96"/>
<text text-anchor="start" x="3287.95" y="-3672.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">id</text>
<text text-anchor="start" x="3312.84" y="-3672.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3672.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(12)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3590.96 3276.95,-3650.96 3886.95,-3650.96 3886.95,-3590.96 3276.95,-3590.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3590.96 3276.95,-3650.96 3886.95,-3650.96 3886.95,-3590.96 3276.95,-3590.96"/>
<text text-anchor="start" x="3287.95" y="-3611.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxonomy_version &#160;&#160;&#160;</text>
<text text-anchor="start" x="3641.34" y="-3612.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(4)</text>
<text text-anchor="start" x="3836.86" y="-3612.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3612.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3530.96 3276.95,-3590.96 3886.95,-3590.96 3886.95,-3530.96 3276.95,-3530.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3530.96 3276.95,-3590.96 3886.95,-3590.96 3886.95,-3530.96 3276.95,-3530.96"/>
<text text-anchor="start" x="3287.95" y="-3551.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3694.64" y="-3552.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">INTEGER</text>
<text text-anchor="start" x="3836.86" y="-3552.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3552.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3470.96 3276.95,-3530.96 3886.95,-3530.96 3886.95,-3470.96 3276.95,-3470.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3470.96 3276.95,-3530.96 3886.95,-3530.96 3886.95,-3470.96 3276.95,-3470.96"/>
<text text-anchor="start" x="3287.95" y="-3491.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">category &#160;&#160;&#160;</text>
<text text-anchor="start" x="3623.55" y="-3492.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3836.86" y="-3492.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3492.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3410.96 3276.95,-3470.96 3886.95,-3470.96 3886.95,-3410.96 3276.95,-3410.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3410.96 3276.95,-3470.96 3886.95,-3470.96 3886.95,-3410.96 3276.95,-3410.96"/>
<text text-anchor="start" x="3287.95" y="-3431.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_code &#160;&#160;&#160;</text>
<text text-anchor="start" x="3623.55" y="-3432.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<text text-anchor="start" x="3836.86" y="-3432.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3432.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3350.96 3276.95,-3410.96 3886.95,-3410.96 3886.95,-3350.96 3276.95,-3350.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3350.96 3276.95,-3410.96 3886.95,-3410.96 3886.95,-3350.96 3276.95,-3350.96"/>
<text text-anchor="start" x="3287.95" y="-3371.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">taxon_concept_id &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3372.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3290.96 3276.95,-3350.96 3886.95,-3350.96 3886.95,-3290.96 3276.95,-3290.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3290.96 3276.95,-3350.96 3886.95,-3350.96 3886.95,-3290.96 3276.95,-3290.96"/>
<text text-anchor="start" x="3287.83" y="-3311.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">primary_com_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3605.86" y="-3312.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3836.96" y="-3312.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.85" y="-3312.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3230.96 3276.95,-3290.96 3886.95,-3290.96 3886.95,-3230.96 3276.95,-3230.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3230.96 3276.95,-3290.96 3886.95,-3290.96 3886.95,-3230.96 3276.95,-3230.96"/>
<text text-anchor="start" x="3287.95" y="-3251.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">sci_name &#160;&#160;&#160;</text>
<text text-anchor="start" x="3605.76" y="-3252.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<text text-anchor="start" x="3836.86" y="-3252.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-3252.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3170.96 3276.95,-3230.96 3886.95,-3230.96 3886.95,-3170.96 3276.95,-3170.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3170.96 3276.95,-3230.96 3886.95,-3230.96 3886.95,-3170.96 3276.95,-3170.96"/>
<text text-anchor="start" x="3287.95" y="-3191.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">bird_order &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3192.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(30)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3110.96 3276.95,-3170.96 3886.95,-3170.96 3886.95,-3110.96 3276.95,-3110.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3110.96 3276.95,-3170.96 3886.95,-3170.96 3886.95,-3110.96 3276.95,-3110.96"/>
<text text-anchor="start" x="3287.95" y="-3131.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">family &#160;&#160;&#160;</text>
<text text-anchor="start" x="3644.86" y="-3132.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-3050.96 3276.95,-3110.96 3886.95,-3110.96 3886.95,-3050.96 3276.95,-3050.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-3050.96 3276.95,-3110.96 3886.95,-3110.96 3886.95,-3050.96 3276.95,-3050.96"/>
<text text-anchor="start" x="3287.95" y="-3071.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">species_group &#160;&#160;&#160;</text>
<text text-anchor="start" x="3644.86" y="-3072.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(100)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2990.96 3276.95,-3050.96 3886.95,-3050.96 3886.95,-2990.96 3276.95,-2990.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2990.96 3276.95,-3050.96 3886.95,-3050.96 3886.95,-2990.96 3276.95,-2990.96"/>
<text text-anchor="start" x="3287.95" y="-3011.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">report_as &#160;&#160;&#160;</text>
<text text-anchor="start" x="3662.64" y="-3012.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">VARCHAR(15)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2930.96 3276.95,-2990.96 3886.95,-2990.96 3886.95,-2930.96 3276.95,-2930.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2930.96 3276.95,-2990.96 3886.95,-2990.96 3886.95,-2930.96 3276.95,-2930.96"/>
<text text-anchor="start" x="3287.95" y="-2951.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_from &#160;&#160;&#160;</text>
<text text-anchor="start" x="3751.53" y="-2952.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<text text-anchor="start" x="3836.86" y="-2952.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c"> </text>
<text text-anchor="start" x="3845.75" y="-2952.16" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="32.00" fill="#29235c">(!)</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2870.96 3276.95,-2930.96 3886.95,-2930.96 3886.95,-2870.96 3276.95,-2870.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2870.96 3276.95,-2930.96 3886.95,-2930.96 3886.95,-2870.96 3276.95,-2870.96"/>
<text text-anchor="start" x="3287.95" y="-2891.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">valid_to &#160;&#160;&#160;</text>
<text text-anchor="start" x="3790.62" y="-2892.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">DATE</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2810.96 3276.95,-2870.96 3886.95,-2870.96 3886.95,-2810.96 3276.95,-2810.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2810.96 3276.95,-2870.96 3886.95,-2870.96 3886.95,-2810.96 3276.95,-2810.96"/>
<text text-anchor="start" x="3287.95" y="-2831.16" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">active &#160;&#160;&#160;</text>
<text text-anchor="start" x="3721.26" y="-2832.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#29235c">BOOLEAN</text>
<polygon fill="#e7e2dd" stroke="transparent" points="3276.95,-2750.96 3276.95,-2810.96 3886.95,-2810.96 3886.95,-2750.96 3276.95,-2750.96"/>
<polygon fill="none" stroke="#29235c" points="3276.95,-2750.96 3276.95,-2810.96 3886.95,-2810.96 3886.95,-2750.96 3276.95,-2750.96"/>
<text text-anchor="start" x="3309.87" y="-2772.16" font-family="Helvetica,sans-Serif" font-style="italic" font-size="32.00" fill="#1d71b8"> &#160;&#160;&#160;taxonomy_version, species_code &#160;&#160;&#160;</text>
<polygon fill="none" stroke="#29235c" stroke-width="2" points="3275.95,-2749.96 3275.95,-3771.96 3887.95,-3771.96 3887.95,-2749.96 3275.95,-2749.96"/>

Replacement in db/schema.svg at line 839 [3.172440]

B:BD[3.283269] → [4.106869:107131]

<path fill="none" stroke="#29235c" stroke-width="3" d="M3887.95,-2768.96C4010.88,-2768.96 4035.61,-2836.13 4153.16,-2839.8"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4153.24,-2843.31 4163.3,-2839.96 4153.35,-2836.31 4153.24,-2843.31"/>

[3.283269]

[4.107131]

<path fill="none" stroke="#29235c" stroke-width="3" d="M3887.95,-2780.96C4009.68,-2780.96 4036.7,-2836.78 4153.25,-2839.83"/>
<polygon fill="#29235c" stroke="#29235c" stroke-width="3" points="4153.25,-2843.33 4163.3,-2839.96 4153.34,-2836.33 4153.25,-2843.33"/>

Replacement in db/schema.svg at line 842 [3.172440]

B:BD[4.107260] → [4.107260:107389]

<text text-anchor="middle" x="3879.06" y="-2778.56" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>

[4.107260]

[3.283790]

<text text-anchor="middle" x="3879.06" y="-2790.56" font-family="Helvetica,sans-Serif" font-size="32.00" fill="#29235c">1</text>

Deletion in me.txt at line 10 [7.1]
∅:D[5.161] → [6.3663:3664]
B:BD[6.3663] → [6.3663:3664]
B:BD[6.3664] → [5.162:188]
```
pipe file list into tui??
```
Deletion in me.txt at line 12 [7.1]
B:BD[8.295] → [8.295:296]
∅:D[8.296] → [9.113:140]
B:BD[9.113] → [9.113:140]
```
tests for utils/mapping.go
```

Insertion in me.txt at line 371 [7.1]

[2.1239]


# db export not working anymore
(base) skraak ➤ duckdb db/test.duckdb
DuckDB v1.4.4 (Andium) 6ddac802ff
Enter ".help" for usage hints.
D select * from dataset;
┌──────────────┬──────────────────────┬───┬──────────────────────┬─────────┬──────────────────────┐
│      id      │         name         │ … │    last_modified     │ active  │         type         │
│   varchar    │       varchar        │   │ timestamp with tim…  │ boolean │ enum('structured',…  │
├──────────────┼──────────────────────┼───┼──────────────────────┼─────────┼──────────────────────┤
│ gljgxDbfasva │ Twenty Four Seven    │ … │ 2025-05-30 20:12:3…  │ true    │ structured           │
│ Yx0oNUDmP5ch │ Pomona - Kiwi        │ … │ 2025-06-29 15:28:4…  │ true    │ structured           │
│ wAJk9wuZN15x │ Bluemine - Kiwi      │ … │ 2025-06-29 15:28:5…  │ true    │ structured           │
│ jWS-sw5RvM-j │ Pure Salt - Kiwi     │ … │ 2025-06-30 08:36:1…  │ true    │ structured           │
│ QZ0tlUrX4Nyi │ Friends of Cobb - …  │ … │ 2025-06-02 05:46:1…  │ true    │ structured           │
│ la-JpAf2nLKG │ Manu o Kahurangi -…  │ … │ 2025-08-26 20:27:5…  │ true    │ structured           │
│ 0gQLE0Rq8c2J │ Moraine Creek - Kiwi │ … │ 2026-02-01 12:50:2…  │ true    │ structured           │
│ lbget6lz7zTi │ HCT - Kiwi           │ … │ 2026-02-01 13:06:3…  │ true    │ structured           │
│ RxajkKXz-w48 │ Lisa Whittle - Kiwi  │ … │ 2025-07-22 13:21:0…  │ true    │ structured           │
│ v7NY9PqEysb6 │ DOC Tier 1 Tokoeka…  │ … │ 2026-02-02 11:25:5…  │ true    │ structured           │
│ f24ajtZdbv5Y │ Tuning Fork Record…  │ … │ 2026-02-02 15:36:5…  │ true    │ structured           │
│ 60BF5sloxvNA │ Secretary Island     │ … │ 2026-02-03 07:44:4…  │ true    │ structured           │
│ hFBFNcqTsgp2 │ Wendy Ambury Bittern │ … │ 2026-02-03 14:47:0…  │ true    │ structured           │
│ ZhveWT897gpy │ Friends of Flora -…  │ … │ 2026-02-08 12:37:1…  │ true    │ structured           │
│ 4Sh8_7p1ocks │ Andrew Digby - LSK   │ … │ 2026-02-14 13:58:0…  │ true    │ unstructured         │
│ -xY_NuNbgQGO │ EventLogTest_17766…  │ … │ 2026-04-20 10:45:2…  │ true    │ structured           │
│ VOFJTXOypNso │ Bulk Import Test D…  │ … │ 2026-04-20 10:46:0…  │ true    │ structured           │
├──────────────┴──────────────────────┴───┴──────────────────────┴─────────┴──────────────────────┤
│ 17 rows                                                                     7 columns (5 shown) │
└─────────────────────────────────────────────────────────────────────────────────────────────────┘
D .quit
(base) skraak ➤ skraak export dataset --db db/test.duckdb --id 60BF5sloxvNA --output test.duckdb
Error: failed to copy species: Constraint Error: Violates foreign key constraint because key "species_code: morepo2, taxonomy_version: 2024" does not exist in the referenced table

Insertion in me.txt at line 405 [7.1]

[2.1240]

for @db/test.duckdb use the skraak cli sql cmd to check the species FK constraint below:\n CREATE TABLE species (
      id VARCHAR(12) PRIMARY KEY,
      label VARCHAR(100) UNIQUE NOT NULL,
      ebird_code VARCHAR(12),
      taxonomy_version VARCHAR(4),
      description VARCHAR(255),
      created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
      last_modified TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
      active BOOLEAN DEFAULT TRUE,
      FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)
  );