User Tools

Site Tools


podoc:access_type_sql_table

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 8)

Schema

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

References tables

None.

Is referenced by tables

  • album(access_rights) references identifier
  • camera(access_rights) references identifier
  • film(access_rights) references identifier
  • filter(access_rights) references identifier
  • flash(access_rights) references identifier
  • folder(access_rights) references identifier
  • photo(access_rights) references identifier
  • scanner(access_rights) references identifier
  • support(access_rights) references identifier

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

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

= 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');
podoc/access_type_sql_table.txt · Last modified: 2007/04/20 11:23 by Luud