Photo Organizer

access_type

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

To enforce referential integrity.

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

CREATE TABLE access_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

None.

• album(access_rights) references identifier
• camera(access_rights) references identifier
• photo(access_rights) references identifier

• access_type_id_sequence

None.

None.

• view_camera
• view_film
• view_filter
• view_flash
• view_lens
• view_photo
• view_scanner
• view_support

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE access_type (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

= Version 2.5 =

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');