===== Database Table Description of "film_iso" =====

=== Name ===

film_iso

=== Description ===

=== Purpose ===

=== Schema ===

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

=== References tables ===

None.

=== Is referenced by tables ===

  * [[film_type sql table|film_type]](format) references identifier
  * [[photo_tech sql table|photo_tech]](iso_override) references identifier

=== Related sequences ===

  * [[film_iso_id_sequence sql sequence|film_iso_id_sequence]]

=== Related indexes ===

None.

=== Related functions ===

None.

=== Related views ===

  * [[view_film sql view|view_film]]
  * [[view_film_type sql view|view_film_type]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

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

== Data change history ==

= Version 2.5 =

<code sql>
insert into film_iso values (nextval('film_iso_id_sequence'), '6');
insert into film_iso values (nextval('film_iso_id_sequence'), '8');
insert into film_iso values (nextval('film_iso_id_sequence'), '10');
insert into film_iso values (nextval('film_iso_id_sequence'), '12');
insert into film_iso values (nextval('film_iso_id_sequence'), '16');
insert into film_iso values (nextval('film_iso_id_sequence'), '20');
insert into film_iso values (nextval('film_iso_id_sequence'), '25');
insert into film_iso values (nextval('film_iso_id_sequence'), '32');
insert into film_iso values (nextval('film_iso_id_sequence'), '40');
insert into film_iso values (nextval('film_iso_id_sequence'), '50');
insert into film_iso values (nextval('film_iso_id_sequence'), '80');
insert into film_iso values (nextval('film_iso_id_sequence'), '100');
insert into film_iso values (nextval('film_iso_id_sequence'), '125');
insert into film_iso values (nextval('film_iso_id_sequence'), '160');
insert into film_iso values (nextval('film_iso_id_sequence'), '200');
insert into film_iso values (nextval('film_iso_id_sequence'), '250');
insert into film_iso values (nextval('film_iso_id_sequence'), '320');
insert into film_iso values (nextval('film_iso_id_sequence'), '400');
insert into film_iso values (nextval('film_iso_id_sequence'), '500');
insert into film_iso values (nextval('film_iso_id_sequence'), '640');
insert into film_iso values (nextval('film_iso_id_sequence'), '800');
insert into film_iso values (nextval('film_iso_id_sequence'), '1000');
insert into film_iso values (nextval('film_iso_id_sequence'), '1250');
insert into film_iso values (nextval('film_iso_id_sequence'), '1600');
insert into film_iso values (nextval('film_iso_id_sequence'), '2000');
insert into film_iso values (nextval('film_iso_id_sequence'), '2500');
insert into film_iso values (nextval('film_iso_id_sequence'), '3200');
insert into film_iso values (nextval('film_iso_id_sequence'), '4000');
insert into film_iso values (nextval('film_iso_id_sequence'), '5000');
insert into film_iso values (nextval('film_iso_id_sequence'), '6400');
</code>

= Version 2.27 =

<code sql>
insert into film_iso values (nextval('film_iso_id_sequence'), '64');
alter table film_iso add column value_2 integer;
update film_iso set value_2 = to_number(value, '9999');
alter table film_iso drop column value;
alter table film_iso rename column value_2 to value;
</code>