User Tools

Site Tools


podoc:view_client_sql_view

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
podoc:view_client_sql_view [2007/04/16 12:03]
Luud
podoc:view_client_sql_view [2007/04/20 11:39] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<​code>​+<​code ​sql>
 create view view_client as create view view_client as
   select client.identifier,​ client.users,​ client.client,​ users.last_name,​   select client.identifier,​ client.users,​ client.client,​ users.last_name,​
Line 27: Line 27:
   * [[client_status sql table|client_status]]   * [[client_status sql table|client_status]]
   * [[users sql table|users]]   * [[users sql table|users]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
  
 === History === === History ===
Line 48: Line 42:
 = Version 2.5 = = Version 2.5 =
  
-<​code>​+<​code ​sql>
 create view view_client as 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   select client.identifier,​ client.users,​ client.client,​ users.last_name,​ users.first_name,​ date_of_creation,​ client_status.value,​ client.status,​ users.type
Line 59: Line 53:
 = Version 2.19 = = Version 2.19 =
  
-<​code>​+<​code ​sql>
 drop view view_client;​ drop view view_client;​
 create view view_client as create view view_client as
podoc/view_client_sql_view.txt ยท Last modified: 2007/04/20 11:39 by Luud