Enum_DataType1
 
CREATE TYPE enum_fruit_color AS
ENUM ('blue','Dark Navy','Light Red','Yellow');
CREATE TABLE fruit_type
(name TEXT,
fruit_color enum_fruit_color);

INSERT INTO fruit_type VALUES ('Blue-Berry','Dark Navy');
INSERT INTO fruit_type VALUES ('Straw-Berry','Light Red');
INSERT INTO fruit_type VALUES ('Banana','Yellow');