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/12 12:13] Luudpodoc:film_type_sql_table [2007/04/20 12:42] (current) Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "film_type" =====
  
 === Name === === Name ===
 +
 +film_type
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<code sql>
 +create table film_type (
 +  identifier            integer not null primary key,
 +  manufacturer          integer not null references manufacturer(identifier),
 +  model                 varchar(100),
 +  iso                   integer not null references film_iso(identifier),
 +  format                integer not null references film_format(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 ===
 +
 +  * [[film_type_id_sequence sql sequence|film_type_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +  * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]]
  
 === Related functions === === Related functions ===
 +
 +  * [[number_of_manufacturer_ref sql function|number_of_manufacturer_ref]]
 +
 +=== Related views ===
 +
 +  * [[view_film sql view|view_film]]
 +  * [[view_film_type sql view|view_film_type]]
  
 === History === === History ===
Line 29: Line 65:
 = Version 2.5 = = Version 2.5 =
  
-  create table ... +<code sql> 
-    ...   +create table film_type 
-  );+  identifier            integer not null primary key, 
 +  manufacturer          integer not null references manufacturer(identifier), 
 +  model                 varchar(100), 
 +  iso                   integer not null references film_iso(identifier), 
 +  format                integer not null references film_format(identifier), 
 +  last_modified_date timestamp, 
 +  last_modifying_users integer references users(identifier) 
 +); 
 +</code>
podoc/film_type_sql_table.1176380037.txt.gz · Last modified: 2007/04/12 12:13 by Luud