User Tools

Site Tools


podoc:submission_status_sql_table

Database Table Description of "submission_status"

Name

submission_status

Description

Purpose

Schema

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

References tables

None.

Is referenced by tables

None.

None.

History

Used first

Version 2.5

Used last

Version 2.33

Schema change history

= Version 2.5 =

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

= Version 2.34 =

DROP TABLE submission_status;
Data change history

= 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');
podoc/submission_status_sql_table.txt · Last modified: 2007/10/19 15:55 by Luud