User Tools

Site Tools


podoc:country_sql_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:country_sql_table [2007/04/13 09:34]
Luud
podoc:country_sql_table [2007/04/20 13:40] (current)
Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +A list of all countries in the world.
  
 === Purpose === === Purpose ===
 +
 +Referential integrity.  
  
 === Schema === === Schema ===
  
-  create table country ( +<code sql> 
-    identifier            integer not null primary key, +create table country ( 
-    code                  varchar(5), +  identifier            integer not null primary key, 
-    value                 varchar(40) +  code                  varchar(5), 
-  );+  value                 varchar(40) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[contact_info sql table|contact_info]](country) references identifier 
 +  * [[location sql table|location]](country) references identifier
  
 === Related sequences === === Related sequences ===
Line 22: Line 37:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 41: Line 62:
 = Version 2.5 = = Version 2.5 =
  
-  create table country ( +<code sql> 
-    identifier            integer not null primary key, +create table country ( 
-    code                  varchar(5), +  identifier            integer not null primary key, 
-    value                 varchar(40) +  code                  varchar(5), 
-  );+  value                 varchar(40) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 51: Line 74:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into country values (nextval('country_id_sequence'), 'ad', 'Andorra'); insert into country values (nextval('country_id_sequence'), 'ad', 'Andorra');
 insert into country values (nextval('country_id_sequence'), 'ae', 'United Arab Emirates'); insert into country values (nextval('country_id_sequence'), 'ae', 'United Arab Emirates');
podoc/country_sql_table.1176456887.txt.gz · Last modified: 2007/04/13 09:34 by Luud