User Tools

Site Tools


podoc:state_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:state_sql_table [2007/04/19 08:54]
Luud
podoc:state_sql_table [2007/04/20 13:39]
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table state ( +<code sql> 
-    identifier            integer not null primary key, +create table state ( 
-    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]](state) references identifier 
 +  * [[location sql table|location]](state) references identifier
  
 === Related sequences === === Related sequences ===
Line 47: Line 58:
 = Version 2.5 = = Version 2.5 =
  
-  create table state ( +<code sql> 
-    identifier            integer not null primary key, +create table state ( 
-    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 57: Line 70:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into state values (nextval('state_id_sequence'), 'AL', 'Alabama'); insert into state values (nextval('state_id_sequence'), 'AL', 'Alabama');
 insert into state values (nextval('state_id_sequence'), 'AK', 'Alaska'); insert into state values (nextval('state_id_sequence'), 'AK', 'Alaska');
podoc/state_sql_table.txt · Last modified: 2007/04/20 13:39 by Luud