User Tools

Site Tools


podoc:film_type_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:film_type_sql_table [2007/04/19 08:35] Luudpodoc:film_type_sql_table [2007/04/20 12:42] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table film_type ( +<code sql> 
-    identifier            integer not null primary key, +create table film_type ( 
-    manufacturer          integer not null references manufacturer(identifier), +  identifier            integer not null primary key, 
-    model                 varchar(100), +  manufacturer          integer not null references manufacturer(identifier), 
-    iso                   integer not null references film_iso(identifier), +  model                 varchar(100), 
-    format                integer not null references film_format(identifier), +  iso                   integer not null references film_iso(identifier), 
-    last_modified_date timestamp, +  format                integer not null references film_format(identifier), 
-    last_modifying_users integer references users(identifier) +  last_modified_date timestamp, 
-  );+  last_modifying_users integer references users(identifier) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +  * format references [[film_format sql table|film_format]](identifier) 
 +  * iso references [[film_iso sql table|film_iso]](identifier) 
 +  * last_modifying_users references [[users sql table|users]](identifier) 
 +  * manufacturer references [[manufacturer sql table|manufacturer]](identifier) 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[film sql table|film]](type) references identifier
  
 === Related sequences === === Related sequences ===
Line 52: Line 65:
 = Version 2.5 = = Version 2.5 =
  
-  create table film_type ( +<code sql> 
-    identifier            integer not null primary key, +create table film_type ( 
-    manufacturer          integer not null references manufacturer(identifier), +  identifier            integer not null primary key, 
-    model                 varchar(100), +  manufacturer          integer not null references manufacturer(identifier), 
-    iso                   integer not null references film_iso(identifier), +  model                 varchar(100), 
-    format                integer not null references film_format(identifier), +  iso                   integer not null references film_iso(identifier), 
-    last_modified_date timestamp, +  format                integer not null references film_format(identifier), 
-    last_modifying_users integer references users(identifier) +  last_modified_date timestamp, 
-  ); +  last_modifying_users integer references users(identifier) 
 +); 
 +</code>
podoc/film_type_sql_table.txt · Last modified: 2007/04/20 12:42 by Luud