User Tools

Site Tools


podoc:film_type_sql_table

This is an old revision of the document!


Database Table Description of "film_type"

Name

film_type

Description

Purpose

Schema

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 ===
 
  * [[film_type_id_sequence SQL SEQUENCE|film_type_id_sequence]]
 
=== Related indexes ===
 
  * [[film_type_manufacturer_idx SQL INDEX|film_type_manufacturer_idx]]
 
=== 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 ===
 
== Used FIRST ==
 
Version 2.5
 
== Used LAST ==
 
Still IN USE
 
== CHANGE history ==
 
= Version 2.5 =
 
<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)
);
podoc/film_type_sql_table.1177072909.txt.gz · Last modified: 2007/04/20 12:41 by Luud