===== Database Table Description of "flash_type" =====

=== Name ===

flash_type

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
create table flash_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  variation             varchar(100),
  last_modified_date 	  timestamp,
  last_modifying_users  integer references users(identifier)
);
</code>

=== References tables ===

  * last_modifying_users references [[users sql table|users]](identifier)
  * manufacturer references [[manufacturer sql table|manufacturer]](identifier)

=== Is referenced by tables ===

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

=== Related sequences ===

  * [[flash_type_id_sequence sql sequence|flash_type_id_sequence]]

=== Related indexes ===

  * [[flash_type_manufacturer_idx sql index|flash_type_manufacturer_idx]]

=== Related functions ===

  * [[number_of_manufacturer_ref sql function|number_of_manufacturer_ref]]

=== Related views ===

  * [[view_flash sql view|view_flash]]
  * [[view_flash_type sql view|view_flash_type]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

<code sql>
create table flash_type (
  identifier            integer not null primary key,
  manufacturer          integer not null references manufacturer(identifier),
  model                 varchar(100),
  variation             varchar(100),
  last_modified_date 	timestamp,
  last_modifying_users	integer references users(identifier)
);
</code>

== Data change history ==