Recursive Codes

[jankapunkt]

We need to support recursive codes to a (theoretically) infinite level of nesting.

[alessandrobelli]

Database-wise it's already possible. I will link the docs as soon as they're online, but this is the code model, where the parent_id is creating the recursion.

erDiagram
    CODEBOOK ||--o{ CODES : "contains many"
    CODES {
        char id PK "char(36), Not Null, Default 'uuid()', DEFAULT_GENERATED"
        varchar name "varchar(255), Not Null"
        varchar color "varchar(255), Not Null"
        bigint codebook_id FK "bigint unsigned, Not Null, MUL"
        text description "text, Nullable"
        char parent_id FK "char(36), Nullable, MUL"
    }

    CODES ||--o{ CODES : "can have one parent"
    CODEBOOK {
        bigint id PK "bigint unsigned, Not Null"
    }

Loading