User Tools

Site Tools


podoc:film_sql_table

Differences

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

Link to this comparison view

Next revision
Previous revision
podoc:film_sql_table [2007/04/12 12:09] – created Luudpodoc:film_sql_table [2007/04/20 14:25] (current) Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "film" =====
  
 === Name === === Name ===
 +
 +film
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<code sql>
 +create table film (
 +  identifier            integer not null primary key,
 +  type                  integer not null references film_type(identifier),
 +  users                 integer not null references users(identifier),
 +  access_rights         integer not null references access_type(identifier)
 +);
 +</code>
 +
 +=== References tables ===
 +
 +  * access_rights references [[access_type sql table|access_type]](identifier)
 +  * type references [[film_type sql table|film_type]](identifier)
 +  * users references [[users sql table|users]](identifier)
 +
 +=== Is referenced by tables ===
 +
 +  * [[photo_tech sql table|photo_tech]](film) references identifier
  
 === Related sequences === === Related sequences ===
 +
 +  * [[film_id_sequence sql sequence|film_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +  * [[film_type_idx sql index|film_type_idx  ]]
 +  * [[film_users_idx sql index|film_users_idx  ]]
 +
 +=== Related functions ===
 +
 +  * [[count_equipment_by_user sql function|count_equipment_by_user]]
 +  * [[number_of_film_references sql function|number_of_film_references]]
 +
 +=== Related views ===
 +
 +  * [[view_film sql view|view_film]]
  
 === History === === History ===
Line 17: Line 52:
 == Used first == == Used first ==
  
-Verions 2.5+Version 2.5
  
 == Used last == == Used last ==
Line 27: Line 62:
 = Version 2.5 = = Version 2.5 =
  
-  create table ... +<code sql> 
-    ...   +create table film 
-  );+  identifier            integer not null primary key, 
 +  type                  integer not null references film_type(identifier), 
 +  users                 integer not null references users(identifier), 
 +  access_rights         integer not null references access_type(identifier) 
 +); 
 +</code> 
podoc/film_sql_table.1176379779.txt.gz · Last modified: 2007/04/12 12:09 by Luud