podoc:view_rating_sql_view
Database View Description of "view_rating"
Name
view_rating
Description
Purpose
Schema
CREATE VIEW view_rating AS SELECT rating.identifier, photo, users, date_of_creation, VALUE, first_name, last_name, comment, version FROM rating, users WHERE rating.users=users.identifier;
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE VIEW view_rating AS SELECT rating.identifier, photo, users, date_of_creation, VALUE, first_name, last_name FROM rating, users WHERE rating.users=users.identifier;
= Version 2.6 =
DROP VIEW view_rating; CREATE VIEW view_rating AS SELECT rating.identifier, photo, users, date_of_creation, VALUE, first_name, last_name, comment FROM rating, users WHERE rating.users=users.identifier;
= Version 2.34 =
DROP VIEW view_rating; CREATE VIEW view_rating AS SELECT rating.identifier, photo, users, date_of_creation, VALUE, first_name, last_name, comment, version FROM rating, users WHERE rating.users=users.identifier;
podoc/view_rating_sql_view.txt · Last modified: 2007/10/19 19:50 by Luud