Photo Organizer

scan_bitdepth

CREATE TABLE scan_bitdepth (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(6)
);

None.

• photo_tech(scan_bitdepth) references identifier

• scan_bitdepth_id_sequence

None.

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE scan_bitdepth (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(6)
);

= Version 2.5 =

INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '8');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '12');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '14');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '16');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '18');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '24');
INSERT INTO scan_bitdepth VALUES (NEXTVAL('scan_bitdepth_id_sequence'), '32');