By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Code (
PIN TEXT NOT NULL,
title TEXT,
CHECK(title GLOB '[0-9][0-9][0-9][0-9][0-9]')
);
✓
INSERT INTO Code VALUES ('pin1', '12345')
✓
INSERT INTO Code VALUES ('pin1', '1234')
{ "code": "SQLITE_CONSTRAINT_CHECK" }
INSERT INTO Code VALUES ('pin1', '123456')
{ "code": "SQLITE_CONSTRAINT_CHECK" }
INSERT INTO Code VALUES ('pin1', '12x45')
{ "code": "SQLITE_CONSTRAINT_CHECK" }