User Tools

Site Tools


podoc:view_client_sql_view

Database View Description of "view_client"

Name

view_client

Description

Purpose

Schema

CREATE VIEW view_client AS
  SELECT client.identifier, client.users, client.client, users.last_name,
         users.first_name, date_of_creation, client_status.value, client.status, users.type,
         client.trusted
    FROM client, users, client_status
   WHERE client.client = users.identifier
     AND client.status = client_status.identifier
   ORDER BY users.last_name, users.first_name;

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

CREATE VIEW view_client AS
  SELECT client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status, users.type
    FROM client, users, client_status
   WHERE client.client = users.identifier
     AND client.status = client_status.identifier
   ORDER BY users.last_name, users.first_name;

= Version 2.19 =

DROP VIEW view_client;
CREATE VIEW view_client AS
  SELECT client.identifier, client.users, client.client, users.last_name,
         users.first_name, date_of_creation, client_status.value, client.status, users.type,
         client.trusted
    FROM client, users, client_status
   WHERE client.client = users.identifier
     AND client.status = client_status.identifier
   ORDER BY users.last_name, users.first_name;
podoc/view_client_sql_view.txt · Last modified: 2007/04/20 15:39 by Luud