User Tools

Site Tools


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