DBExemple

CREATE TABLE Data
    ([ID] int, [Color] varchar(6), [Type] varchar(5), [Type2] varchar(4), [Name] varchar(7), [Sci_Name] varchar(5), [Version] varchar(20), [Date] datetime, [Foreign_ID] int)
;

INSERT INTO Data
    ([ID], [Color], [Type], [Type2], [Name], [Sci_Name], [Version], [Date], [Foreign_ID])
VALUES
    (1, 'Red', 'Type1', NULL, 'Monica', 'Life', 'software version 7.0', '2017-09-10 02:00:00', 4),
    (2, 'Blue', 'Type2', NULL, 'Erica', 'Side', 'software version 7.0', '2017-09-10 02:00:00', 5),
    (3, 'Yellow', 'Type2', NULL, 'Rita', 'Need', 'software version 7.0', '2017-09-10 02:00:00', 6),
    (4, 'Red', 'Type1', NULL, 'Tina', 'See', 'software version 7.0', '2017-09-10 02:00:00', 7),
    (5, 'Red', 'Type1', NULL, 'Sandra', 'Sun', 'software version 7.0', '2017-09-10 02:00:00', 1),
    (6, 'Blue', 'Type1', NULL, 'Mary', 'Night', 'software version 7.0', '2017-09-10 02:00:00', 2),
    (7, 'Yellow', 'Type2', NULL, 'Jessica', 'Here', 'software version 7.0', '2017-09-10 02:00:00', 5)
;

CREATE TABLE Parameter
    ([Column_Name] varchar(9), [ByteValue] int)
;
INSERT INTO Parameter
    ([Column_Name], [ByteValue])
VALUES
    ('Color', 0),
    ('Type', 1),
    ('Type2', 2),
    ('Name', 3),
    ('Sci_Name', 4),
    ('Alias', 5),
    ('Version', 6),
    ('Firmware', 7),
    ('Brand', 8),
    ('Avaidable', 9)
;