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

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.1176391030.txt.gz · Last modified: 2007/04/12 15:17 by Luud