podoc:view_location_sql_view
Database View Description of "view_location"
Name
view_location
Description
Purpose
Schema
CREATE VIEW view_location AS SELECT location.identifier, location.place, location.city, (SELECT VALUE FROM state WHERE state.identifier=location.state) AS state, (SELECT VALUE FROM country WHERE country.identifier=location.country) AS country, users, last_modified_date, latitude, longitude, private FROM location;
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE VIEW view_location AS SELECT location.identifier, location.place, location.city, (SELECT VALUE FROM state WHERE state.identifier=location.state) AS state, (SELECT VALUE FROM country WHERE country.identifier=location.country) AS country, last_modifying_users, last_modified_date, latitude, longitude FROM location;
= Version 2.33 =
DROP VIEW view_location; CREATE VIEW view_location AS SELECT location.identifier, location.place, location.city, (SELECT VALUE FROM state WHERE state.identifier=location.state) AS state, (SELECT VALUE FROM country WHERE country.identifier=location.country) AS country, users, last_modified_date, latitude, longitude, private FROM location;
podoc/view_location_sql_view.txt · Last modified: 2007/04/20 16:16 by Luud