===== Database Table Description of "submission_status" =====

=== Name ===

submission_status

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
create table submission_status (
  identifier            integer not null primary key,
  value                 varchar(10)
);
</code>

=== References tables ===

None.

=== Is referenced by tables ===

  * [[submission sql table|submission]](status) references identifier

=== Related sequences ===

  * [[submission_status_id_sequence sql sequence|submission_status_id_sequence]]

=== Related indexes ===

None.

=== Related functions ===

None.

=== Related views ===

  * [[view_submission sql view|view_submission]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Version 2.33

== Schema change history ==

= Version 2.5 =

<code sql>
create table submission_status (
  identifier            integer not null primary key,
  value                 varchar(10)
);
</code>

= Version 2.34 =

<code sql>
drop table submission_status;
</code>

== Data change history ==

= Version 2.5 =

<code sql>
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');
</code>