podoc:view_rating_sql_view
This is an old revision of the document!
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 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;
podoc/view_rating_sql_view.1177338014.txt.gz · Last modified: 2007/04/23 14:20 by Luud