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;
Related tables
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