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) ); <code> === Related sequences === * [[location_id_sequence sql sequence|location_id_sequence]] === Related indexes === === Related functions === === Related views === === History === == Used first == Version 2.5 == Used last == Still in use == Schema change history == = Version 2.5 = <code> 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.1176814570.txt.gz · Last modified: 2007/04/17 12:56 by Luud