- lab text not NULL unique,
- silo text not NULL unique,
+ lab varchar(255) not NULL unique,
+ silo varchar(255) not NULL unique,
CONSTRAINT id_pk PRIMARY KEY (id)
);
CREATE TABLE blueprint_layer
(
id bigint not NULL AUTO_INCREMENT,
CONSTRAINT id_pk PRIMARY KEY (id)
);
CREATE TABLE blueprint_layer
(
id bigint not NULL AUTO_INCREMENT,
(
id bigint not NULL AUTO_INCREMENT,
blueprint_id bigint not NULL,
(
id bigint not NULL AUTO_INCREMENT,
blueprint_id bigint not NULL,
CONSTRAINT id_pk PRIMARY KEY (id),
CONSTRAINT blueprint_id_fk FOREIGN KEY (blueprint_id)
REFERENCES blueprint (id) MATCH SIMPLE
CONSTRAINT id_pk PRIMARY KEY (id),
CONSTRAINT blueprint_id_fk FOREIGN KEY (blueprint_id)
REFERENCES blueprint (id) MATCH SIMPLE
CREATE TABLE w_robot_test_result
(
id bigint not NULL AUTO_INCREMENT,
CREATE TABLE w_robot_test_result
(
id bigint not NULL AUTO_INCREMENT,
validation_test_result_id bigint not NULL,
robot_test_results LONGTEXT,
CONSTRAINT id_pk PRIMARY KEY (id),
validation_test_result_id bigint not NULL,
robot_test_results LONGTEXT,
CONSTRAINT id_pk PRIMARY KEY (id),