podoc:access_type_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:access_type_sql_table [2007/04/13 09:15] – Luud | podoc:access_type_sql_table [2007/04/20 15:23] (current) – Luud | ||
---|---|---|---|
Line 6: | Line 6: | ||
=== Description === | === Description === | ||
+ | |||
+ | Contains a mapping of ' | ||
=== Purpose === | === Purpose === | ||
+ | |||
+ | To enforce referential integrity. | ||
+ | |||
+ | * Note, this table will go away as part of the permission model rewrite (see [[pobug> | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table access_type ( |
- | value | + | identifier |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 === | === Related sequences === | ||
Line 21: | Line 45: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === 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 === | === History === | ||
Line 40: | Line 77: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table access_type ( |
- | value | + | identifier |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 49: | Line 88: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into access_type values (nextval(' | insert into access_type values (nextval(' | ||
insert into access_type values (nextval(' | insert into access_type values (nextval(' | ||
insert into access_type values (nextval(' | insert into access_type values (nextval(' | ||
</ | </ | ||
+ |
podoc/access_type_sql_table.1176455701.txt.gz · Last modified: 2007/04/13 09:15 by Luud