===== Database Table Description of "flash" =====

=== Name ===

flash

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
create table flash (
  identifier            integer not null primary key,
  type                  integer not null references flash_type(identifier),
  users                 integer not null references users(identifier),
  serial_number         varchar(20),
  date_of_purchase      timestamp,
  purchased_new         char(1) check (purchased_new in ('t', 'f')),
  access_rights         integer not null references access_type(identifier)
);
</code>

=== References tables ===

  * access_rights references [[access_type sql table|access_type]](identifier)
  * type references [[flash_type sql table|flash_type]](identifier)
  * users references [[users sql table|users]](identifier)

=== Is referenced by tables ===

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

=== Related sequences ===

  * [[flash_id_sequence sql sequence|flash_id_sequence]]

=== Related indexes ===

  * [[flash_type_idx sql index|flash_type_idx]]
  * [[flash_users_idx sql index|flash_users_idx]]

=== Related functions ===

  * [[count_equipment_by_user sql function|count_equipment_by_user]]
  * [[number_of_flash_references sql function|number_of_flash_references]]

=== Related views ===

  * [[view_flash sql view|view_flash]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

<code sql>
create table flash (
  identifier            integer not null primary key,
  type                  integer not null references flash_type(identifier),
  users                 integer not null references users(identifier),
  serial_number         varchar(20),
  date_of_purchase      timestamp,
  purchased_new         char(1) check (purchased_new in ('t', 'f')),
  access_rights         integer not null references access_type(identifier)
);
</code>

== Data change history ==