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
Related sequences
Related indexes
None.
Related functions
None.
Related views
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 15:23 by Luud