podoc:access_type_sql_table
This is an old revision of the document!
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
- photo(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.1177068374.txt.gz · Last modified: 2007/04/20 11:26 by Luud