| CREATE TABLE peer_checks ( | |
| peer_id UUID NOT NULL, | |
| id UUID DEFAULT gen_random_uuid(), | |
| check_name STRING NOT NULL, | |
| check_time INT NOT NULL, | |
| check_status STRING check ( | |
| check_status = 'unknown' or | |
| check_status = 'okay' or | |
| check_status = 'failed' | |
| ) NOT NULL, | |
| check_message STRING NOT NULL, | |
| delete BOOL NOT NULL, | |
| UNIQUE(peer_id, check_name), | |
| PRIMARY KEY (peer_id, id), | |
| CONSTRAINT fk_peer FOREIGN KEY (peer_id) REFERENCES peers (id) ON DELETE CASCADE | |
| ) INTERLEAVE IN PARENT peers (peer_id); |