User Tools

Site Tools


podoc:film_type_sql_table

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)
);

References tables

Is referenced by tables

  • film(type) references identifier

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

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.txt · Last modified: 2007/04/20 08:42 by Luud