User Tools

Site Tools


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;

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 15:50 by Luud