===== Database Table Description of "access_type" =====

=== Name ===

access_type

=== Description ===

Contains a mapping of 'permissions' to textual names of those pemissions.

=== Purpose ===

To enforce referential integrity.

* Note, this table will go away as part of the permission model rewrite (see [[pobug>8]])

=== Schema ===

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

=== References tables ===

None.

=== Is referenced by tables ===

  * [[album sql table|album]](access_rights) references identifier
  * [[camera sql table|camera]](access_rights) references identifier
  * [[film sql table|film]](access_rights) references identifier
  * [[filter sql table|filter]](access_rights) references identifier
  * [[flash sql table|flash]](access_rights) references identifier
  * [[folder sql table|folder]](access_rights) references identifier
  * [[photo sql table|photo]](access_rights) references identifier
  * [[scanner sql table|scanner]](access_rights) references identifier
  * [[support sql table|support]](access_rights) references identifier

=== Related sequences ===

  * [[access_type_id_sequence sql sequence|access_type_id_sequence]]

=== Related indexes ===

None.

=== Related functions ===

None.

=== Related views ===

  * [[view_camera sql view|view_camera]]
  * [[view_film sql view|view_film]]
  * [[view_filter sql view|view_filter]]
  * [[view_flash sql view|view_flash]]
  * [[view_lens sql view|view_lens]]
  * [[view_photo sql view|view_photo]]
  * [[view_scanner sql view|view_scanner]]
  * [[view_support sql view|view_support]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Schema change history ==

= Version 2.5 =

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

== Data change history ==

= Version 2.5 =

<code sql>
insert into access_type values (nextval('access_type_id_sequence'), 'Public');
insert into access_type values (nextval('access_type_id_sequence'), 'Protected');
insert into access_type values (nextval('access_type_id_sequence'), 'Private');
</code>