CREATE TABLE protocols{
    id                  uuid            NOT NULL,
    code                VARCHAR(255),
    notes               VARCHAR(255),
    created_at          datetime,
    updated_at          datetime,
    fixation_target     uuid,
    is_active           BOOLEAN         DEFAULT TRUE,
    is_default          BOOLEAN         DEFAULT FALSE,
    PRIMARY KEY (id),
    FOREIGN KEY (fixation_target) REFERENCES fixation_targets(id)
};

CREATE TABLE protocols_execution{
    id                          uuid            NOT NULL,
    exam_id                     uuid            NOT NULL,
    serialized_protocol_data    VARCHAR(10000)  NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (exam_id) REFERENCES exams(id),
};

CREATE TABLE protocol_steps{
    id                  uuid            NOT NULL,
    protocol_id         uuid            NOT NULL,
    step_position       INT             NOT NULL,
    notes               VARCHAR(255),
    image_tipe          VARCHAR(255)    NOT NULL,
    number_of_frames    INT             NOT NULL,
    focus_shift         INT             DEFAULT 0,
    PRIMARY KEY (id)
    FOREIGN KEY (protocol_id) REFERENCES protocols(id),
};

CREATE TABLE protocol_data{
    id                      uuid            NOT NULL,
    image_id                uuid            NOT NULL,
    serialized_step_data    text            NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (image_id) REFERENCES images(id)
};