Photo Organizer

submission_status

CREATE TABLE submission_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

None.

• submission(status) references identifier

• submission_status_id_sequence

None.

None.

• view_submission

Version 2.5

Version 2.33

= Version 2.5 =

CREATE TABLE submission_status (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

= Version 2.34 =

DROP TABLE submission_status;

= Version 2.5 =

INSERT INTO submission_status VALUES (NEXTVAL('submission_status_id_sequence'), 'On stock');
INSERT INTO submission_status VALUES (NEXTVAL('submission_status_id_sequence'), 'Submitted');
INSERT INTO submission_status VALUES (NEXTVAL('submission_status_id_sequence'), 'Returned');
INSERT INTO submission_status VALUES (NEXTVAL('submission_status_id_sequence'), 'Sold');