podoc:location_sql_table
This is an old revision of the document!
Database Table Description of "location"
Name
location
Description
Purpose
Schema
create table location ( -- location is the place the photo was taken identifier integer not null primary key, place varchar(300), state integer references state(identifier), country integer references country(identifier), last_modified_date timestamp, last_modifying_users integer references users(identifier), city varchar(300), latitude varchar(10), longitude varchar(10) );
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
create table location ( -- location is the place the photo was taken identifier integer not null primary key, place varchar(300), state integer references state(identifier), country integer references country(identifier), last_modified_date timestamp, last_modifying_users integer references users(identifier), city varchar(300), latitude varchar(10), longitude varchar(10) );
Data change history
= Version 2.31 =
-- Ensure referential integrity with the locations. insert into location (identifier, place) values (0, 'Unknown');
podoc/location_sql_table.1176816919.txt.gz · Last modified: 2007/04/17 13:35 by Luud