===== Database Table Description of "film_type" =====

=== Name ===

film_type

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
create table film_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  iso                   integer not null references film_iso(identifier),
  format                integer not null references film_format(identifier),
  last_modified_date 	timestamp,
  last_modifying_users	integer references users(identifier)
);
</code>

=== References tables ===

  * format references [[film_format sql table|film_format]](identifier)
  * iso references [[film_iso sql table|film_iso]](identifier)
  * last_modifying_users references [[users sql table|users]](identifier)
  * manufacturer references [[manufacturer sql table|manufacturer]](identifier)

=== Is referenced by tables ===

  * [[film sql table|film]](type) references identifier

=== Related sequences ===

  * [[film_type_id_sequence sql sequence|film_type_id_sequence]]

=== Related indexes ===

  * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]]

=== Related functions ===

  * [[number_of_manufacturer_ref sql function|number_of_manufacturer_ref]]

=== 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

== Change history ==

= Version 2.5 =

<code sql>
create table film_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  iso                   integer not null references film_iso(identifier),
  format                integer not null references film_format(identifier),
  last_modified_date 	timestamp,
  last_modifying_users	integer references users(identifier)
);
</code>