User Tools

Site Tools


podoc:film_format_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
podoc:film_format_sql_table [2007/04/19 08:36] Luudpodoc:film_format_sql_table [2007/04/20 12:45] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table film_format ( +<code sql> 
-    identifier            integer not null primary key, +create table film_format ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[film_type sql table|film_type]](format) references identifier
  
 === Related sequences === === Related sequences ===
Line 47: Line 57:
 = Version 2.5 = = Version 2.5 =
  
-  create table film_format ( +<code sql> 
-    identifier            integer not null primary key, +create table film_format ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 56: Line 68:
 = version 2.5 = = version 2.5 =
  
-<code>+<code sql>
 insert into film_format values (nextval('film_format_id_sequence'), 'APS'); insert into film_format values (nextval('film_format_id_sequence'), 'APS');
 insert into film_format values (nextval('film_format_id_sequence'), '24x35 mm'); insert into film_format values (nextval('film_format_id_sequence'), '24x35 mm');
podoc/film_format_sql_table.txt · Last modified: 2007/04/20 12:45 by Luud